I execute insert and the number of record is several million then after several hours it seemes data
hello,
I execute a script with insert '/*+APPEND */ , the number of record is several millions then after several hours it seemes database blocked.
but i do not know and I do not understand then I executed the statspack report during the database is very very slow and seemes blocked.
>>>>>>>>>>>> In the statspack report then I see the wait time of db file sequential read 7774 s
for a snapshots : Begin Snap: 51 13-Mars -13 10:16:4 36 4.6 4
End Snap: 71 13-Mars -13 12:04:3 38 4.4
This time show that the wait time 7774s is almost the time of the snapshot.
What do the gurus think about it ?
thank you for your help.
I execute a script with insert '/*+APPEND */ , the number of record is several millions then after several hours it seemes database blocked.
but i do not know and I do not understand then I executed the statspack report during the database is very very slow and seemes blocked.
>>>>>>>>>>>> In the statspack report then I see the wait time of db file sequential read 7774 s
for a snapshots : Begin Snap: 51 13-Mars -13 10:16:4 36 4.6 4
End Snap: 71 13-Mars -13 12:04:3 38 4.4
This time show that the wait time 7774s is almost the time of the snapshot.
What do the gurus think about it ?
thank you for your help.
0