Large transaction delays in reporting (logical standby) database
- From: "Ravi Gaur" <ravigaur1@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 22 May 2008 16:47:54 -0500
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
to be applied
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
at SCN 0x0002.d36a6a1f
21 4 26085 APPLIER 16125 ORA-16125:
large transaction 103 23 1069 1.2137E+10
82 is waiting
for more data
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
Other related posts:
- » Large transaction delays in reporting (logical standby) database
