Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: constant monitoring and enqueues?
Jonathan,
Kudo's on your book by the way. Very well done.
RF
In article <979812326.26386.0.nnrp-02.9e984b29_at_news.demon.co.uk>,
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> 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
> >
>
>
Sent via Deja.com
http://www.deja.com/
Received on Thu Jan 18 2001 - 11:08:44 CST
![]() |
![]() |