获得执行计划方法三-sql_trace
发表于：2024-11-23 作者：千家信息网编辑
千家信息网最后更新 2024年11月23日，1 追踪这个sesionSQL> alter session set sql_trace=true ;Session altered.2 执行想要跟踪的语句SQL> select * from sco
千家信息网最后更新 2024年11月23日获得执行计划方法三-sql_trace
1 追踪这个sesion
SQL> alter session set sql_trace=true ;Session altered.
2 执行想要跟踪的语句
SQL> select * from scott.emp ; EMPNO ENAME JOB MGR HIREDATE SAL COMM---------- ---------- --------- ---------- --------- ---------- ---------- DEPTNO---------- 7369 SMITH CLERK 7902 17-DEC-80 800 20 7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30 7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30 EMPNO ENAME JOB MGR HIREDATE SAL COMM---------- ---------- --------- ---------- --------- ---------- ---------- DEPTNO---------- 7566 JONES MANAGER 7839 02-APR-81 2975 20 7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30 7698 BLAKE MANAGER 7839 01-MAY-81 2850 30 EMPNO ENAME JOB MGR HIREDATE SAL COMM---------- ---------- --------- ---------- --------- ---------- ---------- DEPTNO---------- 7782 CLARK MANAGER 7839 09-JUN-81 2450 10 7788 SCOTT ANALYST 7566 19-APR-87 3000 20 7839 KING PRESIDENT 17-NOV-81 5000 10 EMPNO ENAME JOB MGR HIREDATE SAL COMM---------- ---------- --------- ---------- --------- ---------- ---------- DEPTNO---------- 7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30 7876 ADAMS CLERK 7788 23-MAY-87 1100 20 7900 JAMES CLERK 7698 03-DEC-81 950 30 EMPNO ENAME JOB MGR HIREDATE SAL COMM---------- ---------- --------- ---------- --------- ---------- ---------- DEPTNO---------- 7902 FORD ANALYST 7566 03-DEC-81 3000 20 7934 MILLER CLERK 7782 23-JAN-82 1300 1014 rows selected.
3 关闭sql trace
SQL> alter session set sql_trace=false;Session altered.
4 查看trace文件所在位置，摘自eygle.com
SQL> select d.value || '/' || lower(rtrim(i.instance, chr(0))) || '_ora_' || p.spid || '.trc' trace_file_name 2 from (select p.spid 3 from sys.v$mystat m, sys.v$session s, sys.v$process p 4 where m.statistic# = 1 5 and s.sid = m.sid 6 and p.addr = s.paddr) p, 7 (select t.instance 8 from sys.v$thread t, sys.v$parameter v 9 where v.name = 'thread' 10 and (v.value = 0 or t.thread# = to_number(v.value))) i, 11 (select value from sys.v$parameter where name = 'user_dump_dest') d 12 /TRACE_FILE_NAME--------------------------------------------------------------------------------/u01/oracle/admin/orcl/udump/orcl_ora_5331.trc
SQL> !5 查看trace文件[oracle@sunblaze ~]$ cat /u01/oracle/admin/orcl/udump/orcl_ora_5331.trc/u01/oracle/admin/orcl/udump/orcl_ora_5331.trcOracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsORACLE_HOME = /u01/oracle/product/OraHomeSystem name: LinuxNode name: sunblaze.comRelease: 2.6.9-42.ELsmpVersion: #1 SMP Wed Jul 12 23:27:17 EDT 2006Machine: i686Instance name: orclRedo thread mounted by this instance: 1Oracle process number: 22Unix process pid: 5331, p_w_picpath: oracle@sunblaze.com (TNS V1-V3)*** 2013-04-04 22:22:10.753*** SERVICE NAME:(SYS$USERS) 2013-04-04 22:22:10.752*** SESSION ID:(139.15) 2013-04-04 22:22:10.752=====================PARSING IN CURSOR #1 len=33 dep=0 uid=0 oct=42 lid=0 tim=1333091143313155 hv=1217565140 ad='2afac650'alter session set sql_trace=true END OF STMTEXEC #1:c=1000,e=1621,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=1333091143313136*** 2013-04-04 22:22:20.769=====================PARSING IN CURSOR #3 len=789 dep=1 uid=0 oct=3 lid=0 tim=1333091153095142 hv=3159716790 ad='30f17f14'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)),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 STMTPARSE #3:c=4000,e=2967,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333091153095128=====================PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153102422 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTPARSE #1:c=2000,e=1983,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=3,tim=1333091153102409EXEC #1:c=2999,e=2657,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=3,tim=1333091153105361FETCH #1:c=1000,e=571,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153106136STAT #1 id=1 cnt=1 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=3 pr=0 pw=0 time=565 us)'STAT #1 id=2 cnt=1 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=2 pr=0 pw=0 time=489 us)'=====================PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153106734 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTEXEC #1:c=0,e=100,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153106720FETCH #1:c=999,e=350,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153107239STAT #1 id=1 cnt=2 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=6 pr=0 pw=0 time=916 us)'STAT #1 id=2 cnt=2 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=4 pr=0 pw=0 time=784 us)'=====================PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153107851 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTEXEC #1:c=1000,e=145,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153107787FETCH #1:c=0,e=89,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153108104STAT #1 id=1 cnt=3 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=9 pr=0 pw=0 time=1008 us)'STAT #1 id=2 cnt=3 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=6 pr=0 pw=0 time=826 us)'EXEC #3:c=15997,e=16031,p=0,cr=9,cu=0,mis=1,r=0,dep=1,og=4,tim=1333091153112259FETCH #3:c=3000,e=3066,p=1,cr=8,cu=0,mis=0,r=1,dep=1,og=4,tim=1333091153115465=====================PARSING IN CURSOR #1 len=67 dep=1 uid=0 oct=3 lid=0 tim=1333091153116757 hv=2280069326 ad='30f2a8c4'select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1END OF STMTPARSE #1:c=1999,e=1050,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333091153116683=====================PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153118587 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTEXEC #4:c=1000,e=178,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153118572FETCH #4:c=0,e=157,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153118920STAT #4 id=1 cnt=4 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=12 pr=0 pw=0 time=1167 us)'STAT #4 id=2 cnt=4 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=8 pr=0 pw=0 time=911 us)'=====================PARSING IN CURSOR #4 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333091153120304 hv=3150898423 ad='30e94228'select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucketEND OF STMTPARSE #4:c=999,e=1126,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=3,tim=1333091153120292EXEC #4:c=2000,e=1327,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=3,tim=1333091153121864FETCH #4:c=0,e=291,p=1,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153122205STAT #4 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=3 pr=1 pw=0 time=304 us)'STAT #4 id=2 cnt=1 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=3 pr=1 pw=0 time=247 us)'STAT #4 id=3 cnt=1 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=2 pr=0 pw=0 time=55 us)'=====================PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153122475 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTEXEC #4:c=1000,e=43,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153122468FETCH #4:c=0,e=71,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153122605STAT #4 id=1 cnt=5 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=15 pr=0 pw=0 time=1237 us)'STAT #4 id=2 cnt=5 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=10 pr=0 pw=0 time=935 us)'EXEC #1:c=6999,e=6550,p=1,cr=9,cu=0,mis=1,r=0,dep=1,og=4,tim=1333091153123508FETCH #1:c=0,e=80,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1333091153123667FETCH #1:c=0,e=14,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=1333091153123722STAT #1 id=1 cnt=1 pid=0 pos=1 obj=20 op='TABLE ACCESS BY INDEX ROWID ICOL$ (cr=4 pr=0 pw=0 time=154 us)'STAT #1 id=2 cnt=1 pid=1 pos=1 obj=40 op='INDEX RANGE SCAN I_ICOL1 (cr=3 pr=0 pw=0 time=65 us)'FETCH #3:c=0,e=13,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1333091153123833STAT #3 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=8 pr=1 pw=0 time=3131 us)'STAT #3 id=2 cnt=1 pid=1 pos=1 obj=0 op='HASH JOIN OUTER (cr=8 pr=1 pw=0 time=2950 us)'STAT #3 id=3 cnt=1 pid=2 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=5 pr=0 pw=0 time=380 us)'STAT #3 id=4 cnt=1 pid=3 pos=1 obj=19 op='TABLE ACCESS CLUSTER IND$ (cr=4 pr=0 pw=0 time=229 us)'STAT #3 id=5 cnt=1 pid=4 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=94 us)'STAT #3 id=6 cnt=0 pid=3 pos=2 obj=710 op='TABLE ACCESS BY INDEX ROWID IND_STATS$ (cr=1 pr=0 pw=0 time=70 us)'STAT #3 id=7 cnt=0 pid=6 pos=1 obj=711 op='INDEX UNIQUE SCAN I_IND_STATS$_OBJ# (cr=1 pr=0 pw=0 time=43 us)'STAT #3 id=8 cnt=1 pid=2 pos=2 obj=0 op='VIEW (cr=3 pr=1 pw=0 time=1309 us)'STAT #3 id=9 cnt=1 pid=8 pos=1 obj=0 op='SORT GROUP BY (cr=3 pr=1 pw=0 time=1273 us)'STAT #3 id=10 cnt=1 pid=9 pos=1 obj=31 op='TABLE ACCESS BY INDEX ROWID CDEF$ (cr=3 pr=1 pw=0 time=1023 us)'STAT #3 id=11 cnt=2 pid=10 pos=1 obj=51 op='INDEX RANGE SCAN I_CDEF2 (cr=2 pr=0 pw=0 time=97 us)'=====================PARSING IN CURSOR #4 len=348 dep=1 uid=0 oct=3 lid=0 tim=1333091153124705 hv=2512561537 ad='30f2a1a4'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) from col$ where obj#=:1 order by intcol#END OF STMTPARSE #4:c=1000,e=583,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333091153124699=====================PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153125910 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTEXEC #1:c=0,e=53,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153125902FETCH #1:c=0,e=90,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153126062STAT #1 id=1 cnt=6 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=18 pr=0 pw=0 time=1329 us)'STAT #1 id=2 cnt=6 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=12 pr=0 pw=0 time=984 us)'=====================PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153126263 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTEXEC #3:c=0,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153126257FETCH #3:c=1000,e=45,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153126381STAT #3 id=1 cnt=7 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=21 pr=0 pw=0 time=1371 us)'STAT #3 id=2 cnt=7 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=14 pr=0 pw=0 time=1004 us)'=====================PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153126694 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTEXEC #1:c=0,e=47,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153126686FETCH #1:c=0,e=46,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153126802STAT #1 id=1 cnt=8 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=24 pr=0 pw=0 time=1420 us)'STAT #1 id=2 cnt=8 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=16 pr=0 pw=0 time=1028 us)'=====================PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153127017 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTEXEC #3:c=0,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153127012FETCH #3:c=0,e=25,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153127096STAT #3 id=1 cnt=8 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=26 pr=0 pw=0 time=1451 us)'STAT #3 id=2 cnt=8 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=18 pr=0 pw=0 time=1045 us)'=====================PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153127257 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTEXEC #1:c=0,e=31,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153127252FETCH #1:c=999,e=41,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153127371STAT #1 id=1 cnt=9 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=29 pr=0 pw=0 time=1493 us)'STAT #1 id=2 cnt=9 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=20 pr=0 pw=0 time=1064 us)'=====================PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153127574 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTEXEC #3:c=0,e=34,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153127568FETCH #3:c=0,e=40,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153127665STAT #3 id=1 cnt=10 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=32 pr=0 pw=0 time=1534 us)'STAT #3 id=2 cnt=10 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=22 pr=0 pw=0 time=1082 us)'=====================PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153127820 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTEXEC #1:c=0,e=32,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153127815FETCH #1:c=0,e=37,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153127908STAT #1 id=1 cnt=11 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=35 pr=0 pw=0 time=1573 us)'STAT #1 id=2 cnt=11 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=24 pr=0 pw=0 time=1098 us)'=====================PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153128095 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTEXEC #3:c=0,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153128089FETCH #3:c=0,e=39,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153128186STAT #3 id=1 cnt=12 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=38 pr=0 pw=0 time=1612 us)'STAT #3 id=2 cnt=12 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=26 pr=0 pw=0 time=1116 us)'EXEC #4:c=3999,e=4123,p=0,cr=23,cu=0,mis=1,r=0,dep=1,og=4,tim=1333091153128943FETCH #4:c=0,e=110,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1333091153129110FETCH #4:c=0,e=9,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=1333091153129168FETCH #4:c=0,e=8,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=1333091153129209FETCH #4:c=0,e=9,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=1333091153129281FETCH #4:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=1333091153129319FETCH #4:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=1333091153129356FETCH #4:c=0,e=8,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=1333091153129393FETCH #4:c=0,e=9,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=1333091153129461FETCH #4:c=0,e=10,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1333091153129502STAT #4 id=1 cnt=8 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=3 pr=0 pw=0 time=147 us)'STAT #4 id=2 cnt=8 pid=1 pos=1 obj=21 op='TABLE ACCESS CLUSTER COL$ (cr=3 pr=0 pw=0 time=89 us)'STAT #4 id=3 cnt=1 pid=2 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=27 us)'=====================PARSING IN CURSOR #3 len=116 dep=2 uid=0 oct=3 lid=0 tim=1333091153130629 hv=854877822 ad='30f29bc8'select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1END OF STMTPARSE #3:c=1000,e=387,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=4,tim=1333091153130624EXEC #3:c=1000,e=1046,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=4,tim=1333091153131772FETCH #3:c=0,e=91,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=1333091153131910STAT #3 id=1 cnt=1 pid=0 pos=1 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$ (cr=3 pr=0 pw=0 time=93 us)'STAT #3 id=2 cnt=1 pid=1 pos=1 obj=36 op='INDEX UNIQUE SCAN I_OBJ1 (cr=2 pr=0 pw=0 time=60 us)'=====================PARSING IN CURSOR #1 len=169 dep=1 uid=0 oct=3 lid=0 tim=1333091153132153 hv=1173719687 ad='30f1df48'select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#END OF STMTPARSE #1:c=2000,e=2278,p=0,cr=3,cu=0,mis=1,r=0,dep=1,og=4,tim=1333091153132147=====================PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153132819 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTEXEC #4:c=0,e=44,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153132813FETCH #4:c=0,e=112,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153133014STAT #4 id=1 cnt=13 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=41 pr=0 pw=0 time=1725 us)'STAT #4 id=2 cnt=13 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=28 pr=0 pw=0 time=1141 us)'=====================PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153133218 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTEXEC #3:c=1000,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153133212FETCH #3:c=0,e=65,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153133339STAT #3 id=1 cnt=14 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=44 pr=0 pw=0 time=1790 us)'STAT #3 id=2 cnt=14 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=30 pr=0 pw=0 time=1161 us)'=====================PARSING IN CURSOR #4 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333091153133507 hv=3150898423 ad='30e94228'select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucketEND OF STMTEXEC #4:c=0,e=45,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153133502FETCH #4:c=0,e=128,p=0,cr=3,cu=0,mis=0,r=17,dep=2,og=3,tim=1333091153133688STAT #4 id=1 cnt=18 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=6 pr=1 pw=0 time=501 us)'STAT #4 id=2 cnt=18 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=6 pr=1 pw=0 time=369 us)'STAT #4 id=3 cnt=2 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=4 pr=0 pw=0 time=79 us)'=====================PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153133935 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTEXEC #3:c=0,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153133929FETCH #3:c=0,e=41,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153134032STAT #3 id=1 cnt=15 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=47 pr=0 pw=0 time=1833 us)'STAT #3 id=2 cnt=15 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=32 pr=0 pw=0 time=1180 us)'=====================PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153134275 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTEXEC #4:c=1000,e=36,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153134268FETCH #4:c=0,e=44,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153134402STAT #4 id=1 cnt=16 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=50 pr=0 pw=0 time=1877 us)'STAT #4 id=2 cnt=16 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=34 pr=0 pw=0 time=1199 us)'EXEC #1:c=2999,e=2933,p=0,cr=15,cu=0,mis=1,r=0,dep=1,og=4,tim=1333091153135211FETCH #1:c=0,e=196,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,tim=1333091153135454STAT #1 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT GROUP BY (cr=2 pr=0 pw=0 time=232 us)'STAT #1 id=2 cnt=0 pid=1 pos=1 obj=57 op='TABLE ACCESS BY INDEX ROWID OBJAUTH$ (cr=2 pr=0 pw=0 time=190 us)'STAT #1 id=3 cnt=0 pid=2 pos=1 obj=103 op='INDEX RANGE SCAN I_OBJAUTH1 (cr=2 pr=0 pw=0 time=175 us)'=====================PARSING IN CURSOR #3 len=151 dep=1 uid=0 oct=3 lid=0 tim=1333091153136041 hv=4139184264 ad='30f1d620'select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2))from objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by grantee#END OF STMTPARSE #3:c=0,e=426,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333091153136035EXEC #3:c=1000,e=1203,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333091153137358FETCH #3:c=0,e=51,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,tim=1333091153137461STAT #3 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT GROUP BY (cr=2 pr=0 pw=0 time=75 us)'STAT #3 id=2 cnt=0 pid=1 pos=1 obj=57 op='TABLE ACCESS BY INDEX ROWID OBJAUTH$ (cr=2 pr=0 pw=0 time=47 us)'STAT #3 id=3 cnt=0 pid=2 pos=1 obj=103 op='INDEX RANGE SCAN I_OBJAUTH1 (cr=2 pr=0 pw=0 time=33 us)'=====================PARSING IN CURSOR #4 len=69 dep=1 uid=0 oct=3 lid=0 tim=1333091153138013 hv=1471956217 ad='30f1ea58'select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1END OF STMTPARSE #4:c=0,e=411,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333091153138007EXEC #4:c=1000,e=1034,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333091153139161FETCH #4:c=0,e=40,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=1333091153139373STAT #4 id=1 cnt=0 pid=0 pos=1 obj=31 op='TABLE ACCESS BY INDEX ROWID CDEF$ (cr=1 pr=0 pw=0 time=50 us)'STAT #4 id=2 cnt=0 pid=1 pos=1 obj=52 op='INDEX RANGE SCAN I_CDEF3 (cr=1 pr=0 pw=0 time=36 us)'=====================PARSING IN CURSOR #1 len=146 dep=1 uid=0 oct=3 lid=0 tim=1333091153140006 hv=2107929772 ad='30f204f4'select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0),rowid,cols,nvl(defer,0),mtime,nvl(spare1,0) from cdef$ where obj#=:1END OF STMTPARSE #1:c=1000,e=514,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333091153140000=====================PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153140739 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTEXEC #3:c=0,e=68,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153140732FETCH #3:c=0,e=71,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153140872STAT #3 id=1 cnt=17 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=53 pr=0 pw=0 time=1945 us)'STAT #3 id=2 cnt=17 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=36 pr=0 pw=0 time=1226 us)'=====================PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153141090 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTEXEC #4:c=1000,e=36,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153141084FETCH #4:c=0,e=89,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153141235STAT #4 id=1 cnt=18 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=56 pr=0 pw=0 time=2035 us)'STAT #4 id=2 cnt=18 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=38 pr=0 pw=0 time=1290 us)'=====================PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153141409 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTEXEC #3:c=0,e=36,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153141403FETCH #3:c=0,e=40,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153141502STAT #3 id=1 cnt=19 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=59 pr=0 pw=0 time=2077 us)'STAT #3 id=2 cnt=19 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=40 pr=0 pw=0 time=1308 us)'=====================PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153141734 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTEXEC #4:c=0,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153141728FETCH #4:c=0,e=40,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153141830STAT #4 id=1 cnt=20 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=62 pr=0 pw=0 time=2119 us)'STAT #4 id=2 cnt=20 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=42 pr=0 pw=0 time=1327 us)'=====================PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153142008 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTEXEC #3:c=999,e=34,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153142002FETCH #3:c=0,e=39,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153142102STAT #3 id=1 cnt=21 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=65 pr=0 pw=0 time=2158 us)'STAT #3 id=2 cnt=21 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=44 pr=0 pw=0 time=1345 us)'EXEC #1:c=1999,e=2637,p=0,cr=15,cu=0,mis=1,r=0,dep=1,og=4,tim=1333091153142749FETCH #1:c=0,e=54,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1333091153142849=====================PARSING IN CURSOR #4 len=70 dep=1 uid=0 oct=3 lid=0 tim=1333091153143357 hv=3849548163 ad='30f1e568'select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1END OF STMTPARSE #4:c=1000,e=448,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333091153143351=====================PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153144027 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTEXEC #3:c=1000,e=55,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153144021FETCH #3:c=0,e=109,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153144283STAT #3 id=1 cnt=22 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=68 pr=0 pw=0 time=2268 us)'STAT #3 id=2 cnt=22 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=46 pr=0 pw=0 time=1372 us)'=====================PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153144526 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTEXEC #3:c=0,e=39,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153144520FETCH #3:c=0,e=43,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153144683STAT #3 id=1 cnt=23 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=71 pr=0 pw=0 time=2312 us)'STAT #3 id=2 cnt=23 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=48 pr=0 pw=0 time=1393 us)'=====================PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333091153144882 hv=864012087 ad='30e966e8'select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2END OF STMTEXEC #3:c=0,e=35,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333091153144853FETCH #3:c=0,e=39,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333091153144977STAT #3 id=1 cnt=24 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=74 pr=0 pw=0 time=2352 us)'STAT #3 id=2 cnt=24 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=50 pr=0 pw=0 time=1411 us)'EXEC #4:c=2000,e=1997,p=0,cr=9,cu=0,mis=1,r=0,dep=1,og=4,tim=1333091153145453FETCH #4:c=1000,e=18392,p=2,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1333091153163887FETCH #4:c=0,e=18,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=1333091153163986STAT #4 id=1 cnt=1 pid=0 pos=1 obj=32 op='TABLE ACCESS BY INDEX ROWID CCOL$ (cr=4 pr=2 pw=0 time=18387 us)'STAT #4 id=2 cnt=1 pid=1 pos=1 obj=54 op='INDEX RANGE SCAN I_CCOL1 (cr=3 pr=2 pw=0 time=18366 us)'FETCH #1:c=0,e=35,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1333091153164509=====================PARSING IN CURSOR #3 len=70 dep=1 uid=0 oct=3 lid=0 tim=1333091153164759 hv=3849548163 ad='30f1e568'select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1END OF STMTEXEC #3:c=0,e=126,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1333091153164751FETCH #3:c=0,e=47,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1333091153164934FETCH #3:c=0,e=14,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=1333091153164983FETCH #1:c=0,e=32,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=1333091153165065STAT #1 id=1 cnt=2 pid=0 pos=1 obj=31 op='TABLE ACCESS BY INDEX ROWID CDEF$ (cr=6 pr=0 pw=0 time=53 us)'STAT #1 id=2 cnt=2 pid=1 pos=1 obj=51 op='INDEX RANGE SCAN I_CDEF2 (cr=4 pr=0 pw=0 time=40 us)'=====================PARSING IN CURSOR #2 len=24 dep=0 uid=0 oct=3 lid=0 tim=1333091153166475 hv=435537109 ad='30f3b458'select * from scott.emp END OF STMTPARSE #2:c=58991,e=75116,p=4,cr=117,cu=0,mis=1,r=0,dep=0,og=1,tim=1333091153166466EXEC #2:c=0,e=42,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=1333091153166754FETCH #2:c=999,e=947,p=6,cr=7,cu=0,mis=0,r=1,dep=0,og=1,tim=1333091153167769FETCH #2:c=0,e=49,p=0,cr=1,cu=0,mis=0,r=13,dep=0,og=1,tim=1333091153168670STAT #2 id=1 cnt=14 pid=0 pos=1 obj=51148 op='TABLE ACCESS FULL EMP (cr=8 pr=6 pw=0 time=933 us)'*** 2013-04-04 22:22:45.861=====================PARSE ERROR #4:len=37 dep=0 uid=0 oct=42 lid=0 tim=1333091177598788 err=911alter session set sql_trace=false *** 2013-04-04 22:23:14.012=====================PARSING IN CURSOR #3 len=34 dep=0 uid=0 oct=42 lid=0 tim=1333091205089913 hv=3317026814 ad='2afbcc64' alter session set sql_trace=falseEND OF STMTPARSE #3:c=1000,e=1359,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=1333091205089897EXEC #3:c=0,e=741,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=1333091205090949[oracle@sunblaze ~]$
文件
位置
所在
语句
跟踪
方法
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
拍照软件开发清单
太空杀无法连接服务器
先进软件开发技术与工具
联通交话费未通过网络安全
密码学与网络安全题目
geo数据库数据如何分析
天津华为服务器虚拟化费用
电子商务网络安全事件七大类
浙江互联网络技术客户至上
皮卡丘服务器怎么下载
数据库商家实体有哪些属性
微信聊天记录会在服务器保留多久
国内顶级网络安全社区
重庆二手服务器
开展网络安全教育的背景
一加游戏怎么显示oppo服务器
催服务器端口
数据库窗口函数是什么
网络安全圈外企
趋势传媒网络安全
智能翻译系统都有哪些数据库
下列属于数据库管理系统软件的有
数据库应用资源
win10 ftp服务器教程
Svn怎么彻底返服务器版本
软件开发v模型测试阶段
c的控件可以从数据库下载吗
服务器被攻击 访问慢
如何购买mc服务器
校园网络安全问题填空题
