Row Cache Lock – An interesting case

Suddenly today morning i was reported that an Import is hanging.The dumpfile was of 1Gb  containing few small tables.Immediately, i checked what all are the sessions belonging to impdp and what is session wait for them.Knowing the session wait makes things easier to analyze. As the import was started by 'SYSTEM' SELECT NVL(a.username, '(oracle)') AS … Continue reading Row Cache Lock – An interesting case