DB12_ora_8862.trc

Trace file /u01/app/oracle/diag/rdbms/db12/DB12/trace/DB12_ora_8862.trc
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
ORACLE_HOME = /u01/app/12.1.0.2/db
System name:    Linux
Node name:      ol6twsa.localdomain
Release:        2.6.39-400.17.1.el6uek.x86_64
Version:        #1 SMP Fri Feb 22 18:16:18 PST 2013
Machine:        x86_64
Instance name: DB12
Redo thread mounted by this instance: 1
Oracle process number: 29
Unix process pid: 8862, image: oracle@ol6twsa.localdomain (TNS V1-V3)


*** 2015-08-22 16:01:41.634
*** SESSION ID:(317.49462) 2015-08-22 16:01:41.634
*** CLIENT ID:() 2015-08-22 16:01:41.634
*** SERVICE NAME:(SYS$USERS) 2015-08-22 16:01:41.634
*** MODULE NAME:(sqlplus@ol6twsa.localdomain (TNS V1-V3)) 2015-08-22 16:01:41.634
*** CLIENT DRIVER:(SQL*PLUS) 2015-08-22 16:01:41.634
*** ACTION NAME:() 2015-08-22 16:01:41.634

=====================
PARSING IN CURSOR #140067846925480 len=76 dep=1 uid=116 oct=47 lid=116 tim=7096403410 hv=651488486 ad='80bdc6c8' sqlid='4stsk7hmd9v76'
begin
 dbms_monitor.session_trace_enable(binds => true, waits => true);
end;
END OF STMT
EXEC #140067846925480:c=0,e=344,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=1,plh=0,tim=7096403406
CLOSE #140067846925480:c=0,e=78,dep=1,type=1,tim=7096403721
=====================
PARSING IN CURSOR #140067846905088 len=111 dep=1 uid=116 oct=47 lid=116 tim=7096403827 hv=3166183278 ad='8054a918' sqlid='8ahvabfybh7vf'
begin
 if (user = 'TMDR')
 then
 dbms_monitor.session_trace_enable(binds => true, waits => true);
 end if;
end;
END OF STMT
PARSE #140067846905088:c=0,e=61,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=0,tim=7096403824
=====================
PARSING IN CURSOR #140067846009120 len=25 dep=2 uid=116 oct=3 lid=116 tim=7096404044 hv=4010258057 ad='a0627470' sqlid='1v717nvrhgbn9'
SELECT USER FROM SYS.DUAL
END OF STMT
PARSE #140067846009120:c=0,e=27,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=1388734953,tim=7096403999
EXEC #140067846009120:c=0,e=26,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=1388734953,tim=7096404105
FETCH #140067846009120:c=0,e=20,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=1,plh=1388734953,tim=7096404151
STAT #140067846009120 id=1 cnt=1 pid=0 pos=1 obj=0 op='FAST DUAL  (cr=0 pr=0 pw=0 time=9 us cost=2 size=0 card=1)'
CLOSE #140067846009120:c=0,e=15,dep=2,type=3,tim=7096404228
EXEC #140067846905088:c=0,e=382,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=1,plh=0,tim=7096404253
CLOSE #140067846905088:c=0,e=10,dep=1,type=1,tim=7096404292
=====================
PARSING IN CURSOR #140067845968192 len=105 dep=1 uid=0 oct=6 lid=0 tim=7096405405 hv=1462919866 ad='a03b1658' sqlid='9zg9qd9bm4spu'
update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :2) where user#=:1
END OF STMT
PARSE #140067845968192:c=0,e=35,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=2447725225,tim=7096405402
BINDS #140067845968192:
 Bind#0
  oacdty=12 mxl=07(07) mxlc=00 mal=00 scl=00 pre=00
  oacflg=10 fl2=0000 frm=00 csi=00 siz=8 off=0
  kxsbbbfp=8012dab8  bln=07  avl=07  flg=09
  value="8/22/2015 14:1:41"
 Bind#1
  No oacdef for this bind.
 Bind#2
  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
  oacflg=00 fl2=0000 frm=00 csi=00 siz=24 off=0
  kxsbbbfp=7f641635efb0  bln=22  avl=03  flg=05
  value=143
