OGG大事务分析

GGSCI > send SEXTR01,showtrans
Sending SHOWTRANS request to EXTRACT SEXTR01 ...
Oldest redo log file necessary to restart Extract is:
Redo Log Sequence Number 379772, RBA 80832528
------------------------------------------------------------
XID: 5.16.878446
Items: 0
Extract: SEXTR01
Redo Thread: 1
Start Time: 2013-10-21:14:19:15
SCN: 2915.3266255614 (12523095923454)
Redo Seq: 379772
Redo RBA: 80832528
Status: Running
根据XID查SADDR；
select * from v$transaction where XIDUSN||XIDSLOT||XIDSQN='516878446';
根据SADDR查SID；
select * from v$session where taddr in ('070000024575C808');
根据prev_SQL_id查未提交的操作；
SQL> select prev_sql_id from v$session where taddr in ('070000024575C808');

 

 

GGSCI (ztjsdbs01) 109> send extb2,showtrans

Sending SHOWTRANS request to EXTRACT EXTB2 ...

Oldest redo log file necessary to restart Extract is:

Redo Log Sequence Number 158153, RBA 417766416

------------------------------------------------------------
XID: 56.8.11855364
Items: 0
Extract: EXTB2
Redo Thread: 1
Start Time: 2019-01-22:10:11:28
SCN: 176.4189055694 (760103299790)
Redo Seq: 158153
Redo RBA: 417766416
Status: Running

------------------------------------------------------------
XID: 29.32.14989321
Items: 0
Extract: EXTB2
Redo Thread: 1
Start Time: 2019-01-22:10:58:33
SCN: 176.4191397210 (760105641306)
Redo Seq: 158163
Redo RBA: 1040
Status: Running

------------------------------------------------------------
XID: 110.29.2968122
Items: 1
Extract: EXTB2
Redo Thread: 1
Start Time: 2019-01-22:10:58:33
SCN: 176.4191397210 (760105641306)
Redo Seq: 158163
Redo RBA: 1040
Status: Running

GGSCI (ztjsdbs01) 110>

 

select * from v$transaction where XIDUSN||XIDSLOT||XIDSQN='417766416';

alter extb4,begin 2020-04-01 11:41:14