[9.2.0.1 on W2K3] Slow down after file allocating
Hi,
One of our batches shutdown because of missing space in a tablespace (file not in autoextend mode).
I allocated a new file and relaunch the treatement.
But now the treatement is slow (6200 IO/S for log and 2000 IO/S for data).
When I look at dba_free_space, it seems that :
Some space is remaining on the old file and nothing is written in the new file.
Additional information : 2 Gb left on the disk, CPU and RAM usage is OK.
Do you have any information ?
Rgds,
Frederic
I allocated a new file and relaunch the treatement.
But now the treatement is slow (6200 IO/S for log and 2000 IO/S for data).
When I look at dba_free_space, it seems that :
Some space is remaining on the old file and nothing is written in the new file.
Additional information : 2 Gb left on the disk, CPU and RAM usage is OK.
Do you have any information ?
Rgds,
Frederic
0