EXEC #140067845968192:c=999,e=1027,p=0,cr=2,cu=2,mis=0,r=1,dep=1,og=4,plh=2447725225,tim=7096406474
STAT #140067845968192 id=1 cnt=0 pid=0 pos=1 obj=0 op='UPDATE  USER$ (cr=2 pr=0 pw=0 time=269 us)'
STAT #140067845968192 id=2 cnt=1 pid=1 pos=1 obj=22 op='TABLE ACCESS CLUSTER USER$ (cr=2 pr=0 pw=0 time=24 us cost=1 size=6 card=1)'
STAT #140067845968192 id=3 cnt=1 pid=2 pos=1 obj=11 op='INDEX UNIQUE SCAN I_USER# (cr=1 pr=0 pw=0 time=11 us cost=0 size=0 card=1)'
=====================
PARSING IN CURSOR #140067846089624 len=271 dep=1 uid=0 oct=3 lid=0 tim=7096406728 hv=3876120609 ad='a0fab800' sqlid='f0h5rpzmhju11'
select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE'), STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN'), SYS_CONTEXT('USERENV', 'SERVICE_NAME')  from v$instance
END OF STMT
PARSE #140067846089624:c=0,e=36,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=2529664852,tim=7096406727
EXEC #140067846089624:c=0,e=187,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=2529664852,tim=7096406960
FETCH #140067846089624:c=0,e=986,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,plh=2529664852,tim=7096407980
STAT #140067846089624 id=1 cnt=1 pid=0 pos=1 obj=0 op='MERGE JOIN CARTESIAN (cr=0 pr=0 pw=0 time=1005 us cost=0 size=22 card=1)'
STAT #140067846089624 id=2 cnt=1 pid=1 pos=1 obj=0 op='MERGE JOIN CARTESIAN (cr=0 pr=0 pw=0 time=869 us cost=0 size=11 card=1)'
STAT #140067846089624 id=3 cnt=1 pid=2 pos=1 obj=0 op='FIXED TABLE FULL X$KSUXSINST (cr=0 pr=0 pw=0 time=115 us cost=0 size=11 card=1)'
STAT #140067846089624 id=4 cnt=1 pid=2 pos=2 obj=0 op='BUFFER SORT (cr=0 pr=0 pw=0 time=733 us cost=0 size=0 card=1)'
STAT #140067846089624 id=5 cnt=1 pid=4 pos=1 obj=0 op='FIXED TABLE FULL X$QUIESCE (cr=0 pr=0 pw=0 time=704 us cost=0 size=0 card=1)'
STAT #140067846089624 id=6 cnt=1 pid=1 pos=2 obj=0 op='BUFFER SORT (cr=0 pr=0 pw=0 time=76 us cost=0 size=11 card=1)'
STAT #140067846089624 id=7 cnt=1 pid=6 pos=1 obj=0 op='FIXED TABLE FULL X$KVIT (cr=0 pr=0 pw=0 time=41 us cost=0 size=11 card=1)'
CLOSE #140067846089624:c=0,e=107,dep=1,type=1,tim=7096408183
=====================
PARSING IN CURSOR #140067846088528 len=365 dep=1 uid=0 oct=3 lid=0 tim=7096408276 hv=2488826589 ad='a0baa208' sqlid='bvkckyya5hyqx'
select decode(upper(failover_method), NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(upper(failover_type), NULL, 1,  'NONE', 1, 'SESSION', 2, 'SELECT',  4, 'TRANSACTION',  8, 1), failover_retries, failover_delay, flags, nvl(replay_initiation_timeout, 300), decode(upper(session_state_consistency), 'STATIC', 16, 0)  from service$ where name = :1
END OF STMT
PARSE #140067846088528:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=395742348,tim=7096408272
BINDS #140067846088528:
 Bind#0
  oacdty=01 mxl=32(09) mxlc=00 mal=00 scl=00 pre=00
  oacflg=10 fl2=0001 frm=01 csi=873 siz=32 off=0
  kxsbbbfp=7f641635cb60  bln=32  avl=09  flg=05
  value="SYS$USERS"
EXEC #140067846088528:c=0,e=84,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=395742348,tim=7096408417
FETCH #140067846088528:c=0,e=106,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,plh=395742348,tim=7096408564
STAT #140067846088528 id=1 cnt=1 pid=0 pos=1 obj=390 op='TABLE ACCESS FULL SERVICE$ (cr=3 pr=0 pw=0 time=81 us cost=2 size=53 card=1)'
CLOSE #140067846088528:c=0,e=22,dep=1,type=1,tim=7096408610
WAIT #0: nam='SQL*Net message to client' ela= 4 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096408832
WAIT #0: nam='SQL*Net message from client' ela= 756 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096409700
WAIT #0: nam='SQL*Net message to client' ela= 4 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096409757
WAIT #0: nam='SQL*Net message from client' ela= 367 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096410138
=====================
PARSING IN CURSOR #140067846087088 len=89 dep=0 uid=143 oct=3 lid=143 tim=7096410217 hv=2230310627 ad='a0d94418' sqlid='0jqxg6f2fzpr3'
SELECT DECODE(USER, 'XS$NULL',  XS_SYS_CONTEXT('XS$SESSION','USERNAME'), USER) FROM DUAL
END OF STMT
PARSE #140067846087088:c=0,e=47,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=1388734953,tim=7096410214
EXEC #140067846087088:c=0,e=23,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=1388734953,tim=7096410273
WAIT #140067846087088: nam='SQL*Net message to client' ela= 4 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096410324
FETCH #140067846087088:c=0,e=25,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,plh=1388734953,tim=7096410369
STAT #140067846087088 id=1 cnt=1 pid=0 pos=1 obj=0 op='FAST DUAL  (cr=0 pr=0 pw=0 time=10 us cost=2 size=0 card=1)'
WAIT #140067846087088: nam='SQL*Net message from client' ela= 232 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096410643
FETCH #140067846087088:c=0,e=4,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,plh=1388734953,tim=7096410669
WAIT #140067846087088: nam='SQL*Net message to client' ela= 3 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096410693
WAIT #140067846087088: nam='SQL*Net message from client' ela= 332 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096411045
CLOSE #140067846087088:c=0,e=8,dep=0,type=1,tim=7096411077
=====================
PARSING IN CURSOR #140067846085648 len=154 dep=0 uid=143 oct=3 lid=143 tim=7096411184 hv=4253530419 ad='a0f13d10' sqlid='7hys3h7ysgf9m'
SELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
END OF STMT
PARSE #140067846085648:c=0,e=78,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=5300452,tim=7096411180
EXEC #140067846085648:c=0,e=23,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=5300452,tim=7096411239
WAIT #140067846085648: nam='SQL*Net message to client' ela= 4 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096411276
FETCH #140067846085648:c=0,e=40,p=0,cr=3,cu=0,mis=0,r=0,dep=0,og=1,plh=5300452,tim=7096411335
STAT #140067846085648 id=1 cnt=0 pid=0 pos=1 obj=20366 op='TABLE ACCESS FULL SQLPLUS_PRODUCT_PROFILE (cr=3 pr=0 pw=0 time=35 us cost=2 size=422 card=1)'
WAIT #140067846085648: nam='SQL*Net message from client' ela= 210 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096411587
CLOSE #140067846085648:c=0,e=7,dep=0,type=1,tim=7096411611
=====================
PARSING IN CURSOR #140067846084208 len=177 dep=0 uid=143 oct=3 lid=143 tim=7096411677 hv=616533857 ad='a09a2cc0' sqlid='cw6vxf0kbz3v1'
SELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
END OF STMT
PARSE #140067846084208:c=0,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=5300452,tim=7096411673
EXEC #140067846084208:c=0,e=20,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=5300452,tim=7096411727
WAIT #140067846084208: nam='SQL*Net message to client' ela= 4 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096411762
FETCH #140067846084208:c=0,e=24,p=0,cr=3,cu=0,mis=0,r=0,dep=0,og=1,plh=5300452,tim=7096411804
STAT #140067846084208 id=1 cnt=0 pid=0 pos=1 obj=20366 op='TABLE ACCESS FULL SQLPLUS_PRODUCT_PROFILE (cr=3 pr=0 pw=0 time=19 us cost=2 size=278 card=1)'
WAIT #140067846084208: nam='SQL*Net message from client' ela= 656 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096412501
CLOSE #140067846084208:c=0,e=7,dep=0,type=1,tim=7096412529
=====================
PARSING IN CURSOR #140067846082768 len=54 dep=0 uid=143 oct=47 lid=143 tim=7096412601 hv=4087094668 ad='a04160f8' sqlid='g4y6nw3tts7cc'
BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
END OF STMT
PARSE #140067846082768:c=0,e=42,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=0,tim=7096412597
BINDS #140067846082768:
 Bind#0
  oacdty=01 mxl=32(24) mxlc=00 mal=00 scl=00 pre=00
  oacflg=03 fl2=1000000 frm=01 csi=873 siz=32 off=0
  kxsbbbfp=7f641635b710  bln=32  avl=08  flg=05
  value="SQL*Plus"
*** MODULE NAME:(SQL*Plus) 2015-08-22 16:01:41.644
*** ACTION NAME:() 2015-08-22 16:01:41.644

WAIT #140067846082768: nam='SQL*Net message to client' ela= 5 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096412789
EXEC #140067846082768:c=0,e=180,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,plh=0,tim=7096412815
WAIT #140067846082768: nam='SQL*Net message from client' ela= 149 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096413002
CLOSE #140067846082768:c=0,e=22,dep=0,type=1,tim=7096413029
=====================
PARSING IN CURSOR #140067846075840 len=40 dep=0 uid=143 oct=3 lid=143 tim=7096413097 hv=3933222116 ad='a05adfa8' sqlid='dyk4dprp70d74'
SELECT DECODE('A','A','1','2') FROM DUAL
END OF STMT
PARSE #140067846075840:c=0,e=39,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=1388734953,tim=7096413094
EXEC #140067846075840:c=0,e=19,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=1388734953,tim=7096413147
WAIT #140067846075840: nam='SQL*Net message to client' ela= 4 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096413180
FETCH #140067846075840:c=0,e=65,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,plh=1388734953,tim=7096413262
STAT #140067846075840 id=1 cnt=1 pid=0 pos=1 obj=0 op='FAST DUAL  (cr=0 pr=0 pw=0 time=10 us cost=2 size=0 card=1)'
WAIT #140067846075840: nam='SQL*Net message from client' ela= 328 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096413635
CLOSE #140067846075840:c=0,e=7,dep=0,type=1,tim=7096413663
XCTEND rlbk=0, rd_only=1, tim=7096413697
WAIT #0: nam='SQL*Net message to client' ela= 4 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096413730
WAIT #0: nam='SQL*Net message from client' ela= 125 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096413866
XCTEND rlbk=0, rd_only=1, tim=7096413887
WAIT #0: nam='SQL*Net message to client' ela= 3 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096413916
WAIT #0: nam='SQL*Net message from client' ela= 686 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096414613
=====================
PARSING IN CURSOR #140067846074400 len=30 dep=0 uid=143 oct=3 lid=143 tim=7096414758 hv=2263425587 ad='a0b25280' sqlid='61tj0fa3fk8jm'
select c2,c3 from t where c1=1
END OF STMT
PARSE #140067846074400:c=0,e=47,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=3144273055,tim=7096414754
EXEC #140067846074400:c=0,e=31,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=3144273055,tim=7096414822
WAIT #140067846074400: nam='SQL*Net message to client' ela= 3 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096414857
FETCH #140067846074400:c=0,e=56,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=1,plh=3144273055,tim=7096414932
STAT #140067846074400 id=1 cnt=1 pid=0 pos=1 obj=92639 op='TABLE ACCESS BY INDEX ROWID T (cr=3 pr=0 pw=0 time=57 us cost=2 size=20 card=1)'
STAT #140067846074400 id=2 cnt=1 pid=1 pos=1 obj=92641 op='INDEX UNIQUE SCAN SYS_C0010228 (cr=2 pr=0 pw=0 time=27 us cost=1 size=0 card=1)'
WAIT #140067846074400: nam='SQL*Net message from client' ela= 235 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096415215
FETCH #140067846074400:c=0,e=3,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,plh=3144273055,tim=7096415239
WAIT #140067846074400: nam='SQL*Net message to client' ela= 3 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096415263
WAIT #140067846074400: nam='SQL*Net message from client' ela= 1137 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096416411
CLOSE #140067846074400:c=0,e=9,dep=0,type=1,tim=7096416453
=====================
PARSING IN CURSOR #140067846073304 len=38 dep=0 uid=143 oct=3 lid=143 tim=7096416542 hv=3544265942 ad='a049cb48' sqlid='6hzg2vm9n2d6q'
select c3, count(*)
from t
group by c3
END OF STMT
PARSE #140067846073304:c=0,e=41,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=47235625,tim=7096416539
EXEC #140067846073304:c=0,e=101,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=47235625,tim=7096416679
WAIT #140067846073304: nam='SQL*Net message to client' ela= 3 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=7096416716
WAIT #140067846073304: nam='Disk file operations I/O' ela= 25 FileOperation=2 fileno=6 filetype=2 obj#=92639 tim=7096417430
WAIT #140067846073304: nam='direct path read' ela= 45 file number=6 first dba=171 block cnt=5 obj#=92639 tim=7096417512
WAIT #140067846073304: nam='direct path read' ela= 41 file number=6 first dba=192 block cnt=8 obj#=92639 tim=7096417585
WAIT #140067846073304: nam='direct path read' ela= 29 file number=6 first dba=225 block cnt=7 obj#=92639 tim=7096417657
WAIT #140067846073304: nam='direct path read' ela= 25 file number=6 first dba=240 block cnt=8 obj#=92639 tim=7096417752
WAIT #140067846073304: nam='direct path read' ela= 24 file number=6 first dba=40209 block cnt=7 obj#=92639 tim=7096417822
WAIT #140067846073304: nam='direct path read' ela= 23 file number=6 first dba=40224 block cnt=8 obj#=92639 tim=7096417894
WAIT #140067846073304: nam='direct path read' ela= 23 file number=6 first dba=40233 block cnt=7 obj#=92639 tim=7096417962
WAIT #140067846073304: nam='direct path read' ela= 27 file number=6 first dba=40248 block cnt=8 obj#=92639 tim=7096418085
WAIT #140067846073304: nam='direct path read' ela= 24 file number=6 first dba=40257 block cnt=7 obj#=92639 tim=7096418229
WAIT #140067846073304: nam='direct path read' ela= 23 file number=6 first dba=40272 block cnt=8 obj#=92639 tim=7096418306
WAIT #140067846073304: nam='direct path read' ela= 23 file number=6 first dba=40281 block cnt=7 obj#=92639 tim=7096418374
WAIT #140067846073304: nam='direct path read' ela= 24 file number=6 first dba=40296 block cnt=8 obj#=92639 tim=7096418445
WAIT #140067846073304: nam='direct path read' ela= 46 file number=6 first dba=40313 block cnt=15 obj#=92639 tim=7096418524
WAIT #140067846073304: nam='direct path read' ela= 46 file number=6 first dba=40337 block cnt=15 obj#=92639 tim=7096418618
WAIT #140067846073304: nam='direct path read' ela= 165 file number=6 first dba=40450 block cnt=62 obj#=92639 tim=7096418817
WAIT #140067846073304: nam='direct path read' ela= 125 file number=6 first dba=40512 block cnt=64 obj#=92639 tim=7096419272
WAIT #140067846073304: nam='direct path read' ela= 78 file number=6 first dba=40706 block cnt=62 obj#=92639 tim=7096419502
WAIT #140067846073304: nam='direct path read' ela= 81 file number=6 first dba=40768 block cnt=64 obj#=92639 tim=7096419711
WAIT #140067846073304: nam='direct path read' ela= 157 file number=6 first dba=40834 block cnt=62 obj#=92639 tim=7096420082
WAIT #140067846073304: nam='direct path read' ela= 81 file number=6 first dba=40896 block cnt=64 obj#=92639 tim=7096420416
WAIT #140067846073304: nam='direct path read' ela= 76 file number=6 first dba=41090 block cnt=62 obj#=92639 tim=7096420697
WAIT #140067846073304: nam='direct path read' ela= 78 file number=6 first dba=41152 block cnt=64 obj#=92639 tim=7096421181
WAIT #140067846073304: nam='direct path read' ela= 74 file number=6 first dba=41218 block cnt=62 obj#=92639 tim=7096421472
WAIT #140067846073304: nam='direct path read' ela= 72 file number=6 first dba=41280 block cnt=64 obj#=92639 tim=7096421695
WAIT #140067846073304: nam='direct path read' ela= 77 file number=6 first dba=41474 block cnt=62 obj#=92639 tim=7096422574
WAIT #140067846073304: nam='direct path read' ela= 78 file number=6 first dba=41536 block cnt=64 obj#=92639 tim=7096422815
WAIT #140067846073304: nam='direct path read' ela= 75 file number=6 first dba=41602 block cnt=62 obj#=92639 tim=7096423126
WAIT #140067846073304: nam='direct path read' ela= 172 file number=6 first dba=41664 block cnt=64 obj#=92639 tim=7096423585
WAIT #140067846073304: nam='direct path read' ela= 89 file number=6 first dba=41858 block cnt=62 obj#=92639 tim=7096424138
WAIT #140067846073304: nam='direct path read' ela= 81 file number=6 first dba=41920 block cnt=64 obj#=92639 tim=7096424407
WAIT #140067846073304: nam='direct path read' ela= 81 file number=6 first dba=41986 block cnt=62 obj#=92639 tim=7096424749
WAIT #140067846073304: nam='direct path read' ela= 77 file number=6 first dba=42048 block cnt=64 obj#=92639 tim=7096425057
WAIT #140067846073304: nam='direct path read' ela= 77 file number=6 first dba=42242 block cnt=62 obj#=92639 tim=7096425382
WAIT #140067846073304: nam='direct path read' ela= 195 file number=6 first dba=42304 block cnt=64 obj#=92639 tim=7096425821
WAIT #140067846073304: nam='direct path read' ela= 79 file number=6 first dba=42498 block cnt=62 obj#=92639 tim=7096426141
WAIT #140067846073304: nam='direct path read' ela= 80 file number=6 first dba=42560 block cnt=64 obj#=92639 tim=7096426451
WAIT #140067846073304: nam='direct path read' ela= 78 file number=6 first dba=42626 block cnt=62 obj#=92639 tim=7096426748
WAIT #140067846073304: nam='direct path read' ela= 92 file number=6 first dba=42688 block cnt=64 obj#=92639 tim=7096428667
WAIT #140067846073304: nam='direct path read' ela= 78 file number=6 first dba=42882 block cnt=62 obj#=92639 tim=7096428984
WAIT #140067846073304: nam='direct path read' ela= 80 file number=6 first dba=42944 block cnt=64 obj#=92639 tim=7096429133
WAIT #140067846073304: nam='direct path read' ela= 79 file number=6 first dba=43010 block cnt=62 obj#=92639 tim=7096429435
WAIT #140067846073304: nam='direct path read' ela= 85 file number=6 first dba=43072 block cnt=64 obj#=92639 tim=7096429781
WAIT #140067846073304: nam='direct path read' ela= 79 file number=6 first dba=43266 block cnt=62 obj#=92639 tim=7096430124
WAIT #140067846073304: nam='direct path read' ela= 80 file number=6 first dba=43328 block cnt=64 obj#=92639 tim=7096430470
WAIT #140067846073304: nam='direct path read' ela= 77 file number=6 first dba=43394 block cnt=62 obj#=92639 tim=7096430765
WAIT #140067846073304: nam='direct path read' ela= 81 file number=6 first dba=43456 block cnt=64 obj#=92639 tim=7096430885
WAIT #140067846073304: nam='direct path read' ela= 88 file number=6 first dba=43650 block cnt=62 obj#=92639 tim=7096431059
WAIT #140067846073304: nam='direct path read' ela= 64 file number=6 first dba=43712 block cnt=64 obj#=92639 tim=7096431212
WAIT #140067846073304: nam='direct path read' ela= 80 file number=6 first dba=43778 block cnt=62 obj#=92639 tim=7096431375
WAIT #140067846073304: nam='direct path read' ela= 65 file number=6 first dba=43840 block cnt=64 obj#=92639 tim=7096431519
WAIT #140067846073304: nam='direct path read' ela= 79 file number=6 first dba=44034 block cnt=62 obj#=92639 tim=7096431680
WAIT #140067846073304: nam='direct path read' ela= 116 file number=6 first dba=44096 block cnt=64 obj#=92639 tim=7096431858
WAIT #140067846073304: nam='direct path read' ela= 905 file number=6 first dba=44162 block cnt=62 obj#=92639 tim=7096432895
WAIT #140067846073304: nam='direct path read' ela= 87 file number=6 first dba=44224 block cnt=64 obj#=92639 tim=7096433082
WAIT #140067846073304: nam='direct path read' ela= 73 file number=6 first dba=44418 block cnt=62 obj#=92639 tim=7096433255
WAIT #140067846073304: nam='direct path read' ela= 75 file number=6 first dba=44480 block cnt=64 obj#=92639 tim=7096433427
WAIT #140067846073304: nam='direct path read' ela= 87 file number=6 first dba=44674 block cnt=62 obj#=92639 tim=7096433618
WAIT #140067846073304: nam='direct path read' ela= 75 file number=6 first dba=44736 block cnt=64 obj#=92639 tim=7096433794
WAIT #140067846073304: nam='direct path read' ela= 116 file number=6 first dba=44802 block cnt=62 obj#=92639 tim=7096434051
WAIT #140067846073304: nam='direct path read' ela= 76 file number=6 first dba=44864 block cnt=64 obj#=92639 tim=7096434183
WAIT #140067846073304: nam='direct path read' ela= 71 file number=6 first dba=45058 block cnt=62 obj#=92639 tim=7096434355
WAIT #140067846073304: nam='direct path read' ela= 88 file number=6 first dba=45120 block cnt=64 obj#=92639 tim=7096434541
WAIT #140067846073304: nam='direct path read' ela= 76 file number=6 first dba=45186 block cnt=62 obj#=92639 tim=7096435382
WAIT #140067846073304: nam='direct path read' ela= 74 file number=6 first dba=45248 block cnt=64 obj#=92639 tim=7096435556
WAIT #140067846073304: nam='direct path read' ela= 664 file number=6 first dba=45442 block cnt=62 obj#=92639 tim=7096437196
WAIT #140067846073304: nam='direct path read' ela= 221 file number=6 first dba=45504 block cnt=64 obj#=92639 tim=7096438318
WAIT #140067846073304: nam='direct path read' ela= 109 file number=6 first dba=45632 block cnt=64 obj#=92639 tim=7096439382
FETCH #140067846073304:c=22997,e=25347,p=3458,cr=5086,cu=0,mis=0,r=1,dep=0,og=1,plh=47235625,tim=7096442083
WAIT #140067846073304: nam='SQL*Net message from client' ela= 310 driver id=1650815232 #bytes=1 p3=0 obj#=92639 tim=7096442462
WAIT #140067846073304: nam='SQL*Net message to client' ela= 4 driver id=1650815232 #bytes=1 p3=0 obj#=92639 tim=7096442514
FETCH #140067846073304:c=0,e=59,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,plh=47235625,tim=7096442560
STAT #140067846073304 id=1 cnt=2 pid=0 pos=1 obj=0 op='HASH GROUP BY (cr=5086 pr=3458 pw=0 time=25405 us cost=959 size=8 card=1)'
STAT #140067846073304 id=2 cnt=100002 pid=1 pos=1 obj=92639 op='TABLE ACCESS FULL T (cr=5086 pr=3458 pw=0 time=856755 us cost=956 size=800008 card=100001)'
WAIT #140067846073304: nam='SQL*Net message from client' ela= 514 driver id=1650815232 #bytes=1 p3=0 obj#=92639 tim=7096443575
CLOSE #140067846073304:c=0,e=12,dep=0,type=1,tim=7096443618
XCTEND rlbk=0, rd_only=1, tim=7096444276
=====================
PARSING IN CURSOR #140067846071864 len=23 dep=0 uid=143 oct=17 lid=143 tim=7096444559 hv=2726857479 ad='80ecc920' sqlid='2u3y9cqj8j2s7'
grant alter user to adm
END OF STMT
PARSE #140067846071864:c=1000,e=898,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,plh=0,tim=7096444556
CLOSE #140067845968192:c=0,e=8,dep=1,type=1,tim=7096444670
=====================
PARSING IN CURSOR #140067846081672 len=70 dep=1 uid=0 oct=3 lid=0 tim=7096444753 hv=1853064805 ad='a0a9bc90' sqlid='5hrvvu1r771m5'
 SELECT VALUE$ FROM SYS.PROPS$ WHERE NAME = 'OGG_TRIGGER_OPTIMIZATION'
END OF STMT
PARSE #140067846081672:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=415205717,tim=7096444749
EXEC #140067846081672:c=0,e=36,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=415205717,tim=7096444840
FETCH #140067846081672:c=0,e=55,p=0,cr=3,cu=0,mis=0,r=0,dep=1,og=4,plh=415205717,tim=7096444910
STAT #140067846081672 id=1 cnt=0 pid=0 pos=1 obj=126 op='TABLE ACCESS FULL PROPS$ (cr=3 pr=0 pw=0 time=52 us cost=2 size=28 card=1)'
=====================
PARSING IN CURSOR #140067846158264 len=189 dep=1 uid=0 oct=3 lid=0 tim=7096445252 hv=186852205 ad='a0c8c6b8' sqlid='2tkw12w5k68vd'
select user#,password,datats#,tempts#,type#,defrole,resource$, ptime,decode(defschclass,NULL,'DEFAULT_CONSUMER_GROUP',defschclass),spare1,spare4,ext_username,spare2 from user$ where name=:1
END OF STMT
PARSE #140067846158264:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=1457651150,tim=7096445248
BINDS #140067846158264:
 Bind#0
  oacdty=01 mxl=32(03) mxlc=00 mal=00 scl=00 pre=00
  oacflg=18 fl2=0001 frm=01 csi=873 siz=32 off=0
  kxsbbbfp=7f641636f368  bln=32  avl=03  flg=05
  value="ADM"
EXEC #140067846158264:c=0,e=77,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=1457651150,tim=7096445404
FETCH #140067846158264:c=0,e=30,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,plh=1457651150,tim=7096445453
STAT #140067846158264 id=1 cnt=0 pid=0 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$ (cr=1 pr=0 pw=0 time=38 us cost=1 size=170 card=1)'
STAT #140067846158264 id=2 cnt=0 pid=1 pos=1 obj=46 op='INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=22 us cost=0 size=0 card=1)'
CLOSE #140067846158264:c=0,e=8,dep=1,type=1,tim=7096445504
EXEC #140067846071864:c=999,e=961,p=0,cr=4,cu=0,mis=0,r=0,dep=0,og=1,plh=0,tim=7096445555
ERROR #140067846071864:err=1031 tim=7096445569
WAIT #140067846071864: nam='SQL*Net break/reset to client' ela= 9 driver id=1650815232 break?=1 p3=0 obj#=92639 tim=7096445677
WAIT #140067846071864: nam='SQL*Net break/reset to client' ela= 245 driver id=1650815232 break?=0 p3=0 obj#=92639 tim=7096445938
WAIT #140067846071864: nam='SQL*Net message to client' ela= 5 driver id=1650815232 #bytes=1 p3=0 obj#=92639 tim=7096445963
WAIT #140067846071864: nam='SQL*Net message from client' ela= 810 driver id=1650815232 #bytes=1 p3=0 obj#=92639 tim=7096446797
CLOSE #140067846071864:c=0,e=7,dep=0,type=0,tim=7096446836
=====================
PARSING IN CURSOR #140067846130592 len=76 dep=1 uid=0 oct=3 lid=0 tim=7096447251 hv=1052578227 ad='a0aa0df0' sqlid='04kug40zbu4dm'
select policy#, action# from aud_object_opt$ where object# = :1 and type = 2
END OF STMT
PARSE #140067846130592:c=0,e=42,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=4006480256,tim=7096447248
BINDS #140067846130592:
 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=7f64163425b0  bln=22  avl=04  flg=05
  value=92639
EXEC #140067846130592:c=0,e=57,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=4006480256,tim=7096447472
FETCH #140067846130592:c=0,e=90,p=0,cr=9,cu=0,mis=0,r=0,dep=1,og=4,plh=4006480256,tim=7096447588
STAT #140067846130592 id=1 cnt=0 pid=0 pos=1 obj=450 op='TABLE ACCESS FULL AUD_OBJECT_OPT$ (cr=9 pr=0 pw=0 time=86 us cost=4 size=114 card=1)'
CLOSE #140067846130592:c=0,e=7,dep=1,type=1,tim=7096447634
=====================
PARSING IN CURSOR #140067845972224 len=865 dep=1 uid=0 oct=3 lid=0 tim=7096447734 hv=715221786 ad='a0dca7e8' sqlid='616m6uhpa2usu'
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(cols) 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
PARSE #140067845972224:c=0,e=57,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=2556297882,tim=7096447730
BINDS #140067845972224:
 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=7f64163676f8  bln=22  avl=04  flg=05
  value=92639
 Bind#1
  No oacdef for this bind.
EXEC #140067845972224:c=0,e=127,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=2556297882,tim=7096447917
FETCH #140067845972224:c=1000,e=644,p=0,cr=7,cu=0,mis=0,r=1,dep=1,og=4,plh=2556297882,tim=7096448581
=====================
PARSING IN CURSOR #140067845048464 len=74 dep=1 uid=0 oct=3 lid=0 tim=7096448663 hv=3309402135 ad='a0e7f320' sqlid='5n1fs4m2n2y0r'
select pos#,intcol#,col#,spare1,bo#,spare2,spare3 from icol$ where obj#=:1
END OF STMT
PARSE #140067845048464:c=0,e=39,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=452367486,tim=7096448659
BINDS #140067845048464:
 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=7f6416362640  bln=22  avl=04  flg=05
  value=92641
EXEC #140067845048464:c=0,e=68,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=452367486,tim=7096448773
FETCH #140067845048464:c=0,e=52,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,plh=452367486,tim=7096448845
FETCH #140067845048464:c=0,e=13,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=452367486,tim=7096448885
STAT #140067845048464 id=1 cnt=1 pid=0 pos=1 obj=20 op='TABLE ACCESS BY INDEX ROWID BATCHED ICOL$ (cr=3 pr=0 pw=0 time=55 us cost=2 size=54 card=2)'
STAT #140067845048464 id=2 cnt=1 pid=1 pos=1 obj=42 op='INDEX RANGE SCAN I_ICOL1 (cr=2 pr=0 pw=0 time=27 us cost=1 size=0 card=2)'
CLOSE #140067845048464:c=0,e=5,dep=1,type=3,tim=7096448937
FETCH #140067845972224:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=2556297882,tim=7096448963
STAT #140067845972224 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=7 pr=0 pw=0 time=682 us cost=6 size=374 card=2)'
STAT #140067845972224 id=2 cnt=1 pid=1 pos=1 obj=0 op='HASH JOIN OUTER (cr=7 pr=0 pw=0 time=633 us cost=5 size=374 card=2)'
STAT #140067845972224 id=3 cnt=1 pid=2 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=4 pr=0 pw=0 time=135 us cost=2 size=288 card=2)'
STAT #140067845972224 id=4 cnt=1 pid=3 pos=1 obj=19 op='TABLE ACCESS CLUSTER IND$ (cr=3 pr=0 pw=0 time=61 us cost=2 size=184 card=2)'
STAT #140067845972224 id=5 cnt=1 pid=4 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=28 us cost=1 size=0 card=1)'
STAT #140067845972224 id=6 cnt=0 pid=3 pos=2 obj=75 op='TABLE ACCESS BY INDEX ROWID IND_STATS$ (cr=1 pr=0 pw=0 time=40 us cost=0 size=52 card=1)'
STAT #140067845972224 id=7 cnt=0 pid=6 pos=1 obj=76 op='INDEX UNIQUE SCAN I_IND_STATS$_OBJ# (cr=1 pr=0 pw=0 time=26 us cost=0 size=0 card=1)'
STAT #140067845972224 id=8 cnt=1 pid=2 pos=2 obj=0 op='VIEW  (cr=3 pr=0 pw=0 time=253 us cost=3 size=43 card=1)'
STAT #140067845972224 id=9 cnt=1 pid=8 pos=1 obj=0 op='SORT GROUP BY (cr=3 pr=0 pw=0 time=124 us cost=3 size=15 card=1)'
STAT #140067845972224 id=10 cnt=1 pid=9 pos=1 obj=31 op='TABLE ACCESS BY INDEX ROWID BATCHED CDEF$ (cr=3 pr=0 pw=0 time=59 us cost=2 size=15 card=1)'
STAT #140067845972224 id=11 cnt=1 pid=10 pos=1 obj=54 op='INDEX RANGE SCAN I_CDEF2 (cr=2 pr=0 pw=0 time=27 us cost=1 size=0 card=4)'
CLOSE #140067845972224:c=0,e=5,dep=1,type=3,tim=7096449065
=====================
PARSING IN CURSOR #140067844915648 len=418 dep=1 uid=0 oct=3 lid=0 tim=7096449149 hv=3759961951 ad='a0e8f920' sqlid='14d7z6mh1sxuz'
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) from col$ where obj#=:1 order by intcol#
END OF STMT
PARSE #140067844915648:c=0,e=40,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=3765558045,tim=7096449144
BINDS #140067844915648:
 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=7f64163676f8  bln=22  avl=04  flg=05
  value=92639
