Extract Latency Connected With Update to PK Columns (Doc ID 1621667.1)

Last updated on MAY 17, 2017

Applies to:

Oracle GoldenGate - Version 11.1.1.1.0 to 12.1.2.0.0 [Release 11.1.1.1 to 12.1]
Information in this document applies to any platform.

Symptoms

Poor performance and latency / lag from Extract process.

An AWR report indicates that Extract is issuing a statement of the following form :

SELECT ... from table  AS OF SCN :scn x WHERE ROWID = :rid

- All columns in the table are specified in the column list ;
- AS OF SCN is also shown .

A pstack from the Extract process shows the context under which the above statement is issued to be :

Thread 1 (Thread 0x7f6dc3dbd6f0 (LWP 82440)):

#0  0x000000329bc0d9eb in read () from /lib64/libpthread.so.0   <<< read
#1  0x00007f6dc5fff864 in snttread () from /u01/app/ggate/libclntsh.so.11.1
#2  0x00007f6dc5ffe7f5 in nttfprd () from /u01/app/ggate/libclntsh.so.11.1
#3  0x00007f6dc5ff2ba8 in nsbasic_brc () from /u01/app/ggate/libclntsh.so.11.1
#4  0x00007f6dc5ff610b in nsbrecv () from /u01/app/ggate/libclntsh.so.11.1
#5  0x00007f6dc5fe51d3 in nioqrc () from /u01/app/ggate/libclntsh.so.11.1
#6  0x00007f6dc603df2d in ttcdrv () from /u01/app/ggate/libclntsh.so.11.1
#7  0x00007f6dc5febbd5 in nioqwa () from /u01/app/ggate/libclntsh.so.11.1
#8  0x00007f6dc5fd8395 in upirtrc () from /u01/app/ggate/libclntsh.so.11.1
#9  0x00007f6dc5fde9e6 in kpurcsc () from /u01/app/ggate/libclntsh.so.11.1
#10 0x00007f6dc5fd9a66 in kpuexec () from /u01/app/ggate/libclntsh.so.11.1
#11 0x00007f6dc5fd8ed1 in OCIStmtExecute () from /u01/app/ggate/libclntsh.so.11.1
#12 0x000000000063f179 in pk_fetch_cols(file_def*, DBOCI_stmt_def*, int, int, int*) ()         <<<<<
#13 0x000000000063fba4 in DBFETCH_fetch_pk_cols(void*, file_def*) ()
#14 0x0000000000508936 in fetchPKCols(file_def*) ()
#15 0x00000000005091e1 in DBFETCH_fetch_cols(file_def*, char*, int, short, int, int*, short*, int*) ()
#16 0x000000000050b28b in DBFETCH_checkFetchCols(file_def*, __std_rec_hdr*, char*, int, unsigned char*, char*, short*, long, int, pk_fetch_options_t*) ()
#17 0x00000000005686ca in replicate_io(file_def*, __std_rec_hdr*, char*, extr_ptr_def*, int*, int) ()
#18 0x0000000000566127 in process_extract_loop() ()
#19 0x0000000000578166 in main ()

 

Changes

FETCHOPTIONS FETCHPKUPDATECOLS is specified in Extract parameter file

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms