Re: constant monitoring and enqueues?

Andrew,

Event 10704 is supposed to print information about enqueues being acquired, levels are 1 - 10. But this might be a little painful on performance. I haven't tried it.

The P1RAW etc. meanings for each event type can be checked in v$event_name. For 'enqueue' I think only P1/P1RAW is the enqueue type and mode - use the RAW form, and the first 4 bytes are the ascii code for the type, the last byte is the mode, e.g.

    53540004
Is an ST lock in mode 4.
p2 and p3 are the id1, and id2 values.

I too have the project of direct access to the SGA as a 'some-time/never' project - just for fun !

Thanks for the comment on the website.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



andrew_webby at hotmail wrote in message
<979300431.8122.0.nnrp-07.c30bdde2_at_news.demon.co.uk>...


>Thanks Jonathan.

>

>I downloaded a document - can't remember where, either your site or Ixora -

>which gave details on deciphering the P1, P2, P1RAW etc in v$session_wait





>

>Guess I'll stick this one on the back burner for a while. Thanks for your

>help however. Your site has been in my Favourites for some time and in case

>you don't hear it often - it is very useful indeed.

>