Shreepad,
You need to look in v$session_wait for the event the hanging session
is waiting on. This will answer the question, "What is it doing?"
Once you get that information, you will be able to stop guessing at
causes (HP, EMC, corrupted file, LVM).
Once you have the event for the hang, read
Hi,
We have a replication between production and reporting database.
Prodn Server Reporting server
HP-UX 10.2HP-UX 10.2
oracle 7.3.4.4.1 oracle 7.3.4.4.1
The os and oracle patches on the production server and reporting server are
in sync.
