GoldenGateLagForHugeInsert - 数据库编程

前些天客户的ogg延迟到达8小时左右，于是我当时用logdump追踪了一下：

看进程状态：
send extsa staus

EXTRACT ZBDBA (PID 2269368)
  Current status: Recovery complete: Processing data with empty data queue

  Current read positions:
  Redo thread #: 1
  Sequence #: 36694
  RBA: 35831764
  Timestamp: 2014-10-17 16:18:28.000000
  SCN: 3044.3022023259
  Redo thread #: 2
  Sequence #: 34709
  RBA: 403776
  Timestamp: 2014-10-17 16:18:28.000000
  SCN: 3044.3022023265
  Current write position:
  Sequence #: 5160
  RBA: 168381460
  Timestamp: 2014-10-17 17:07:07.339050
  Extract Trail: ./dirdat/sa

使用logdump

Logdump 254 >open /goldengate/dirdat/sa005160
Current LogTrail is /goldengate/dirdat/sa005160
Logdump 255 >ghdr on
Logdump 256 >detail on
Logdump 257 >detail data
Logdump 258 >usertoken on
Logdump 259 >pos 168381460
Reading forward from RBA 168381460
Logdump 260 >n
___________________________________________________________________
Hdr-Ind    :     E  (x45)     Partition  :     .  (x04) 
UndoFlag   :     .  (x00)     BeforeAfter:     A  (x41) 
RecLength  :   226  (x00e2)   IO Time    : 2014/10/17 16:18:28.000.000  
IOType     :     5  (x05)     OrigNode   :   255  (xff)
TransInd   :     .  (x03)     FormatType :     R  (x52)
SyskeyLen  :     0  (x00)     Incomplete :     .  (x00)
AuditRBA   :      34709       AuditPos   : 369920
Continued  :     N  (x00)     RecCount   :     1  (x01)

2014/10/17 16:18:28.000.000 Insert               Len   226 RBA 168381460
Name: MW_APP.MWT_UD_KW_SJBGJL
After  Image:                                             Partition 4   G  s  
0000 002c 0000 3641 4431 4545 4239 2d32 3830 382d | ...,..6AD1EEB9-2808- 
3437 3030 2d42 4335 322d 4342 3936 4132 4130 4234 | 4700-BC52-CB96A2A0B4 
3638 2d30 3537 3137 0001 002c 0000 3641 4431 4545 | 68-05717...,..6AD1EE 
4239 2d32 3830 382d 3437 3030 2d42 4335 322d 4342 | B9-2808-4700-BC52-CB 
3936 4132 4130 4234 3638 2d30 3537 3132 0002 0028 | 96A2A0B468-05712...( 
0000 0024 3436 3930 3238 3835 2d39 3745 462d 3444 | ...$46902885-97EF-4D 
3644 2d39 4446 322d 4536 3837 4637 3938 3039 3334 | 6D-9DF2-E687F7980934 
Column     0 (x0000), Len    44 (x002c) 
0000 3641 4431 4545 4239 2d32 3830 382d 3437 3030 | ..6AD1EEB9-2808-4700 
2d42 4335 322d 4342 3936 4132 4130 4234 3638 2d30 | -BC52-CB96A2A0B468-0 
3537 3137                                         | 5717 
Column     1 (x0001), Len    44 (x002c) 
0000 3641 4431 4545 4239 2d32 3830 382d 3437 3030 | ..6AD1EEB9-2808-4700 
2d42 4335 322d 4342 3936 4132 4130 4234 3638 2d30 | -BC52-CB96A2A0B468-0 
3537 3132                                         | 5712 
Column     2 (x0002), Len    40 (x0028) 
0000 0024 3436 3930 3238 3835 2d39 3745 462d 3444 | ...$46902885-97EF-4D 
3644 2d39 4446 322d 4536 3837 4637 3938 3039 3334 | 6D-9DF2-E687F7980934 
Column     3 (x0003), Len    31 (x001f) 
0000 3230 3134 2d31 302d 3137 3a31 363a 3138 3a32 | ..2014-10-17:16:18:2 
382e 3631 3335 3436 3030 30                       | 8.613546000 
Column     4 (x0004), Len     5 (x0005) 
0000 0001 30                                      | ....0 
Column     5 (x0005), Len    13 (x000d) 
0000 0009 3438 3330 3730 3539 38                  | ....483070598 
Column     6 (x0006), Len     5 (x0005) 
0000 0001 43                                      | ....C 
Column     7 (x0007), Len     4 (x0004) 
ffff 0000                                         | .... 
Column     8 (x0008), Len     4 (x0004) 
ffff 0000                                         | .... 
  
Logdump 261 >

查看表：

 
  SQL> select count(1) from MW_APP.MWT_UD_KW_SJBGJL;

  COUNT(1)
----------
   1217825
  
  
SQL> select count(1) from MW_APP.MWT_UD_KW_SJBGJL;


  COUNT(1)
----------
   1218487
  
SQL> select count(1) from MW_APP.MWT_UD_KW_SJBGJL;


  COUNT(1)
----------
   1219335

EXTRACT ZBDBA (PID 2269368)
  Current status: Recovery complete: Processing data with empty data queue

  Current read positions:
  Redo thread #: 1
  Sequence #: 36695
  RBA: 36154920
  Timestamp: 2014-1

GoldenGateLagForHugeInsert(一)