Large transaction delays in reporting (logical standby) database

We occasionally are getting delays in our logical reporting database. V$LOGSTDBY indicates that the delays are due to a large transaction. Sometimes the delays are quite long (over 30 minutes). I'm trying to get some further info on the "large transaction" (on the primary database) that the logical standby is waiting on.
Is that possible and has anyone tried digging into it?

SQL > select * from v$logstdby;

   SERIAL# LOGSTDBY_ID PID          TYPE          STATUS_CODE
STATUS                                     HIGH_SCN


---------- ----------- ------------ ------------- -----------

---------------------------------------- ----------

         1          -1 22489        COORDINATOR         16116 ORA-16116: no
work available             1.2137E+10
        13           0 26051        READER              16127 ORA-16127:
stalled waiting for additiona 1.2137E+10
                                                              l transactions

        12           1 26057        BUILDER             16117 ORA-16117:
processing                    1.2137E+10
         5           2 26061        PREPARER            16117 ORA-16117:
processing                    1.2137E+10
         6           3 26083        ANALYZER            16120 ORA-16120:
dependencies being computed f 1.2137E+10
                                                              or transaction

        21 4 26085 APPLIER 16125 ORA-16125: large transaction 103 23 1069 1.2137E+10

                                                              82 is waiting

         5           5 8083         APPLIER             16116 ORA-16116: no
work available             1.2137E+10
        13           6 26089        APPLIER             16116 ORA-16116: no
work available             1.2137E+10
         4           7 26091        APPLIER             16116 ORA-16116: no
work available             1.2137E+10
        22           8 26101        APPLIER             16116 ORA-16116: no
work available             1.2137E+10

TIA,

• Ravi Gaur

--

http://www.freelists.org/webpage/oracle-l Received on Thu May 22 2008 - 16:47:54 CDT