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 […]
How to check RMAN backup status in sql
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 […]
how to resolve library cache pin in oracle
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 […]
How to resolve library cache lock in oracle
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 […]
MySQL Auto Increment and reset
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 […]
MySQL COALESCE and NULLIF Function
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 […]