Laimis,
I am especially interested in the wait events columns like EVENTS_ID, TIME_WAITED, WAIT_TIME.
If you have access to IOUG, check my paper on "Backporting 10g" and I cover this in some detail there (as well as in Chp 11 in "Oracle Database 10g Insider Solutions"). What specifically are you looking for? The last two columns are especially ignored or misunderstood.... -- John Kanagaraj <>< DB Soft Inc Phone: 408-970-7002 (W) ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -- //www.freelists.org/webpage/oracle-l