Test Case: Oracle Event 10224 – index block split/delete trace
This event can be used to dump index block splits and deletes : alter system set events ’10224 trace name context forever, level 2′
BUGMAN( RMAN) BUG: RMAN-20242 Duplicate from active database 11g
I was trying to duplicate production database to development using 11g feature DUPLICATE DATABASE … FROM ACTIVE DATABASE . I did it in the past and worked every time but not today.. e.g. RUN { ALLOCATE CHANNEL ch1 DEVICE TYPE disk; ALLOCATE AUXILIARY CHANNEL ach1 DEVICE TYPE disk; duplicate target database to test from … Read more
Looking at Oracle cursor from oposite side
We are all familiar with cursor flow:open ,parse, binds, define,execute, fetch,variable, close.. I have used Oracle errorstack at level 3 (level 2 + context area ) to dump cursor at different life stages…
Script to extract sql code from trace file : trimsql.sh
Script to extract sql code from trace file generated using event 10046 e.g. SQL> oradebug setmypid SQL> oradebug event 10046 trace name context forever, level 12 or SQL> alter session set events ’10046 trace name context forever, level 12′; Find a trace: SQL> oradebug tracefile_name; /ora-main/app/oracle/admin/trace/demo11g_ora_19736.trc Then run script like: trimsql.sh <tracefile_name>
Pin anonymous block using dbms_shared_pool package.
How to pin anonymous block using dbms_shared_pool package ? If we look at dbms_shared_pool.keep procedure dbms_shared_pool.keep(name IN VARCHAR2,flag IN CHAR DEFAULT ‘P’); these are the objects that can be pinned Flag Values C cursor JC java class JD java shared data JR java resource JS java source P procedure Q sequence R trigger T type
