Test Case: Oracle Event 10224 – index block split/delete trace
October 28, 2008 2 Comments
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
October 22, 2008 2 Comments
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 active database;
}
Scripts will run fine until end and then RMAN will give error
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archived log in the recovery catalog Read more of this post
Looking at Oracle cursor from oposite side
October 15, 2008 2 Comments
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… Read more of this post
Script to extract sql code from trace file : trimsql.sh
October 9, 2008 1 Comment
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> Read more of this post
Pin anonymous block using dbms_shared_pool package.
October 6, 2008 Leave a Comment
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
Filesystem benchmark tools- IOzone
October 3, 2008 Leave a Comment
Last few days am doing my own research related to disks, i/o etc.. All theory is just theory until you prove it.. so best way to do it is to run some tests and collect information .. Fortunately for us there are free benchmark tools.
Today I got a chance to play with IOzone ( thanks to my Linux admin) and would like to share few key points when using this tool.. Read more of this post
Linux bug 405781 in OEL 4/RH 4 , OEL 5/ RH 5 reboots RAC node!
October 1, 2008 Leave a Comment
RAC node reboots and all you can see are messages
Oracle clsomon failed with fatal status 13.
Oracle CRS failure. Rebooting for cluster integrity
then you dig every clusterware logs and Oracle bugs but problem is somewhere else.. Read more of this post
Recent Comments