10.2.0.4 Logical StdBy Hung SQL Apply

From: <japplewhite_at_austinisd.org>
Date: Fri, 27 May 2011 06:09:21 -0400 (EDT)
Message-ID: <OFFF9BEB69.DCD03E2E-ON8625789C.004D0C67-8625789C.004DBFCC_at_austinisd.org>



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 Austin I.S.D. - MIS Department
512.414.9250 (wk) / 512.935.5929 (pager)

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 27 2011 - 05:09:21 CDT

Original text of this message