EXEC #140067844915648:c=0,e=77,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=3765558045,tim=7096449275
FETCH #140067844915648:c=0,e=69,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,plh=3765558045,tim=7096449365
FETCH #140067844915648:c=0,e=8,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,plh=3765558045,tim=7096449403
FETCH #140067844915648:c=0,e=8,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,plh=3765558045,tim=7096449437
FETCH #140067844915648:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=3765558045,tim=7096449469
STAT #140067844915648 id=1 cnt=3 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=3 pr=0 pw=0 time=80 us cost=3 size=793 card=13)'
STAT #140067844915648 id=2 cnt=3 pid=1 pos=1 obj=21 op='TABLE ACCESS CLUSTER COL$ (cr=3 pr=0 pw=0 time=40 us cost=2 size=793 card=13)'
STAT #140067844915648 id=3 cnt=1 pid=2 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=15 us cost=1 size=0 card=1)'
CLOSE #140067844915648:c=0,e=5,dep=1,type=3,tim=7096450149
=====================
PARSING IN CURSOR #140067846097552 len=276 dep=1 uid=0 oct=3 lid=0 tim=7096450424 hv=412367524 ad='a0e18018' sqlid='ct2g3h4c98fp4'
select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)), min(bitand(nvl(option$,0), 4) /4), max(bitand(nvl(option$,0), 8) /8), max(bitand(nvl(option$,0), 16) /16) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
END OF STMT
PARSE #140067846097552:c=0,e=90,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=2968095032,tim=7096450420
BINDS #140067846097552:
 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=7f64162460f8  bln=22  avl=04  flg=05
  value=92639
