Oracle 19c 新特性之一,adg的自动 dml 重定向.就是在 ADG 环境下,连接到 standby 的数据库执行 dml.
Oracle 19c 新特性之一,adg的自动 dml 重定向.就是在 ADG 环境下,连接到 standby 的数据库执行 dml.
这个特性在 18c 是作为隐含参数 _enable_proxy_adg_redirect 调整的,
但在 19c 中,通过显式参数 ADG_REDIRECT_DML 参数调整.
ADG新特性DML自动重定向配置测试
功能启用
主库：
SQL> alter system set adg_redirect_dml=true scope=both;
备库：
SQL> alter system set adg_redirect_dml=true scope=both;
DML自动重定向测试创建测试数据
登录主库：
SQL> connect test/test
SQL> create table t1(id int);
SQL> insert into t1 values(1);
备库确认：
SQL> connect test/test
Connected.
SQL> select * from t1;
ID
--------------------
1
测试
登录备库：
SQL> conn /as sysdba
Connected.
SQL> select open_mode from v$database;
OPEN_MODE
------------------------------------------------------------
READ ONLY WITH APPLY
SQL> insert into test.t1 values(2);
insert into test.t1 values(2)
*
ERROR at line 1:
ORA-16397: statement redirection from Oracle Active Data Guard standby database to primary database failed
SQL> conn test/test
Connected.
SQL> insert into test.t1 values(2);
1 row created.
SQL> commit;
Commit complete.
SQL> conn /as sysdba
Connected.
SQL> create table abc(a int);
create table abc(a int)
*
ERROR at line 1:
ORA-16000: database or pluggable database open for read-only access
实现机制探究
备库：
SQL> alter session set events '10046 trace name context forever,level 12';
SQL> insert into t1 select * from t1;
257 rows created.
SQL> commit;
Commit complete.
SQL> alter session set events '10046 trace name context off';
#查看trace file
SQL> select * from v$diag_info;
SQL> alter session set events '10046 trace name context off';
#查看trace文件
Trace file /oracle/app/oracle/diag/rdbms/orcladg/orcl/trace/orcl_ora_16830_10046.trc
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Build label: RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417
ORACLE_HOME: /oracle/app/oracle/product/19.0.0/db_1
System name: Linux
Node name: oracle19c
Release: 3.10.0-693.17.1.el7.x86_64
Version: #1 SMP Sun Jan 14 10:36:03 EST 2018
Machine: x86_64
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 33
Unix process pid: 16830, image: oracle@oracle19c (TNS V1-V3)
*** 2019-10-22T12:00:09.822291+08:00
*** SESSION ID:(390.62905) 2019-10-22T12:00:09.822306+08:00
*** CLIENT ID:() 2019-10-22T12:00:09.822309+08:00
*** SERVICE NAME:(SYS$USERS) 2019-10-22T12:00:09.822312+08:00
*** MODULE NAME:(SQL*Plus) 2019-10-22T12:00:09.822315+08:00
*** ACTION NAME:() 2019-10-22T12:00:09.822317+08:00
*** CLIENT DRIVER:(SQL*PLUS) 2019-10-22T12:00:09.822320+08:00
=====================
PARSING IN CURSOR #140186657718568 len=68 dep=0 uid=106 oct=42 lid=106 tim=11116566579 hv=2804619552 ad='6c622ca0' sqlid='9vyg8tumkq690'
alter session set events '10046 trace name context forever,level 12'
END OF STMT
EXEC #140186657718568:c=328,e=327,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,plh=0,tim=11116566577
WAIT #140186657718568: nam='SQL*Net message to client' ela= 1 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=11116566867
*** 2019-10-22T12:00:18.908898+08:00
WAIT #140186657718568: nam='SQL*Net message from client' ela= 9086476 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=11125653356
CLOSE #140186657718568:c=5,e=5,dep=0,type=0,tim=11125653426
=====================
PARSING IN CURSOR #140186659180264 len=76 dep=1 uid=0 oct=3 lid=0 tim=11125653710 hv=1052578227 ad='695ccc38' sqlid='04kug40zbu4dm'
select policy#, action# from aud_object_opt$ where object# = :1 and type = 2
END OF STMT
BINDS #140186659180264:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbff4e010 bln=22 avl=04 flg=05
value=73197
EXEC #140186659180264:c=71,e=71,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=4006480256,tim=11125653762
FETCH #140186659180264:c=46,e=46,p=0,cr=8,cu=0,mis=0,r=0,dep=1,og=4,plh=4006480256,tim=11125653816
CLOSE #140186659180264:c=0,e=0,dep=1,type=3,tim=11125653829
=====================
PARSING IN CURSOR #140186659178032 len=868 dep=1 uid=0 oct=3 lid=0 tim=11125653872 hv=3633507567 ad='6965de40' sqlid='121ffmrc95v7g'
select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0),nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null,null,mod(trunc(i.pctthres$/256),256)),nvl(i.evaledition#,1),nvl(i.unusablebefore#,0),nvl(i.unusablebeginning#,0), ist.cachedblk,ist.cachehit,ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(intcols) unicols,min(to_number(bitand(defer,1))) deferrable#,min(to_number(bitand(defer,4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
END OF STMT
BINDS #140186659178032:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbff4e010 bln=22 avl=04 flg=05
value=73197
Bind#1
No oacdef for this bind.
EXEC #140186659178032:c=88,e=88,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=2007068531,tim=11125653930
FETCH #140186659178032:c=48,e=49,p=0,cr=3,cu=0,mis=0,r=0,dep=1,og=4,plh=2007068531,tim=11125653984
CLOSE #140186659178032:c=0,e=0,dep=1,type=3,tim=11125654007
=====================
PARSING IN CURSOR #140186658448752 len=585 dep=1 uid=0 oct=3 lid=0 tim=11125654028 hv=3191600260 ad='697bc600' sqlid='g0t052az3rx44'
select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180,scale,181,scale,182,scale,183,scale,231,scale,0),null$,fixedstorage,nvl(deflength,0),default$,rowid,col#,property, nvl(charsetid,0),nvl(charsetform,0),spare1,spare2,nvl(spare3,0), nvl(evaledition#,1),nvl(unusablebefore#,0),nvl(unusablebeginning#,0), case when (type# in (1,8,9,96,112)) then nvl(collid, 16382) else 0 end case, nvl(collintcol#,0), nvl(acdrrescol#, 0), nvl(spare7, 0), nvl(spare9, 0), nvl(spare10, 0) from col$ where obj#=:1 order by intcol#
END OF STMT
BINDS #140186658448752:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbff4d100 bln=22 avl=04 flg=05
value=73197
EXEC #140186658448752:c=52,e=51,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=3765558045,tim=11125654070
FETCH #140186658448752:c=18,e=18,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,plh=3765558045,tim=11125654094
FETCH #140186658448752:c=2,e=2,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=3765558045,tim=11125654109
CLOSE #140186658448752:c=0,e=0,dep=1,type=3,tim=11125654117
=====================
PARSING IN CURSOR #140186657990352 len=332 dep=1 uid=0 oct=3 lid=0 tim=11125655271 hv=2698389488 ad='6b5a4550' sqlid='acmvv4fhdc9zh'
select obj#,type#,ctime,mtime,stime, status, dataobj#, flags, oid$, spare1, spare2, spare3, signature, spare7, spare8, spare9, nvl(dflcollid, 16382), creappid, creverid, modappid, modverid, crepatchid, modpatchid from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
END OF STMT
BINDS #140186657990352:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=80 off=0
kxsbbbfp=7f7fbff4d0c8 bln=22 avl=03 flg=05
value=106
Bind#1
oacdty=01 mxl=32(02) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0001 frm=01 csi=852 siz=0 off=24
kxsbbbfp=7f7fbff4d0e0 bln=32 avl=02 flg=01
value="T1"
Bind#2
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=56
kxsbbbfp=7f7fbff4d100 bln=22 avl=02 flg=01
value=1
EXEC #140186657990352:c=901,e=1206,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=813480514,tim=11125655344
FETCH #140186657990352:c=26,e=26,p=0,cr=4,cu=0,mis=0,r=1,dep=1,og=4,plh=813480514,tim=11125655378
STAT #140186657990352 id=1 cnt=1 pid=0 pos=1 obj=18 op='TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=4 pr=0 pw=0 str=1 time=25 us cost=3 size=108 card=1)'
STAT #140186657990352 id=2 cnt=1 pid=1 pos=1 obj=37 op='INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 str=1 time=18 us cost=2 size=0 card=1)'
CLOSE #140186657990352:c=42,e=42,dep=1,type=3,tim=11125655433
=====================
PARSING IN CURSOR #140186658100648 len=90 dep=1 uid=0 oct=3 lid=0 tim=11125656028 hv=3433193208 ad='6970f7c0' sqlid='cn6hhn36a4rrs'
select con#,obj#,rcon#,enabled,nvl(defer,0),spare2,spare3,refact from cdef$ where robj#=:1
END OF STMT
BINDS #140186658100648:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbff4d100 bln=22 avl=04 flg=05
value=73197
EXEC #140186658100648:c=615,e=615,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=3845132125,tim=11125656069
FETCH #140186658100648:c=5,e=5,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,plh=3845132125,tim=11125656080
STAT #140186658100648 id=1 cnt=0 pid=0 pos=1 obj=31 op='TABLE ACCESS BY INDEX ROWID BATCHED CDEF$ (cr=1 pr=0 pw=0 str=1 time=6 us cost=2 size=58 card=2)'
STAT #140186658100648 id=2 cnt=0 pid=1 pos=1 obj=55 op='INDEX RANGE SCAN I_CDEF3 (cr=1 pr=0 pw=0 str=1 time=5 us cost=1 size=0 card=2)'
CLOSE #140186658100648:c=0,e=0,dep=1,type=3,tim=11125656121
=====================
PARSING IN CURSOR #140186658093088 len=160 dep=1 uid=0 oct=3 lid=0 tim=11125656701 hv=2880999359 ad='6978b2b8' sqlid='gx4mv66pvj3xz'
select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0),rowid,cols,nvl(defer,0),mtime,nvl(spare1,0),spare2,spare3 from cdef$ where obj#=:1
END OF STMT
BINDS #140186658093088:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbff4d100 bln=22 avl=04 flg=05
value=73197
EXEC #140186658093088:c=774,e=619,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=2570921597,tim=11125656751
FETCH #140186658093088:c=10,e=10,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,plh=2570921597,tim=11125656769
STAT #140186658093088 id=1 cnt=0 pid=0 pos=1 obj=31 op='TABLE ACCESS CLUSTER CDEF$ (cr=2 pr=0 pw=0 str=1 time=12 us cost=2 size=192 card=4)'
STAT #140186658093088 id=2 cnt=0 pid=1 pos=1 obj=30 op='INDEX UNIQUE SCAN I_COBJ# (cr=2 pr=0 pw=0 str=1 time=11 us cost=1 size=0 card=1)'
CLOSE #140186658093088:c=0,e=0,dep=1,type=3,tim=11125656811
=====================
PARSING IN CURSOR #140186657885880 len=359 dep=1 uid=0 oct=3 lid=0 tim=11125657039 hv=3461447171 ad='695e22d8' sqlid='5say587752zh3'
select name,online$,contents$,undofile#,undoblock#,blocksize,dflmaxext,dflinit,dflincr,dflextpct,dflminext, dflminlen, owner#,scnwrp,scnbas, NVL(pitrscnwrp, 0), NVL(pitrscnbas, 0), dflogging, bitmapped, inc#, MOD(flags,(4294967296 * 4294967296)), plugged, NVL(spare1,0), NVL(spare2,0), affstrength, FLOOR(flags/(4294967296 * 4294967296)) from ts$ where ts#=:1
END OF STMT
PARSE #140186657885880:c=210,e=210,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=11125657039
BINDS #140186657885880:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbff4d100 bln=22 avl=02 flg=05
value=6
EXEC #140186657885880:c=585,e=585,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=2397009925,tim=11125657669
FETCH #140186657885880:c=16,e=16,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,plh=2397009925,tim=11125657698
STAT #140186657885880 id=1 cnt=1 pid=0 pos=1 obj=16 op='TABLE ACCESS CLUSTER TS$ (cr=2 pr=0 pw=0 str=1 time=12 us cost=1 size=88 card=1)'
STAT #140186657885880 id=2 cnt=1 pid=1 pos=1 obj=7 op='INDEX UNIQUE SCAN I_TS# (cr=1 pr=0 pw=0 str=1 time=4 us cost=0 size=0 card=1)'
CLOSE #140186657885880:c=33,e=33,dep=1,type=0,tim=11125657741
=====================
PARSING IN CURSOR #140186658116200 len=226 dep=1 uid=0 oct=3 lid=0 tim=11125658400 hv=1011610568 ad='69697ed8' sqlid='9tgj4g8y4rwy8'
select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0),NVL(scanhint,0),NVL(bitmapranges,0) from seg$ where ts#=:1 and file#=:2 and block#=:3
END OF STMT
BINDS #140186658116200:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=72 off=0
kxsbbbfp=7f7fbff4d0d0 bln=22 avl=02 flg=05
value=6
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=24
kxsbbbfp=7f7fbff4d0e8 bln=22 avl=02 flg=01
value=5
Bind#2
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=48
kxsbbbfp=7f7fbff4d100 bln=22 avl=03 flg=01
value=138
EXEC #140186658116200:c=487,e=699,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=3755742892,tim=11125658461
FETCH #140186658116200:c=39,e=40,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,plh=3755742892,tim=11125658508
STAT #140186658116200 id=1 cnt=1 pid=0 pos=1 obj=14 op='TABLE ACCESS CLUSTER SEG$ (cr=3 pr=0 pw=0 str=1 time=37 us cost=2 size=64 card=1)'
STAT #140186658116200 id=2 cnt=1 pid=1 pos=1 obj=9 op='INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=2 pr=0 pw=0 str=1 time=30 us cost=1 size=0 card=1)'
CLOSE #140186658116200:c=32,e=32,dep=1,type=3,tim=11125658556
BINDS #140186659180264:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbff4cb50 bln=22 avl=03 flg=05
value=256
EXEC #140186659180264:c=33,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=4006480256,tim=11125658767
FETCH #140186659180264:c=25,e=25,p=0,cr=8,cu=0,mis=0,r=0,dep=2,og=4,plh=4006480256,tim=11125658798
CLOSE #140186659180264:c=1,e=1,dep=2,type=3,tim=11125658808
BINDS #140186659178032:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbff4cb50 bln=22 avl=03 flg=05
value=256
Bind#1
No oacdef for this bind.
EXEC #140186659178032:c=64,e=64,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=2007068531,tim=11125658882
FETCH #140186659178032:c=95,e=95,p=0,cr=7,cu=0,mis=0,r=1,dep=2,og=4,plh=2007068531,tim=11125658983
=====================
PARSING IN CURSOR #140186657857776 len=74 dep=2 uid=0 oct=3 lid=0 tim=11125659008 hv=3309402135 ad='697bb318' sqlid='5n1fs4m2n2y0r'
select pos#,intcol#,col#,spare1,bo#,spare2,spare3 from icol$ where obj#=:1
END OF STMT
BINDS #140186657857776:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbfe03e90 bln=22 avl=03 flg=05
value=259
EXEC #140186657857776:c=36,e=36,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=452367486,tim=11125659038
FETCH #140186657857776:c=7,e=7,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,plh=452367486,tim=11125659051
FETCH #140186657857776:c=3,e=3,p=0,cr=2,cu=0,mis=0,r=1,dep=2,og=4,plh=452367486,tim=11125659061
FETCH #140186657857776:c=0,e=0,p=0,cr=1,cu=0,mis=0,r=0,dep=2,og=4,plh=452367486,tim=11125659067
CLOSE #140186657857776:c=0,e=0,dep=2,type=3,tim=11125659075
FETCH #140186659178032:c=2,e=2,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=2007068531,tim=11125659082
CLOSE #140186659178032:c=0,e=0,dep=2,type=3,tim=11125659093
BINDS #140186658448752:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbff4c198 bln=22 avl=03 flg=05
value=256
EXEC #140186658448752:c=111,e=111,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=3765558045,tim=11125659214
FETCH #140186658448752:c=25,e=25,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,plh=3765558045,tim=11125659245
FETCH #140186658448752:c=2,e=2,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,plh=3765558045,tim=11125659259
FETCH #140186658448752:c=2,e=2,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,plh=3765558045,tim=11125659268
FETCH #140186658448752:c=1,e=1,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,plh=3765558045,tim=11125659276
FETCH #140186658448752:c=1,e=1,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,plh=3765558045,tim=11125659284
FETCH #140186658448752:c=2,e=2,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,plh=3765558045,tim=11125659292
FETCH #140186658448752:c=2,e=2,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,plh=3765558045,tim=11125659302
FETCH #140186658448752:c=1,e=1,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,plh=3765558045,tim=11125659310
FETCH #140186658448752:c=2,e=2,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,plh=3765558045,tim=11125659318
FETCH #140186658448752:c=1,e=1,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,plh=3765558045,tim=11125659325
FETCH #140186658448752:c=1,e=1,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,plh=3765558045,tim=11125659333
FETCH #140186658448752:c=2,e=2,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=3765558045,tim=11125659342
CLOSE #140186658448752:c=0,e=0,dep=2,type=3,tim=11125659350
BINDS #140186658116200:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=72 off=0
kxsbbbfp=7f7fbff4c168 bln=22 avl=01 flg=05
value=0
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=24
kxsbbbfp=7f7fbff4c180 bln=22 avl=02 flg=01
value=1
Bind#2
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=48
kxsbbbfp=7f7fbff4c198 bln=22 avl=03 flg=01
value=2264
EXEC #140186658116200:c=45,e=45,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=3755742892,tim=11125659415
FETCH #140186658116200:c=16,e=16,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,plh=3755742892,tim=11125659436
CLOSE #140186658116200:c=3,e=3,dep=2,type=3,tim=11125659446
=====================
PARSING IN CURSOR #140186658065280 len=108 dep=1 uid=0 oct=3 lid=0 tim=11125659520 hv=1496052666 ad='6c582fe8' sqlid='b3zgx1xckrwxu'
select host,userid,password,flag,authusr,authpwd, passwordx, authpwdx from link$ where owner#=:1 and name=:2
END OF STMT
PARSE #140186658065280:c=837,e=903,p=0,cr=27,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=11125659520
BINDS #140186658065280:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=56 off=0
kxsbbbfp=7f7fbff4c178 bln=22 avl=03 flg=05
value=106
Bind#1
oacdty=01 mxl=32(11) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0001 frm=01 csi=852 siz=0 off=24
kxsbbbfp=7f7fbff4c190 bln=32 avl=11 flg=01
value="ADGREDIRECT"
EXEC #140186658065280:c=508,e=508,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=1278882766,tim=11125660057
FETCH #140186658065280:c=47,e=47,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,plh=1278882766,tim=11125660111
STAT #140186658065280 id=1 cnt=0 pid=0 pos=1 obj=256 op='TABLE ACCESS FULL LINK$ (cr=2 pr=0 pw=0 str=1 time=46 us cost=2 size=29 card=1)'
CLOSE #140186658065280:c=0,e=0,dep=1,type=3,tim=11125660165
WAIT #140186657718568: nam='asynch descriptor resize' ela= 5 outstanding #aio=0 current aio limit=0 new aio limit=128 obj#=-1 tim=11125660210
WAIT #140186657718568: nam='Disk file operations I/O' ela= 53 FileOperation=2 fileno=0 filetype=1 obj#=-1 tim=11125660255
WAIT #140186657718568: nam='Disk file operations I/O' ela= 5 FileOperation=2 fileno=1 filetype=1 obj#=-1 tim=11125660267
WAIT #140186657718568: nam='control file sequential read' ela= 14 file#=0 block#=1 blocks=1 obj#=-1 tim=11125660309
WAIT #140186657718568: nam='control file sequential read' ela= 3 file#=0 block#=16 blocks=1 obj#=-1 tim=11125660327
WAIT #140186657718568: nam='control file sequential read' ela= 3 file#=0 block#=18 blocks=1 obj#=-1 tim=11125660334
WAIT #140186657718568: nam='control file sequential read' ela= 3 file#=0 block#=285 blocks=1 obj#=-1 tim=11125660342
WAIT #140186657718568: nam='single-task message' ela= 14787 p1=0 p2=0 p3=0 obj#=-1 tim=11125675271
WAIT #140186657718568: nam='SQL*Net message from dblink' ela= 722 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125676275
WAIT #140186657718568: nam='SQL*Net message to dblink' ela= 1 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125676301
WAIT #140186657718568: nam='SQL*Net message from dblink' ela= 1512 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125677824
WAIT #140186657718568: nam='SQL*Net message to dblink' ela= 0 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125678182
WAIT #140186657718568: nam='SQL*Net message from dblink' ela= 13522 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125691718
WAIT #140186657718568: nam='SQL*Net message to dblink' ela= 2 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125694569
WAIT #140186657718568: nam='SQL*Net message from dblink' ela= 12701 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125707295
WAIT #140186657718568: nam='SQL*Net message to dblink' ela= 1 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125707485
WAIT #140186657718568: nam='SQL*Net message from dblink' ela= 135 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125707633
WAIT #140186657718568: nam='SQL*Net message to dblink' ela= 0 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125707804
WAIT #140186657718568: nam='SQL*Net message from dblink' ela= 4159 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125711974
WAIT #140186657718568: nam='SQL*Net message to dblink' ela= 1 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125712110
WAIT #140186657718568: nam='SQL*Net vector data to dblink' ela= 150 driver id=1952673792 #bytes=40 p3=2 obj#=-1 tim=11125712276
WAIT #140186657718568: nam='SQL*Net message from dblink' ela= 957 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125713252
WAIT #140186657718568: nam='Disk file operations I/O' ela= 20 FileOperation=2 fileno=201 filetype=6 obj#=-1 tim=11125713578
WAIT #140186657718568: nam='SQL*Net message to dblink' ela= 0 driver id=1952673792 #bytes=250 p3=0 obj#=-1 tim=11125713693
WAIT #140186657718568: nam='SQL*Net message from dblink' ela= 281 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125713981
WAIT #140186657718568: nam='SQL*Net message to dblink' ela= 0 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125714003
WAIT #140186657718568: nam='SQL*Net message from dblink' ela= 247 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125714258
WAIT #140186657718568: nam='SQL*Net message to dblink' ela= 0 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125714334
WAIT #140186657718568: nam='SQL*Net message from dblink' ela= 282 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125714624
=====================
PARSING IN CURSOR #140186657718568 len=31 dep=0 uid=106 oct=2 lid=106 tim=11125714963 hv=3384395508 ad='6be808d0' sqlid='9vp603v4vmjrn'
insert into t1 select * from t1
END OF STMT
PARSE #140186657718568:c=13115,e=61501,p=0,cr=55,cu=3,mis=1,r=0,dep=0,og=1,plh=0,tim=11125714963
WAIT #140186657718568: nam='SQL*Net message to dblink' ela= 1 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125715036
WAIT #140186657718568: nam='SQL*Net message from dblink' ela= 1053 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125716099
WAIT #140186657925176: nam='PGA memory operation' ela= 9 p1=65536 p2=1 p3=0 obj#=-1 tim=11125717286
=====================
PARSING IN CURSOR #140186657925176 len=316 dep=2 uid=0 oct=3 lid=0 tim=11125717312 hv=2851274006 ad='69627ed8' sqlid='6h3cwmunz5z8q'
select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)), max(bitand(nvl(option$,0), 8) /8), max(bitand(nvl(option$,0), 16) /16), max(bitand(nvl(option$,0),64) /64), max(bitand(nvl(option$,0), 128) /128) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
END OF STMT
BINDS #140186657925176:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbfe2bf08 bln=22 avl=04 flg=05
value=73197
EXEC #140186657925176:c=814,e=1060,p=0,cr=0,cu=3,mis=1,r=0,dep=2,og=4,plh=2968095032,tim=11125717377
FETCH #140186657925176:c=23,e=23,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,plh=2968095032,tim=11125717409
STAT #140186657925176 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT GROUP BY (cr=2 pr=0 pw=0 str=1 time=34 us cost=4 size=17 card=1)'
STAT #140186657925176 id=2 cnt=0 pid=1 pos=1 obj=61 op='TABLE ACCESS BY INDEX ROWID BATCHED OBJAUTH$ (cr=2 pr=0 pw=0 str=1 time=21 us cost=3 size=17 card=1)'
STAT #140186657925176 id=3 cnt=0 pid=2 pos=1 obj=62 op='INDEX RANGE SCAN I_OBJAUTH1 (cr=2 pr=0 pw=0 str=1 time=19 us cost=2 size=0 card=1)'
CLOSE #140186657925176:c=0,e=0,dep=2,type=3,tim=11125717469
WAIT #140186658533384: nam='PGA memory operation' ela= 7 p1=65536 p2=1 p3=0 obj#=-1 tim=11125718150
=====================
PARSING IN CURSOR #140186658533384 len=298 dep=2 uid=0 oct=3 lid=0 tim=11125718173 hv=3498487326 ad='69540de0' sqlid='a4n4ayr88dbhy'
select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2)),max(bitand(nvl(option$,0), 8) /8), max(bitand(nvl(option$,0), 16) /16), max(bitand(nvl(option$,0),64) /64), max(bitand(nvl(option$,0), 128) /128) from objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by grantee#
END OF STMT
BINDS #140186658533384:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbfecbf08 bln=22 avl=04 flg=05
value=73197
EXEC #140186658533384:c=744,e=744,p=0,cr=0,cu=3,mis=1,r=0,dep=2,og=4,plh=2968095032,tim=11125718235
FETCH #140186658533384:c=9,e=9,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,plh=2968095032,tim=11125718254
STAT #140186658533384 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT GROUP BY (cr=2 pr=0 pw=0 str=1 time=16 us cost=4 size=17 card=1)'
STAT #140186658533384 id=2 cnt=0 pid=1 pos=1 obj=61 op='TABLE ACCESS BY INDEX ROWID BATCHED OBJAUTH$ (cr=2 pr=0 pw=0 str=1 time=8 us cost=3 size=17 card=1)'
STAT #140186658533384 id=3 cnt=0 pid=2 pos=1 obj=62 op='INDEX RANGE SCAN I_OBJAUTH1 (cr=2 pr=0 pw=0 str=1 time=7 us cost=2 size=0 card=1)'
CLOSE #140186658533384:c=0,e=1,dep=2,type=3,tim=11125718309
=====================
PARSING IN CURSOR #140186657535504 len=388 dep=2 uid=106 oct=3 lid=106 tim=11125718604 hv=2533870589 ad='6c5d5798' sqlid='7u43yfybhgkzx'
SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE RESULT_CACHE(SNAPSHOT=3600) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL(SAMPLESUB) NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1),:"SYS_B_0"), NVL(SUM(C2),:"SYS_B_1") FROM (SELECT /*+ NO_PARALLEL("P") FULL("P") NO_PARALLEL_INDEX("P") */ :"SYS_B_2" AS C1, :"SYS_B_3" AS C2 FROM "TEST"."T1" "P") SAMPLESUB
END OF STMT
PARSE #140186657535504:c=159,e=159,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=1,plh=0,tim=11125718604
=====================
PARSING IN CURSOR #140186659210440 len=221 dep=3 uid=0 oct=3 lid=0 tim=11125718710 hv=2723145788 ad='6b5d4488' sqlid='50vxqdkj4zu1w'
select user#,password,datats#,tempts#,type#,defrole,resource$,ptime,decode(defschclass,NULL,'DEFAULT_CONSUMER_GROUP',defschclass),spare1,spare4,ext_username,spare2,nvl(spare3,16382),spare9,spare10 from user$ where name=:1
END OF STMT
BINDS #140186659210440:
Bind#0
oacdty=01 mxl=32(06) mxlc=00 mal=00 scl=00 pre=00
oacflg=18 fl2=0001 frm=01 csi=852 siz=32 off=0
kxsbbbfp=7f7fc005fe40 bln=32 avl=06 flg=05
value="SYSTEM"
EXEC #140186659210440:c=48,e=47,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,plh=1457651150,tim=11125718746
FETCH #140186659210440:c=14,e=13,p=0,cr=2,cu=0,mis=0,r=1,dep=3,og=4,plh=1457651150,tim=11125718767
CLOSE #140186659210440:c=0,e=0,dep=3,type=3,tim=11125718777
WAIT #140186657535504: nam='PGA memory operation' ela= 8 p1=65536 p2=2 p3=0 obj#=-1 tim=11125719280
WAIT #140186657535504: nam='PGA memory operation' ela= 3 p1=65536 p2=1 p3=0 obj#=-1 tim=11125719302
WAIT #140186657535504: nam='PGA memory operation' ela= 1 p1=65536 p2=1 p3=0 obj#=-1 tim=11125719311
BINDS #140186657535504:
Bind#0
oacdty=02 mxl=22(01) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0100 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbfecbd58 bln=22 avl=01 flg=09
value=0
Bind#1
oacdty=02 mxl=22(01) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0100 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbfecbd30 bln=22 avl=01 flg=09
value=0
Bind#2
oacdty=02 mxl=22(02) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0100 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbfecbd08 bln=22 avl=02 flg=09
value=1
Bind#3
oacdty=02 mxl=22(02) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0100 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbfecbce0 bln=22 avl=02 flg=09
value=1
EXEC #140186657535504:c=760,e=760,p=0,cr=2,cu=0,mis=1,r=0,dep=2,og=1,plh=3724264953,tim=11125719395
=====================
PARSING IN CURSOR #140186657595904 len=142 dep=3 uid=0 oct=3 lid=0 tim=11125719736 hv=361892850 ad='6c6403b8' sqlid='7bd391hat42zk'
select /*+ rule */ name,file#,block#,status$,user#,undosqn,xactsqn,scnbas,scnwrp,DECODE(inst#,0,NULL,inst#),ts#,spare1 from undo$ where us#=:1
END OF STMT
PARSE #140186657595904:c=413,e=287,p=0,cr=0,cu=0,mis=1,r=0,dep=3,og=3,plh=0,tim=11125719735
WAIT #140186657595904: nam='PGA memory operation' ela= 4 p1=65536 p2=1 p3=0 obj#=-1 tim=11125720072
WAIT #140186657595904: nam='PGA memory operation' ela= 4 p1=65536 p2=1 p3=0 obj#=-1 tim=11125720149
BINDS #140186657595904:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=1000001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbfe0b0f0 bln=22 avl=02 flg=05
value=3
EXEC #140186657595904:c=471,e=471,p=0,cr=0,cu=0,mis=1,r=0,dep=3,og=3,plh=906473769,tim=11125720249
FETCH #140186657595904:c=10,e=10,p=0,cr=2,cu=0,mis=0,r=1,dep=3,og=3,plh=906473769,tim=11125720270
STAT #140186657595904 id=1 cnt=1 pid=0 pos=1 obj=15 op='TABLE ACCESS BY INDEX ROWID UNDO$ (cr=2 pr=0 pw=0 str=1 time=9 us)'
STAT #140186657595904 id=2 cnt=1 pid=1 pos=1 obj=34 op='INDEX UNIQUE SCAN I_UNDO1 (cr=1 pr=0 pw=0 str=1 time=5 us)'
CLOSE #140186657595904:c=3,e=3,dep=3,type=0,tim=11125720308
WAIT #140186657535504: nam='PGA memory operation' ela= 3 p1=196608 p2=1 p3=0 obj#=-1 tim=11125720360
WAIT #140186657535504: nam='PGA memory operation' ela= 2 p1=196608 p2=1 p3=0 obj#=-1 tim=11125720426
FETCH #140186657535504:c=1262,e=1183,p=0,cr=11,cu=0,mis=0,r=1,dep=2,og=1,plh=3724264953,tim=11125720585
STAT #140186657535504 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT AGGREGATE (cr=11 pr=0 pw=0 str=1 time=1185 us)'
STAT #140186657535504 id=2 cnt=514 pid=1 pos=1 obj=73197 op='TABLE ACCESS FULL T1 (cr=11 pr=0 pw=0 str=1 time=986 us cost=3 size=0 card=409)'
CLOSE #140186657535504:c=3,e=3,dep=2,type=0,tim=11125720647
=====================
PARSING IN CURSOR #140186658813016 len=236 dep=2 uid=0 oct=3 lid=0 tim=11125720712 hv=4126578894 ad='69793398' sqlid='0sbbcuruzd66f'
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln, minimum_enc, maximum_enc from hist_head$ where obj#=:1 and intcol#=:2
END OF STMT
BINDS #140186658813016:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=48 off=0
kxsbbbfp=7f7fbfe2bef0 bln=22 avl=04 flg=05
value=73197
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=24
kxsbbbfp=7f7fbfe2bf08 bln=22 avl=02 flg=01
value=1
EXEC #140186658813016:c=20,e=61,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,plh=2239883476,tim=11125720763
FETCH #140186658813016:c=8,e=8,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=3,plh=2239883476,tim=11125720778
CLOSE #140186658813016:c=1,e=1,dep=2,type=3,tim=11125720788
=====================
PARSING IN CURSOR #140186656798232 len=36 dep=1 uid=106 oct=3 lid=106 tim=11125720970 hv=2998677022 ad='6bece588' sqlid='1qffndqtbsbhy'
SELECT /*+ FULL(P) +*/ * FROM "T1" P
END OF STMT
PARSE #140186656798232:c=4566,e=4841,p=0,cr=20,cu=6,mis=1,r=0,dep=1,og=1,plh=3617692013,tim=11125720970
WAIT #140186656798232: nam='SQL*Net message to dblink' ela= 1 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125721009
WAIT #140186657718568: nam='SQL*Net message from dblink' ela= 899 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125721934
=====================
PARSING IN CURSOR #140186657535504 len=388 dep=2 uid=106 oct=3 lid=106 tim=11125722550 hv=2533870589 ad='6c5d5798' sqlid='7u43yfybhgkzx'
SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE RESULT_CACHE(SNAPSHOT=3600) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL(SAMPLESUB) NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1),:"SYS_B_0"), NVL(SUM(C2),:"SYS_B_1") FROM (SELECT /*+ NO_PARALLEL("P") FULL("P") NO_PARALLEL_INDEX("P") */ :"SYS_B_2" AS C1, :"SYS_B_3" AS C2 FROM "TEST"."T1" "P") SAMPLESUB
END OF STMT
PARSE #140186657535504:c=199,e=199,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=1,plh=0,tim=11125722549
BINDS #140186657535504:
Bind#0
oacdty=02 mxl=22(01) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0100 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbfecbd58 bln=22 avl=01 flg=09
value=0
Bind#1
oacdty=02 mxl=22(01) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0100 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbfecbd30 bln=22 avl=01 flg=09
value=0
Bind#2
oacdty=02 mxl=22(02) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0100 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbfecbd08 bln=22 avl=02 flg=09
value=1
Bind#3
oacdty=02 mxl=22(02) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0100 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbfecbce0 bln=22 avl=02 flg=09
value=1
EXEC #140186657535504:c=403,e=660,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=1,plh=3724264953,tim=11125723241
FETCH #140186657535504:c=58,e=58,p=0,cr=7,cu=0,mis=0,r=1,dep=2,og=1,plh=3724264953,tim=11125723309
STAT #140186657535504 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT AGGREGATE (cr=7 pr=0 pw=0 str=1 time=62 us)'
STAT #140186657535504 id=2 cnt=514 pid=1 pos=1 obj=73197 op='TABLE ACCESS FULL T1 (cr=7 pr=0 pw=0 str=1 time=35 us cost=3 size=0 card=409)'
CLOSE #140186657535504:c=4,e=4,dep=2,type=0,tim=11125723360
WAIT #140186656798232: nam='SQL*Net message to dblink' ela= 1 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125723737
WAIT #140186657718568: nam='SQL*Net message from dblink' ela= 462 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125724217
CLOSE #140186656798232:c=0,e=4,dep=1,type=0,tim=11125724246
=====================
PARSING IN CURSOR #140186657535504 len=392 dep=2 uid=106 oct=3 lid=106 tim=11125724760 hv=1436943536 ad='6c7aa3f8' sqlid='fmwvyu9auc15h'
SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE RESULT_CACHE(SNAPSHOT=3600) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL(SAMPLESUB) NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1),:"SYS_B_0"), NVL(SUM(C2),:"SYS_B_1") FROM (SELECT /*+ NO_PARALLEL("A2") FULL("A2") NO_PARALLEL_INDEX("A2") */ :"SYS_B_2" AS C1, :"SYS_B_3" AS C2 FROM "TEST"."T1" "A2") SAMPLESUB
END OF STMT
PARSE #140186657535504:c=284,e=202,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=1,plh=0,tim=11125724759
BINDS #140186657535504:
Bind#0
oacdty=02 mxl=22(01) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0100 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbfecbd58 bln=22 avl=01 flg=09
value=0
Bind#1
oacdty=02 mxl=22(01) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0100 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbfecbd30 bln=22 avl=01 flg=09
value=0
Bind#2
oacdty=02 mxl=22(02) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0100 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbfecbd08 bln=22 avl=02 flg=09
value=1
Bind#3
oacdty=02 mxl=22(02) mxlc=00 mal=00 scl=00 pre=00
oacflg=10 fl2=0100 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7f7fbfecbce0 bln=22 avl=02 flg=09
value=1
EXEC #140186657535504:c=594,e=594,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=1,plh=3724264953,tim=11125725392
FETCH #140186657535504:c=155,e=440,p=0,cr=7,cu=0,mis=0,r=1,dep=2,og=1,plh=3724264953,tim=11125725839
STAT #140186657535504 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT AGGREGATE (cr=7 pr=0 pw=0 str=1 time=442 us)'
STAT #140186657535504 id=2 cnt=514 pid=1 pos=1 obj=73197 op='TABLE ACCESS FULL T1 (cr=7 pr=0 pw=0 str=1 time=414 us cost=3 size=0 card=409)'
CLOSE #140186657535504:c=4,e=4,dep=2,type=0,tim=11125725901
=====================
PARSING IN CURSOR #140186656798232 len=26 dep=1 uid=106 oct=3 lid=106 tim=11125726094 hv=2150115330 ad='6c6deef8' sqlid='6sz39by02ha02'
SELECT "ID" FROM "T1" "A2"
END OF STMT
PARSE #140186656798232:c=1334,e=1832,p=0,cr=8,cu=0,mis=1,r=0,dep=1,og=1,plh=3617692013,tim=11125726094
EXEC #140186656798232:c=8,e=9,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=3617692013,tim=11125726128
WAIT #140186656798232: nam='SQL*Net message to dblink' ela= 1 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125726148
FETCH #140186656798232:c=41,e=41,p=0,cr=4,cu=0,mis=0,r=1,dep=1,og=1,plh=3617692013,tim=11125726201
WAIT #140186657718568: nam='SQL*Net message from dblink' ela= 361 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125726579
WAIT #140186656798232: nam='SQL*Net message to dblink' ela= 1 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125726614
FETCH #140186656798232:c=88,e=88,p=0,cr=6,cu=0,mis=0,r=513,dep=1,og=1,plh=3617692013,tim=11125726693
STAT #140186656798232 id=1 cnt=514 pid=0 pos=1 obj=73197 op='TABLE ACCESS FULL T1 (cr=10 pr=0 pw=0 str=1 time=76 us cost=3 size=6682 card=514)'
WAIT #140186657718568: nam='SQL*Net message from dblink' ela= 1864 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125728589
EXEC #140186657718568:c=9174,e=13801,p=0,cr=46,cu=6,mis=0,r=514,dep=0,og=1,plh=0,tim=11125728798
WAIT #140186657718568: nam='SQL*Net message to dblink' ela= 1 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125728825
WAIT #140186657718568: nam='SQL*Net vector data to dblink' ela= 97 driver id=1952673792 #bytes=26 p3=2 obj#=-1 tim=11125728932
WAIT #140186657718568: nam='SQL*Net message from dblink' ela= 1339 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11125730284
*** 2019-10-22T12:00:19.994685+08:00
WAIT #140186657718568: nam='standby query scn advance' ela= 1008824 p1=2065326 p2=0 p3=12000 obj#=-1 tim=11126739139
WAIT #140186657718568: nam='SQL*Net message to client' ela= 2 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=11126739249
*** 2019-10-22T12:00:21.782181+08:00
WAIT #140186657718568: nam='SQL*Net message from client' ela= 1787380 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=11128526641
CLOSE #140186657718568:c=18,e=18,dep=0,type=0,tim=11128526734
=====================
PARSING IN CURSOR #140186657718568 len=6 dep=0 uid=106 oct=44 lid=106 tim=11128526848 hv=3480936638 ad='0' sqlid='23wm3kz7rps5y'
commit
END OF STMT
PARSE #140186657718568:c=68,e=68,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,plh=0,tim=11128526847
XCTEND rlbk=0, rd_only=1, tim=11128526885
WAIT #140186657718568: nam='SQL*Net message to dblink' ela= 2 driver id=1952673792 #bytes=214 p3=0 obj#=-1 tim=11128526965
WAIT #140186657718568: nam='SQL*Net message from dblink' ela= 1292 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11128528264
WAIT #140186657718568: nam='SQL*Net message to dblink' ela= 1 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11128528372
WAIT #140186657718568: nam='SQL*Net vector data to dblink' ela= 60 driver id=1952673792 #bytes=27 p3=2 obj#=-1 tim=11128528451
WAIT #140186657718568: nam='SQL*Net message from dblink' ela= 298 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=11128528763
*** 2019-10-22T12:00:22.785048+08:00
WAIT #140186657718568: nam='standby query scn advance' ela= 1000727 p1=2065333 p2=0 p3=12000 obj#=-1 tim=11129529506
EXEC #140186657718568:c=489,e=1002683,p=0,cr=0,cu=4,mis=0,r=0,dep=0,og=0,plh=0,tim=11129529560
WAIT #140186657718568: nam='SQL*Net message to client' ela= 2 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=11129529591
*** 2019-10-22T12:00:31.566338+08:00
WAIT #140186657718568: nam='SQL*Net message from client' ela= 8781188 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=11138310791
CLOSE #140186657718568:c=7,e=7,dep=0,type=1,tim=11138310870
=====================
PARSING IN CURSOR #140186656809600 len=55 dep=0 uid=106 oct=42 lid=106 tim=11138311177 hv=2217940283 ad='6969a928' sqlid='06nvwn223659v'
alter session set events '10046 trace name context off'
END OF STMT
PARSE #140186656809600:c=287,e=287,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,plh=0,tim=11138311177
EXEC #140186656809600:c=226,e=226,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=0,tim=11138311437
分析：通过DB Link来重定向到主库执行。这个DB Link是内部的，在服务名等配置正常情况下，ORACLE能够自动完成内部操作
浙公网安备 33010602011771号