Locking Question on OPS??

Hi there,

Recently, I get a big question on an OPS system. My OPS database contains two schema. A process updating the tables on Schema #1 only is always running on Node A and triggered to update every minutes in everyday. An other daily process inserting data into the tables on Schema #2 is running on Node B. At first, they were running very well, but over time, the daily process on Node B is hung sometimes. And while the daily process is hanging, the update process on Node A also get hung until the daily process is killed.

I queried several system views, including v$lock, v$system_wait .. on both nodes but cannot find any clue. Anyone can tell me what else system views can figure out what's wrong on the OPS system. In addition, is there any to enable Oracle session trace while the process want to be traced is running?

Any help would be appreicated. Thanks!

Dicky Received on Wed Nov 17 1999 - 18:01:08 CST