Insert Stuck
Hi all,
I'm having an issue with an INSERT INTO ... SELECT statement that seems hung.
It's showing a "db file scattered read" event stuck on the same file/block from the beginning of its exectuion.
Indeed the P1 and P2 fields of the v$session_wait view are not changing.
If I stop and reexecute the insert, it will behave the same way but stuck on another file/block.
Is this information in v$session_wait reliable?
My DB version: 11.2.0.1.0 on Linux.
I haven't traced it yet but the same insert with an equivalent amount of data runs ok on other databases.
It's showing a "db file scattered read" event stuck on the same file/block from the beginning of its exectuion.
Indeed the P1 and P2 fields of the v$session_wait view are not changing.
If I stop and reexecute the insert, it will behave the same way but stuck on another file/block.
Is this information in v$session_wait reliable?
My DB version: 11.2.0.1.0 on Linux.
I haven't traced it yet but the same insert with an equivalent amount of data runs ok on other databases.
0