RE: 10.2.0.4 Logical StdBy Hung SQL Apply

From: Holvoet, Jo <jo.holvoet_at_thomascook.be>
Date: Fri, 27 May 2011 13:07:31 +0200
Message-ID: <CF9A39CD0F65EA49ADF70FCBF9BC2FF70209D765_at_SW-GNETCW-MBX02.tcads.thomascook.com>



Same here. Even worse, from here (and also according to various websites that monitor this kind of thing, e.g. markosweb.com), www.freelists.org <http://www.freelists.org/> had disappeared from DNS ...

It's only been back a few hours.  

mvg / regards,

Jo Holvoet    


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of japplewhite_at_austinisd.org
Sent: vrijdag 27 mei 2011 4:13
To: oracle-l_at_freelists.org
Cc: Jared Still
Subject: Fw: 10.2.0.4 Logical StdBy Hung SQL Apply  

I sent this earlier today, but haven't seen an Oracle-L posting since yesterday. Is it just me unable to receive or are there Oracle-L problems?

Thanks.

Jack C. Applewhite - Database Administrator Austin I.S.D. - MIS Department
512.414.9250 (wk) / 512.935.5929 (pager)

  • Forwarded by Jack Applewhite/AISD on 05/26/2011 09:09 PM -----
From:        Jack Applewhite/AISD 
To:        oracle-l_at_freelists.org 
Cc:        oracle-l-bounce_at_freelists.org 
Date:        05/26/2011 09:09 AM 
Subject:        10.2.0.4 Logical StdBy Hung SQL Apply 


________________________________

Hi,

It's 64 bit Oracle10g EE on 64 bit RHEL 4 Linux.

According to V$LogStdB my Builder process has been doing this for hours and hours:
ORA-16245: paging in transaction 5, 45, 347459

I've gone through "Oracle10g Data Guard SQL Apply Troubleshooting (Doc ID 312434.1)", but nothing is revealed. I increased the SQL Apply Max_SGA from the default of 30 MB up to 2 GB, as well as the number of Appliers. Still no joy. No errors anywhere that I can find.

Anybody have a suggestion?

Thanks.

Jack C. Applewhite - Database Administrator

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 27 2011 - 06:07:31 CDT

Original text of this message