--- J.Velikanovs@xxxxxxxx wrote: > We can use dbms_system.read_ev(10046,event_level); > for current session, > but I am unaware how to get info about other > sessions. > May be others can comment. > FYI. This is covered extremely well in Appx A of Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning. ISBN: 007222729x HTH Regards, Mike Thomas __________________________________ Do you Yahoo!? Vote for the stars of Yahoo!'s next ad campaign! http://advision.webevents.yahoo.com/yahoo/votelifeengine/ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------