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 about it in in Oracle8 Reference (OTN no longer has Oracle7). http://otn.oracle.com/doc/server.804/a58242/events2.htm Also, please post the suggestions obtained from Oracle Support. I need something to brighten my day :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 9 Jan 2002, [EMAIL PROTECTED] wrote: > We have a replication between production and reporting database. > > Prodn Server Reporting server > > HP-UX 10.2 HP-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. > > Problem:-------------- The replication goes fine. On the reporting > database . > 1) But sometimes a query hangs. Dropping and recreating a snapshot seems > to solve the problem and the query executes properly after that. > 2) This has happened on different tables . We have reorged the database on > different disks . > 3) Hp and EMC have confirmed that the problem does not lie with the disk. > 4) The export for that particular table (snapshot) hangs. > 5) We have dumped the related logical volume to a filesystem and did a > dbverify . That is ok. > 6) We have async io on both prod and reporting database and raw devices . > > Has anyone encountered such a problem . Any tips would be > appreciated . > > 7) We have logged a tar on metalink , the responses obtained have been > implemented , but the problem of a query hanging and working properly after > a recreation of snapshot still continues. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
