Re: constant monitoring and enqueues?

You could try starting the database with event 10046 set to level 8, to trap the values on startup, this may give you some clues.

However, I just did this on 8.1.5 on NT, and found that the p2 value was ALWAYS reported as zero on startup, and switch logfiles left LGWR accumulating the event with p2 still set to zero.

--
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



hailey_kyle_at_my-deja.com wrote in message <942mio$kig$1_at_nnrp1.deja.com>...


>

>Just curious, you might be able to help with this one because it sounds

>like you are pretty well informed. Do you know how to use the "file

>name" (second arg, ie x$ksled(ksledp2) ) from the wait event "file

>identify" to actually get the file?

>

>Best

>Kyle

>