EXEC #140067846097552:c=0,e=72,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=2968095032,tim=7096450537
FETCH #140067846097552:c=0,e=38,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,plh=2968095032,tim=7096450595
STAT #140067846097552 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT GROUP BY (cr=2 pr=0 pw=0 time=56 us cost=4 size=16 card=1)'
STAT #140067846097552 id=2 cnt=0 pid=1 pos=1 obj=61 op='TABLE ACCESS BY INDEX ROWID BATCHED OBJAUTH$ (cr=2 pr=0 pw=0 time=33 us cost=3 size=16 card=1)'
STAT #140067846097552 id=3 cnt=0 pid=2 pos=1 obj=62 op='INDEX RANGE SCAN I_OBJAUTH1 (cr=2 pr=0 pw=0 time=20 us cost=2 size=0 card=1)'
CLOSE #140067846097552:c=0,e=4,dep=1,type=3,tim=7096450650
=====================
PARSING IN CURSOR #140067844938392 len=258 dep=1 uid=0 oct=3 lid=0 tim=7096450703 hv=743590400 ad='a0e0f538' sqlid='8uh6xphq54kh0'
select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2)),min(bitand(nvl(option$,0), 4) /4), max(bitand(nvl(option$,0), 8) /8), max(bitand(nvl(option$,0), 16) /16) from objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by grantee#
END OF STMT
PARSE #140067844938392:c=0,e=30,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=2968095032,tim=7096450699
BINDS #140067844938392:
 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=7f6416244500  bln=22  avl=04  flg=05
  value=92639
