Amit Oracle DBA Blog
This blog is to share oracle concept and real time experience for Oracle beginner.....
Friday, 23 October 2015
How to find the last RMAN backup’s log?
›
set pagesize 2000 set linesize 2000 select output from GV$RMAN_OUTPUT where session_recid = ( select session_reci...
Wednesday, 14 October 2015
oracle script to check the database growth
›
SET LINESIZE 200 SET PAGESIZE 200 COL "Database Size" FORMAT a13 COL "Used Space" FORMAT a11 COL "Used in...
20 comments:
Sunday, 4 October 2015
SHUTDOWN: waiting for active calls to complete.
›
Issue: Active call for process 1993 user ‘oraprod’ program ‘ oracleprod@prod ’ Active call for process 18672 user ‘oraprod’ program ‘o...
Wednesday, 30 September 2015
Move a datafile with RMAN
›
Using RMAN is the best way before 12c to relocate a datafile with a minimum downtime. The only downtime is for switching from the old data...
Monday, 28 September 2015
ora-01244: unnamed datafile(s) added to control file by media recovery
›
Cause: Media recovery with a backup control file or a control file that was rebuilt, encountered the creation of a datafile that was no...
Wednesday, 23 September 2015
SQL Tuning Advisor for SQL_ID
›
Here we are going to discuss how to do SQL Tuning Advisor for SQL_ID. 1.Create SQL Tuning Advisor task DECLARE my_task_name...
1 comment:
‹
›
Home
View web version
