Re: Problems in replication

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, Shreepad.Vaidya_at_alltel.com 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: jwilton_at_speakeasy.net

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: ListGuru_at_fatcity.com (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).