EXEC #140067844938392:c=0,e=69,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=2968095032,tim=7096450811
FETCH #140067844938392:c=0,e=30,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,plh=2968095032,tim=7096450861
STAT #140067844938392 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT GROUP BY (cr=2 pr=0 pw=0 time=45 us cost=4 size=16 card=1)'
STAT #140067844938392 id=2 cnt=0 pid=1 pos=1 obj=61 op='TABLE ACCESS BY INDEX ROWID BATCHED OBJAUTH$ (cr=2 pr=0 pw=0 time=27 us cost=3 size=16 card=1)'
STAT #140067844938392 id=3 cnt=0 pid=2 pos=1 obj=62 op='INDEX RANGE SCAN I_OBJAUTH1 (cr=2 pr=0 pw=0 time=13 us cost=2 size=0 card=1)'
CLOSE #140067844938392:c=0,e=5,dep=1,type=3,tim=7096450921
=====================
PARSING IN CURSOR #140067844931232 len=90 dep=1 uid=0 oct=3 lid=0 tim=7096450981 hv=3433193208 ad='a0e453c8' sqlid='cn6hhn36a4rrs'
select con#,obj#,rcon#,enabled,nvl(defer,0),spare2,spare3,refact from cdef$ where robj#=:1
END OF STMT
PARSE #140067844931232:c=0,e=30,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=3845132125,tim=7096450977
BINDS #140067844931232:
 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=7f641625f3a0  bln=22  avl=04  flg=05
  value=92639
