Hi all,

I am creating few tablespaces and i am reusing the datafiles (datafiles are around 500MB to 1GB).

Each creation of each tablespace are during between 2 and 4 minutes !!??

I am alone on my HP-UX machine when i run this.

I checked the v$session_wait view and it appears that Oracle wait for the event "file open" during 2 to 4 minutes !?

This wait event is undocumented and even in metalink, there're not lots of informations. Just that this event is... the time waiting to open a file...

So does someone has any idea about WHY Oracle has to wait for 2 - 4 minutes before opening a file ??

Thx by advance,

Fred

PS : my v$session_wait

SID SUBSTR(EVENT,1,20) STATE SECONDS_IN_WAIT
---------- -------------------- ------------------- ---------------
P1TEXT
----------------------------------------------------------------
P2TEXT
----------------------------------------------------------------
P3TEXT
----------------------------------------------------------------
12 file open WAITED SHORT TIME 247
fib
iov
0