• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General

How to backup controlfile in RMAN in Oracle Database

May 6, 2022 by techgoeasy Leave a Comment

Controlfile is an important part of the Oracle database and backing up the control file is a necessary operation. Here is How to backup controlfile in RMAN How to enable auto backup of controlfile We can enable auto backup of the controlfile using RMAN settings. This will an auto backup of the control file after […]

Filed Under: Oracle, Oracle Database

How to check RMAN backup status in sql

May 6, 2022 by techgoeasy Leave a Comment

We can check RMAN backup status in sql using the below sql col STATUS format a9 col hrs format 999.99 select SESSION_KEY,SESSION_RECID,SESSION_STAMP, INPUT_TYPE, STATUS, to_char(START_TIME,’mm/dd/yy hh24:mi’) start_time, to_char(END_TIME,’mm/dd/yy hh24:mi’) end_time, elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS order by session_key; This is very helpful when you are operating in a DBCS(Database Cloud Service) environment with automated backup. The […]

Filed Under: Oracle, Oracle Database

how to resolve library cache pin in oracle

May 3, 2022 by techgoeasy Leave a Comment

In this post, we will see what is library cache pin and how to resolve library cache pin in oracle What is library cache Pin In the library cache, a database object is cached in 2 parts: “handle” and “object”. Library cache lock works on Handle and the Library cache pin is only held when […]

Filed Under: Oracle, Oracle Database

How to resolve library cache lock in oracle

May 3, 2022 by techgoeasy Leave a Comment

This post is about library cache lock and How to resolve library cache lock in oracle What is library cache lock This is used to control concurrency between clients of the library cache by acquiring a lock on the object handle. Uses are(a)One client can prevent other clients from accessing the same object(b)The client can […]

Filed Under: Oracle, Oracle Database

MySQL Auto Increment and reset

May 1, 2022 by techgoeasy Leave a Comment

Auto Increment Column is a quite common requirement in the coding. Here are some of the ways to get that in MySQL . we will also check about MySQL Auto Increment reset Auto Increment Column MySQL database The AUTO_INCREMENT attribute can be used to generate a unique identity for new rows Example use techdb; CREATE […]

Filed Under: mysql, Web development

MySQL COALESCE and NULLIF Function

May 1, 2022 by techgoeasy Leave a Comment

We will be discussing MySQL COALESCE and NULLIF Function in this post. We will also be showing  MySQL COALESCE  examples and NULLIF MySQL Function example MySQL COALESCE Function COALESCE  in MySQL is a very useful function to select first not null values from the list of values Syntax COALESCE(val1, val2,val3,…valn) The above syntax is equivalent […]

Filed Under: mysql Tagged With: MySQL COALESCE, NULLIF Function

  • « Previous Page
  • Page 1
  • Page 2
  • Page 3
  • Page 4
  • …
  • Page 107
  • Next Page »

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to find weblogic version in Unix & Windows
  • How to use RMAN Catalog Command
  • Oracle drm interview questions
  • How to use RMAN Crosscheck command
  • Oracle Data Relationship Management: Definition, Password , Login

Copyright © 2022 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us