EXEC #140067844931232:c=0,e=146,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=3845132125,tim=7096451210
FETCH #140067844931232:c=0,e=31,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,plh=3845132125,tim=7096451264
STAT #140067844931232 id=1 cnt=0 pid=0 pos=1 obj=31 op='TABLE ACCESS BY INDEX ROWID BATCHED CDEF$ (cr=2 pr=0 pw=0 time=108 us cost=2 size=90 card=3)'
STAT #140067844931232 id=2 cnt=0 pid=1 pos=1 obj=55 op='INDEX RANGE SCAN I_CDEF3 (cr=2 pr=0 pw=0 time=97 us cost=1 size=0 card=1)'
CLOSE #140067844931232:c=0,e=4,dep=1,type=3,tim=7096451311
=====================
PARSING IN CURSOR #140067845041904 len=160 dep=1 uid=0 oct=3 lid=0 tim=7096451368 hv=2880999359 ad='a0e54d88' 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
PARSE #140067845041904:c=0,e=34,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=4120883053,tim=7096451364
BINDS #140067845041904:
 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=7f641625cf68  bln=22  avl=04  flg=05
  value=92639
EXEC #140067845041904:c=0,e=76,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=4120883053,tim=7096451486
FETCH #140067845041904:c=0,e=34,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,plh=4120883053,tim=7096451545
=====================
PARSING IN CURSOR #140067845023960 len=70 dep=1 uid=0 oct=3 lid=0 tim=7096451610 hv=3849548163 ad='a0e22648' sqlid='53saa2zkr6wc3'
select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1
END OF STMT
PARSE #140067845023960:c=0,e=34,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=3038981986,tim=7096451606
BINDS #140067845023960:
 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=7f64162598d8  bln=22  avl=04  flg=05
  value=10228
EXEC #140067845023960:c=0,e=56,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=3038981986,tim=7096451705
FETCH #140067845023960:c=0,e=37,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,plh=3038981986,tim=7096451761
FETCH #140067845023960:c=0,e=13,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,plh=3038981986,tim=7096451799
STAT #140067845023960 id=1 cnt=1 pid=0 pos=1 obj=32 op='TABLE ACCESS BY INDEX ROWID BATCHED CCOL$ (cr=4 pr=0 pw=0 time=39 us cost=3 size=16 card=1)'
STAT #140067845023960 id=2 cnt=1 pid=1 pos=1 obj=57 op='INDEX RANGE SCAN I_CCOL1 (cr=3 pr=0 pw=0 time=24 us cost=2 size=0 card=1)'
CLOSE #140067845023960:c=0,e=4,dep=1,type=3,tim=7096451846
FETCH #140067845041904:c=0,e=13,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,plh=4120883053,tim=7096451878
STAT #140067845041904 id=1 cnt=1 pid=0 pos=1 obj=31 op='TABLE ACCESS BY INDEX ROWID BATCHED CDEF$ (cr=4 pr=0 pw=0 time=83 us cost=2 size=192 card=4)'
STAT #140067845041904 id=2 cnt=1 pid=1 pos=1 obj=54 op='INDEX RANGE SCAN I_CDEF2 (cr=3 pr=0 pw=0 time=18 us cost=1 size=0 card=4)'
CLOSE #140067845041904:c=0,e=5,dep=1,type=3,tim=7096451919
=====================
PARSING IN CURSOR #140067845031152 len=78 dep=1 uid=0 oct=3 lid=0 tim=7096452196 hv=2098305989 ad='a07a0780' sqlid='cusp9gtyj36y5'
select /*+ index(do) */ dir_cnt from opt_directive_own$ do where dir_own# = :1
END OF STMT
PARSE #140067845031152:c=0,e=38,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=3646447030,tim=7096452196
BINDS #140067845031152:
 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=7f64162598d8  bln=22  avl=11  flg=05
  value=4179826972593136002
