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@xxxxxxxxxxxxx
Cc:     oracle-l-bounce@xxxxxxxxxxxxx
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

Other related posts: