Kernel Files Editor (KFED )and KFOD ( OSM Discovery utility )

Posted by oraclue on March 10, 2009 · 3 Comments 

A friend of mine had a problem with ASM instance when disks got corruped and crashed…I mention to him that he can use  KFED&KFOD utilities to get usefull information.. KFED – Kernel Files Editor Let’s get some info for this utility: strace -d kfed -e read=all -e write=all pid 648 stopped, [SIGTRAP] open(“/oracle/product/11.1.0.6/asm/rdbms/mesg/kfedus.msb”, O_RDONLY [wait(0x57f) … Read more

Filed under Troubleshooting

Diagnostic events with debugger and crash..

Posted by oraclue on March 5, 2009 · 5 Comments 

Got this idea surfing Tanel’s post on Oracle’s dignostic events .He explained some unkown syntax for setting oracle diagnostic events.Full article can be found at: http://blog.tanelpoder.com/2009/03/03/the-full-power-of-oracles-diagnostic-events-part-1-syntax-for-ksd-debug-event-handling/ It’s a very good post.In addition to this syntax there are  two  more options  for action keyword that I have used in the past. Let me start with syntax that’s … Read more

Filed under Uncategorized

Run away from GUI DBA part 2.Script to report user locks for RAC

Posted by oraclue on March 5, 2009 · Leave a Comment 

Very usefull  script to list all user locks in RAC database. SELECT o.name object_name, u.name owner, lid.*   FROM (SELECT                s.inst_id, s.SID, s.serial#, p.spid,NVL (s.sql_id, 0), s.sql_hash_value,                DECODE (l.TYPE,                        ‘TM’, l.id1,                        ‘TX’, DECODE (l.request,                                      0, NVL (lo.object_id, -1),                                      s.row_wait_obj#                                     ),                        -1                       ) AS object_id,                  l.TYPE lock_type, … Read more

Filed under Performance

DBA_JOBS_RUNNING definition still not corrected for RAC 11g

Posted by oraclue on March 4, 2009 · Leave a Comment 

Just found this one  and since I do not trust until I see it.. Here is Bug description.Only affects RAC… There will be no output when queried for information on same job from other RAC instances. This is because the view definition makes use of v$lock information in joins and not the gv$lock. According to Oracle this … Read more

Filed under Bugs

When you do not have time to wait for Oracle patch?

Posted by oraclue on March 3, 2009 · 8 Comments 

  I got call from developer telling me  that he cannot run update on very small  table with (less than 50 rows) Every time he runs statement his session got disconnected .From the experience with my folks that tells me that there is possible Oracle bug… if session hang or slow that’s different but get disconnected every time  … Read more

Filed under Bugs