Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to reduce number of sessions waiting for event 'file open'?
I asked the same question about a year ago. Someone asked on Metalink
how to interpret the P1(fib) and P2 (iov) parameters for this wait
event. The answer is those are for internal use. Another article says
this wait event is really an OS issue because Oracle just waits for OS
to open the file. It suggests tuning BUFHWM and NBUF parameters in
/etc/system. Unfortunately tracing the Oracle process doesn't reveal
anything. If a hardcore UNIX guy can dig into adb and find the OS
kernel wait event based on the wait channel (WCHAN of ps -l output),
then the problem may be solved.
Yong Huang
yong321_at_yahoo.com
fourrats_at_verizon.net (Fred) wrote in message news:<c00962f6.0204231830.1a7e86ee_at_posting.google.com>...
> I am not able to find much information on the event "file open", yet I
> have quite a few sessions waiting on this event. They're not waiting
> long, but I would still like to see fewer sessions waiting.
Received on Wed Apr 24 2002 - 12:12:26 CDT