All,
Does file open, db file parallel write wait, point to
any IO bottlenecks?
Is the datafile opened ( as in C programming) for
every access to any object in the datafile. The P1,
P2 and P3 values in V$SYSTEM_EVENT don't seem to
expalin anything.
Any thoughts p
e Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.secularislam.org/call.htm - For Muslims
@ http://www.christianity.net.au/ - For all
-Original Message-
Sent: Wednesday, 24 October 2001 19:15
To: Multiple recipients of list ORACLE-L
Hi,
I have this DB FILE PARALLEL
Hi,
I have this DB FILE PARALLEL WRITE as the top event (right after
SQL*NET,rdbms.,pmon & smon) and according to the documentation this
has to do with my DBWR but no mention is done on how to solve this.
Is this purely another indication of poor disk performance or should I be
loo