11g RMAN Cloning using Duplicate Command Today I was given a task to perform Rman cloning from server prod to Dev. NOTE: Here i’m doing backup based Duplication instead of […]

Database Issues & Solutions  How to find high CPU using sessions in Oracle Database If the problem relates to CPU bound applications then CPU information for each session can be […]

DBA Views Queries —————————————-         select * from dict; select * from cat; TABLE COLUMNS ———————————————– select * from dba_tab_columns where table_name = ‘table_name’; CONSTRAINTS ——————————————————————————– select table_name, constraint_name, constraint_type, status […]

SRVCTL /SCAN COMMANDS How to STOP the Oracle RAC resources: ———————————— #srvctl stop instance -d -n #srvctl stop vip -n -f How to check current VIP configuration: ————————————– $srvctl config […]

　 Datbase-  SIZE,Schema-size,Table Size 　 col “Database Size” format a20 col “Free space” format a20 col “Used space” format a20 select    round(sum(used.bytes) / 1024 / 1024 / 1024 ) || […]

Session related Queries Last/Latest Running SQL ———————– set pages 50000 lines 32767 col “Last SQL” for 100 SELECT t.inst_id,s.username, s.sid, s.serial#,t.sql_id,t.sql_text “Last SQL” FROM gv$session s, gv$sqlarea t WHERE s.sql_address […]

In general there are three steps involved in restoring files: Ensure that the target database is started in the appropriate mode for the restoration operation. For lost control files, this […]

November 26, 2013 JOBS Scheduler jobs set lines 300 pages 100 col JOB_ACTION for a50 select job_name, owner,job_action,state,NEXT_RUN_DATE from dba_scheduler_jobs; enable a broken job (use this to enable job in […]

• Maximum Availability: Transactions on the primary do not commit until redo information has been written to the online redo log and the standby redo logs of at least one standby […]