EXEC #140067845031152:c=0,e=71,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=3646447030,tim=7096452873
FETCH #140067845031152:c=0,e=22,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,plh=3646447030,tim=7096452913
STAT #140067845031152 id=1 cnt=0 pid=0 pos=1 obj=611 op='TABLE ACCESS BY INDEX ROWID OPT_DIRECTIVE_OWN$ (cr=1 pr=0 pw=0 time=28 us cost=1 size=15 card=1)'
STAT #140067845031152 id=2 cnt=0 pid=1 pos=1 obj=612 op='INDEX UNIQUE SCAN I_OPT_DIRECTIVE_OWN# (cr=1 pr=0 pw=0 time=13 us cost=0 size=0 card=1)'
CLOSE #140067845031152:c=0,e=4,dep=1,type=3,tim=7096452957
=====================
PARSING IN CURSOR #140067846071864 len=36 dep=0 uid=143 oct=3 lid=143 tim=7096454087 hv=1622996743 ad='a07f0ea0' sqlid='797vcythbtxs7'
select count(*)  from t where c1 > 1
END OF STMT
PARSE #140067846071864:c=6999,e=7193,p=0,cr=37,cu=0,mis=1,r=0,dep=0,og=1,plh=3506273233,tim=7096454083
EXEC #140067846071864:c=0,e=28,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=3506273233,tim=7096454150
WAIT #140067846071864: nam='SQL*Net message to client' ela= 4 driver id=1650815232 #bytes=1 p3=0 obj#=92639 tim=7096454195
FETCH #140067846071864:c=13998,e=14170,p=0,cr=217,cu=0,mis=0,r=1,dep=0,og=1,plh=3506273233,tim=7096468387
STAT #140067846071864 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT AGGREGATE (cr=217 pr=0 pw=0 time=14168 us)'
STAT #140067846071864 id=2 cnt=100001 pid=1 pos=1 obj=92641 op='INDEX FAST FULL SCAN SYS_C0010228 (cr=217 pr=0 pw=0 time=470247 us cost=58 size=500005 card=100001)'
WAIT #140067846071864: nam='SQL*Net message from client' ela= 434 driver id=1650815232 #bytes=1 p3=0 obj#=92639 tim=7096468936
FETCH #140067846071864:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,plh=3506273233,tim=7096469082
WAIT #140067846071864: nam='SQL*Net message to client' ela= 4 driver id=1650815232 #bytes=1 p3=0 obj#=92639 tim=7096469112
WAIT #140067846071864: nam='SQL*Net message from client' ela= 542 driver id=1650815232 #bytes=1 p3=0 obj#=92639 tim=7096469668
XCTEND rlbk=0, rd_only=1, tim=7096469903
CLOSE #140067846071864:c=0,e=9,dep=0,type=0,tim=7096469975
CLOSE #140067846081672:c=0,e=7,dep=0,type=0,tim=7096470000

%d bloggers like this: