Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is there any statistic which counts the context switches ....

sgalaxyApr 7 2008 — edited Apr 8 2008

Hi,
All know that the switching between PL/SQL and SQL engine should be avoided if possible....
Is there any statistic/'wait event' which counts for them.....????
For example , when the system waits for a block to be read .. then the system updates appropriately the 'wait event' db_file_scattered_read

I have used the folllowing query:

SQL> select name from v$event_name where lower(name) like '%context%';
 
NAME
----------------------------------------------------------------
enq: KK - context

Note: I use DB10g v.2

Thanks...
Sim

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 6 2008
Added on Apr 7 2008
4 comments
388 views