For undo ———— set lines 130 col SID_SERIAL format a20 col PROGRAM format a25 col Undo format a30 SELECT TO_CHAR(s.sid)||’,’||TO_CHAR(s.serial#) sid_serial, NVL(s.username, ‘None’) orauser, s.program, r.name undoseg, t.used_ublk * TO_NUMBER(x.value)/1024||’K’…
Read MoreFor the purpose of demonstration, I will clone an existing 11.2.0.2 (11gR2) ORACLE_HOME on the source server. Directories Needed: —————————— Source Server: ———————– hostname=source.com ORACLE_BASE=/opt/app/oracle ORACLE_HOME=/opt/app/oracle/product/11.2.0.2 Staging Directory = /home/oracle/clone…
Read MoreSolution for kcratr_nab_less_than_odr argument This error may cause due to improper shutdown and will throws the error ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr] while issuing the command alter database open Option…
Read More1 – Add initialization parameters & bounce instance: alter system set audit_trail=db scope=spfile; audit_file_dest=’/u01/app/oracle/mysid/mydir/’ 2 – Enable auditing of failed logion attempts : SQL> audit create session whenever not successful;…
Read MoreOracle 11g introduces adrci tool. This tool is used to examine contents of ADR repository and also to package information related to a specific problem into a compressed (zip) file…
Read MoreManaging CPU usage can be an issue when trying to consolidate multiple databases on to a single server, because if one database starts to hog all the CPU on the…
Read More