BrogainTechnology ( Oracle DBA Training)
Pages
Oracle Database Related Scripts
Oracle Database Scripts
About Brogain Technolgy
Oracle DBA Course Summary
Stand Database/Data Guard
Showing posts with label
How to identify the wait events for a Session in oracle database
.
Show all posts
Showing posts with label
How to identify the wait events for a Session in oracle database
.
Show all posts
Friday, January 13, 2012
How to identify the wait events for a Session in oracle database
select p1, p2, p3, event
from
v$session_wait
where sid=&session_id;
Also check the following:
select count(*), event
from
v$session_wait
group
by event;
Older Posts
Home
Subscribe to:
Posts (Atom)