[转帖]获得执行计划方法四-使用10046事件_MySQL, Oracle及数据库讨论区_Weblogic技术|Tuxedo技术|中间件技术|Oracle论坛|JAVA论坛|Linux/Unix技术|hadoop论坛

总帖数

每页帖数

1/1页

返回列表

发起投票

查看: 1918 | 回复: 0

主题： [转帖]获得执行计划方法四-使用10046事件

Alimaliz

注册用户

等级：新兵
经验：72
发帖：1
精华：0
注册：2018-10-9
状态：离线
发送短消息息给Alimaliz

加好友发送短消息息给Alimaliz

发消息

发表于：

2019-9-17 16:57:16 | [全部帖] [楼主帖]

楼主

我们也可以通过设置10046事件来进行SQL跟踪，并且可以设置不同的跟踪级别，比使用SQL_TRACE获得更多的信息。

10046事件不但可以跟踪用户会话(trace文件位于USER_DUMP_DEST )，也可以跟踪background进程(trace文件位于BACKGROUND_DUMP_DEST )。trace文件的大小决定于4个因素：跟踪级别，跟踪时长，会话的活动级别和MAX_DUMP_FILE_SIZE参数。

启用跟踪事件10046

1.在全局设置

修改初始化参数

EVENT = "10046 trace name context forever, level 8"

2.在当前session设置

alter session set events '10046 trace name context forever, level 8';
alter session set events '10046 trace name context off';
3   dbms_system.set_ev
exec dbms_system.set_ev( 666,888, 10046, 8, '');
exec dbms_system.set_ev( 666,888 , 10046, 0, '');
PROCEDURE SET_EV
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
SI                             BINARY_INTEGER           IN
SE                             BINARY_INTEGER          IN
EV                             BINARY_INTEGER          IN
LE                             BINARY_INTEGER          IN
NM                            VARCHAR2                    IN

其中level 为：

Level 0   停用SQL跟踪，相当于SQL_TRACE=FALSE

Level 1   标准SQL跟踪，相当于SQL_TRACE=TRUE

Level 4   在level 1的基础上增加绑定变量的信息

Level 8   在level 1的基础上增加等待事件的信息

Level 12 在level 1的基础上增加绑定变量和等待事件的信息

SQL> alter session set events '10046 trace name context forever, level 8';
Session altered.
SQL> select count(*) from scott.emp;
COUNT(*)
----------
14
SQL> alter session set events '10046 trace name context off';
Session altered.
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_3858.trc
[oracle@sunblaze ~]$ cat /u01/oracle/admin/orcl/udump/orcl_ora_3858.trc
/u01/oracle/admin/orcl/udump/orcl_ora_3858.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u01/oracle/product/OraHome
System name:    Linux
Node name:      sunblaze.com
Release:        2.6.9-42.ELsmp
Version:        #1 SMP Wed Jul 12 23:27:17 EDT 2006
Machine:        i686
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 18
Unix process pid: 3858, image: oracle@sunblaze.com (TNS V1-V3)
*** 2013-04-05 16:08:33.022
*** SERVICE NAME:(SYS$USERS) 2013-04-05 16:08:33.021
*** SESSION ID:(149.1) 2013-04-05 16:08:33.021
=====================
PARSING IN CURSOR #1 len=68 dep=0 uid=0 oct=42 lid=0 tim=1333153625997662 hv=740818757 ad='30d77bc8'
alter session set events '10046 trace name context forever, level 8'
END OF STMT
EXEC #1:c=0,e=332,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=1333153625997642
WAIT #1: nam='SQL*Net message to client' ela= 7 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1333153625998424
WAIT #1: nam='SQL*Net message from client' ela= 851 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1333153625999436
WAIT #0: nam='SQL*Net message to client' ela= 5 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1333153626000038
*** 2013-04-05 16:08:55.143
WAIT #0: nam='SQL*Net message from client' ela= 21600691 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1333153647600805
=====================
PARSING IN CURSOR #1 len=43 dep=1 uid=0 oct=3 lid=0 tim=1333153647605489 hv=1682066536 ad='30f23a80'
select user#,type# from user$ where name=:1
END OF STMT
PARSE #1:c=3999,e=3217,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647605474
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647611607 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
PARSE #3:c=3999,e=3868,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=3,tim=1333153647611595
EXEC #3:c=4000,e=12663,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=3,tim=1333153647624587
FETCH #3:c=1000,e=214,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647624941
STAT #3 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=211 us)'
STAT #3 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=140 us)'
EXEC #1:c=11999,e=20401,p=0,cr=3,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647626230
FETCH #1:c=0,e=152,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1333153647626469
STAT #1 id=1 cnt=1 pid=0 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=157 us)'
STAT #1 id=2 cnt=1 pid=1 pos=1 obj=44 op='INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=53 us)'
=====================
PARSING IN CURSOR #3 len=198 dep=1 uid=0 oct=3 lid=0 tim=1333153647628125 hv=4125641360 ad='30f2ba64'
select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 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
PARSE #3:c=1999,e=1385,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647628112
=====================
PARSING IN CURSOR #1 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647638699 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
PARSE #1:c=2000,e=1293,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=3,tim=1333153647638684
EXEC #1:c=2999,e=3263,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=3,tim=1333153647642202
WAIT #1: nam='db file sequential read' ela= 13548 file#=1 block#=1887 blocks=1 obj#=-1 tim=1333153647655964
FETCH #1:c=1999,e=14068,p=1,cr=3,cu=0,mis=0,r=14,dep=2,og=3,tim=1333153647656344
STAT #1 id=1 cnt=14 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=3 pr=1 pw=0 time=14111 us)'
STAT #1 id=2 cnt=14 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=3 pr=1 pw=0 time=14167 us)'
STAT #1 id=3 cnt=1 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=2 pr=0 pw=0 time=49 us)'
=====================
PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647657057 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #1:c=0,e=65,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647657027
FETCH #1:c=0,e=78,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647657204
STAT #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=290 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=178 us)'
=====================
PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647657591 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #1:c=0,e=42,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647657584
FETCH #1:c=0,e=72,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647657724
STAT #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=362 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=201 us)'
=====================
PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647657928 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #1:c=0,e=40,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647657922
FETCH #1:c=1000,e=69,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647658056
STAT #1 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=432 us)'
STAT #1 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=245 us)'
=====================
PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647658280 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #1:c=0,e=41,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647658273
FETCH #1:c=0,e=46,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647658386
STAT #1 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=482 us)'
STAT #1 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=267 us)'
=====================
PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647658791 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #1:c=0,e=41,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647658784
FETCH #1:c=0,e=46,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647658897
STAT #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=529 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=290 us)'
=====================
PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647659102 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #1:c=1000,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647659095
FETCH #1:c=0,e=48,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647659339
STAT #1 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=577 us)'
STAT #1 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=312 us)'
EXEC #3:c=12998,e=31598,p=1,cr=21,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647660160
FETCH #3:c=0,e=227,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1333153647660442
STAT #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=246 us)'
STAT #3 id=2 cnt=1 pid=1 pos=1 obj=37 op='INDEX RANGE SCAN I_OBJ2 (cr=2 pr=0 pw=0 time=41 us)'
=====================
PARSING IN CURSOR #1 len=493 dep=1 uid=0 oct=3 lid=0 tim=1333153647661550 hv=2584065658 ad='30f1a234'
select t.ts#,t.file#,t.block#,nvl(t.bobj#,0),nvl(t.tab#,0),t.intcols,nvl(t.clucols,0),t.audit$,t.flags,t.pctfree$,t.pctused$,t.initrans,t.maxtrans,t.rowcnt,t.blkcnt,t.empcnt,t.avgspc,t.chncnt,t.avgrln,t.analyzetime,t.samplesize,t.cols,t.property,nvl(t.degree,1),nvl(t.instances,1),t.avgspc_flb,t.flbcnt,t.kernelcols,nvl(t.trigflag, 0),nvl(t.spare1,0),nvl(t.spare2,0),t.spare4,t.spare6,ts.cachedblk,ts.cachehit,ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
END OF STMT
PARSE #1:c=1000,e=951,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647661543
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647662793 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=106,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647662785
FETCH #3:c=999,e=359,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647663227
STAT #3 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=817 us)'
STAT #3 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=441 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647663683 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=47,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647663675
FETCH #3:c=0,e=51,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647663797
STAT #3 id=1 cnt=9 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=27 pr=0 pw=0 time=868 us)'
STAT #3 id=2 cnt=9 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=18 pr=0 pw=0 time=466 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647664026 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=1000,e=39,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647664019
FETCH #3:c=0,e=48,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647664166
STAT #3 id=1 cnt=10 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=30 pr=0 pw=0 time=916 us)'
STAT #3 id=2 cnt=10 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=20 pr=0 pw=0 time=488 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647664352 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=38,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647664346
FETCH #3:c=0,e=44,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647664457
STAT #3 id=1 cnt=11 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=33 pr=0 pw=0 time=962 us)'
STAT #3 id=2 cnt=11 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=22 pr=0 pw=0 time=507 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647664732 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=39,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647664725
FETCH #3:c=1000,e=73,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647664864
STAT #3 id=1 cnt=12 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=36 pr=0 pw=0 time=1008 us)'
STAT #3 id=2 cnt=12 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=24 pr=0 pw=0 time=529 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647665201 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=173,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647665193
FETCH #3:c=0,e=47,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647665312
STAT #3 id=1 cnt=13 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=39 pr=0 pw=0 time=1054 us)'
STAT #3 id=2 cnt=13 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=26 pr=0 pw=0 time=552 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647665591 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=41,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647665584
FETCH #3:c=0,e=45,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647665697
STAT #3 id=1 cnt=14 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=42 pr=0 pw=0 time=1100 us)'
STAT #3 id=2 cnt=14 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=28 pr=0 pw=0 time=572 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647666074 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=1000,e=194,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647666064
FETCH #3:c=0,e=56,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647666212
STAT #3 id=1 cnt=15 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=45 pr=0 pw=0 time=1300 us)'
STAT #3 id=2 cnt=15 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=30 pr=0 pw=0 time=598 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647666429 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=45,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647666422
FETCH #3:c=0,e=50,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647666572
STAT #3 id=1 cnt=16 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=48 pr=0 pw=0 time=1350 us)'
STAT #3 id=2 cnt=16 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=32 pr=0 pw=0 time=621 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647666770 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=41,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647666763
FETCH #3:c=1000,e=46,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647666898
STAT #3 id=1 cnt=17 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=51 pr=0 pw=0 time=1397 us)'
STAT #3 id=2 cnt=17 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=34 pr=0 pw=0 time=641 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647667268 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=43,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647667261
FETCH #3:c=0,e=47,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647667375
STAT #3 id=1 cnt=18 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=54 pr=0 pw=0 time=1445 us)'
STAT #3 id=2 cnt=18 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=36 pr=0 pw=0 time=663 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647667599 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=40,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647667592
FETCH #3:c=0,e=46,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647667704
STAT #3 id=1 cnt=19 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=57 pr=0 pw=0 time=1490 us)'
STAT #3 id=2 cnt=19 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=38 pr=0 pw=0 time=682 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647667910 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=1000,e=38,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647667903
FETCH #3:c=0,e=47,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647668072
STAT #3 id=1 cnt=20 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=60 pr=0 pw=0 time=1537 us)'
STAT #3 id=2 cnt=20 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=40 pr=0 pw=0 time=702 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647668319 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=40,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647668312
FETCH #3:c=0,e=77,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647668456
STAT #3 id=1 cnt=21 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=63 pr=0 pw=0 time=1615 us)'
STAT #3 id=2 cnt=21 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=42 pr=0 pw=0 time=724 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647668638 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=26,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647668634
FETCH #3:c=0,e=31,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647668708
STAT #3 id=1 cnt=22 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=66 pr=0 pw=0 time=1647 us)'
STAT #3 id=2 cnt=22 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=44 pr=0 pw=0 time=738 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647668843 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=1000,e=25,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647668839
FETCH #3:c=0,e=32,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647668972
STAT #3 id=1 cnt=23 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=69 pr=0 pw=0 time=1677 us)'
STAT #3 id=2 cnt=23 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=46 pr=0 pw=0 time=752 us)'
=====================
PARSING IN CURSOR #3 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647669188 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #3:c=0,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647669184
WAIT #3: nam='db file sequential read' ela= 1099 file#=1 block#=1951 blocks=1 obj#=-1 tim=1333153647670375
FETCH #3:c=0,e=1333,p=1,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647670563
STAT #3 id=1 cnt=34 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=6 pr=2 pw=0 time=15513 us)'
STAT #3 id=2 cnt=34 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=6 pr=2 pw=0 time=15470 us)'
STAT #3 id=3 cnt=2 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=4 pr=0 pw=0 time=69 us)'
=====================
PARSING IN CURSOR #3 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647670743 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #3:c=999,e=63,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647670738
FETCH #3:c=0,e=84,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647670869
STAT #3 id=1 cnt=54 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=9 pr=2 pw=0 time=15671 us)'
STAT #3 id=2 cnt=54 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=9 pr=2 pw=0 time=15580 us)'
STAT #3 id=3 cnt=3 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=6 pr=0 pw=0 time=87 us)'
=====================
PARSING IN CURSOR #3 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647671121 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #3:c=0,e=34,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647671116
FETCH #3:c=0,e=83,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647671244
STAT #3 id=1 cnt=74 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=12 pr=2 pw=0 time=15802 us)'
STAT #3 id=2 cnt=74 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=12 pr=2 pw=0 time=15673 us)'
STAT #3 id=3 cnt=4 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=8 pr=0 pw=0 time=104 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647671406 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647671401
FETCH #3:c=0,e=33,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647671483
STAT #3 id=1 cnt=24 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=72 pr=0 pw=0 time=1729 us)'
STAT #3 id=2 cnt=24 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=48 pr=0 pw=0 time=785 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647671618 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=27,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647671614
FETCH #3:c=1000,e=103,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647671762
STAT #3 id=1 cnt=25 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=75 pr=0 pw=0 time=1816 us)'
STAT #3 id=2 cnt=25 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=50 pr=0 pw=0 time=797 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647672077 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=29,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647672071
FETCH #3:c=0,e=32,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647672151
STAT #3 id=1 cnt=26 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=78 pr=0 pw=0 time=1849 us)'
STAT #3 id=2 cnt=26 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=52 pr=0 pw=0 time=811 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647672275 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=25,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647672270
FETCH #3:c=0,e=29,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647672343
STAT #3 id=1 cnt=27 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=81 pr=0 pw=0 time=1879 us)'
STAT #3 id=2 cnt=27 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=54 pr=0 pw=0 time=825 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647672557 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=26,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647672553
FETCH #3:c=0,e=31,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647672629
STAT #3 id=1 cnt=28 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=84 pr=0 pw=0 time=1910 us)'
STAT #3 id=2 cnt=28 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=56 pr=0 pw=0 time=840 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647672768 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=1000,e=25,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647672764
FETCH #3:c=0,e=75,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647672883
STAT #3 id=1 cnt=29 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=87 pr=0 pw=0 time=1941 us)'
STAT #3 id=2 cnt=29 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=58 pr=0 pw=0 time=853 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647673043 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=29,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647673039
FETCH #3:c=0,e=33,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647673117
STAT #3 id=1 cnt=30 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=90 pr=0 pw=0 time=1976 us)'
STAT #3 id=2 cnt=30 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=60 pr=0 pw=0 time=869 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647673394 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=28,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647673389
FETCH #3:c=0,e=33,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647673469
STAT #3 id=1 cnt=31 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=93 pr=0 pw=0 time=2009 us)'
STAT #3 id=2 cnt=31 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=62 pr=0 pw=0 time=886 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647673682 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=1000,e=27,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647673678
FETCH #3:c=0,e=30,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647673754
STAT #3 id=1 cnt=32 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=96 pr=0 pw=0 time=2039 us)'
STAT #3 id=2 cnt=32 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=64 pr=0 pw=0 time=901 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647673939 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=27,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647673934
FETCH #3:c=0,e=31,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647674011
STAT #3 id=1 cnt=33 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=99 pr=0 pw=0 time=2071 us)'
STAT #3 id=2 cnt=33 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=66 pr=0 pw=0 time=916 us)'
EXEC #1:c=12998,e=13332,p=1,cr=87,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647675140
FETCH #1:c=0,e=150,p=0,cr=4,cu=0,mis=0,r=1,dep=1,og=4,tim=1333153647675328
STAT #1 id=1 cnt=1 pid=0 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=4 pr=0 pw=0 time=146 us)'
STAT #1 id=2 cnt=1 pid=1 pos=1 obj=4 op='TABLE ACCESS CLUSTER TAB$ (cr=3 pr=0 pw=0 time=102 us)'
STAT #1 id=3 cnt=1 pid=2 pos=1 obj=3 op='INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=34 us)'
STAT #1 id=4 cnt=0 pid=1 pos=2 obj=708 op='TABLE ACCESS BY INDEX ROWID TAB_STATS$ (cr=1 pr=0 pw=0 time=27 us)'
STAT #1 id=5 cnt=0 pid=4 pos=1 obj=709 op='INDEX UNIQUE SCAN I_TAB_STATS$_OBJ# (cr=1 pr=0 pw=0 time=16 us)'
=====================
PARSING IN CURSOR #3 len=789 dep=1 uid=0 oct=3 lid=0 tim=1333153647676410 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 STMT
PARSE #3:c=1000,e=873,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647676405
=====================
PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647677724 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #1:c=999,e=99,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647677718
FETCH #1:c=0,e=60,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647677852
STAT #1 id=1 cnt=34 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=102 pr=0 pw=0 time=2132 us)'
STAT #1 id=2 cnt=34 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=68 pr=0 pw=0 time=945 us)'
=====================
PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647678612 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #1:c=1000,e=31,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647678606
FETCH #1:c=0,e=52,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647678709
STAT #1 id=1 cnt=35 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=105 pr=0 pw=0 time=2183 us)'
STAT #1 id=2 cnt=35 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=70 pr=0 pw=0 time=962 us)'
=====================
PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647678852 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #1:c=0,e=28,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647678848
FETCH #1:c=0,e=31,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647678925
STAT #1 id=1 cnt=36 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=108 pr=0 pw=0 time=2216 us)'
STAT #1 id=2 cnt=36 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=72 pr=0 pw=0 time=977 us)'
=====================
PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647679051 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #1:c=0,e=26,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647679046
FETCH #1:c=0,e=32,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647679123
STAT #1 id=1 cnt=37 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=111 pr=0 pw=0 time=2248 us)'
STAT #1 id=2 cnt=37 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=74 pr=0 pw=0 time=990 us)'
EXEC #3:c=4999,e=4938,p=0,cr=12,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647681522
WAIT #3: nam='db file sequential read' ela= 4418 file#=1 block#=52424 blocks=1 obj#=-1 tim=1333153647688352
WAIT #3: nam='db file sequential read' ela= 12560 file#=1 block#=59545 blocks=1 obj#=-1 tim=1333153647701025
FETCH #3:c=3999,e=19983,p=2,cr=8,cu=0,mis=0,r=1,dep=1,og=4,tim=1333153647701551
=====================
PARSING IN CURSOR #1 len=67 dep=1 uid=0 oct=3 lid=0 tim=1333153647702075 hv=2280069326 ad='30f2a8c4'
select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1
END OF STMT
PARSE #1:c=1000,e=440,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647702070
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647702766 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=0,e=107,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647702760
FETCH #4:c=0,e=58,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647702877
STAT #4 id=1 cnt=38 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=114 pr=0 pw=0 time=2307 us)'
STAT #4 id=2 cnt=38 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=76 pr=0 pw=0 time=1016 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647703121 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=1000,e=43,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647703114
FETCH #4:c=0,e=44,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647703210
STAT #4 id=1 cnt=39 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=117 pr=0 pw=0 time=2350 us)'
STAT #4 id=2 cnt=39 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=78 pr=0 pw=0 time=1033 us)'
=====================
PARSING IN CURSOR #4 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647703424 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #4:c=0,e=40,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647703419
WAIT #4: nam='db file sequential read' ela= 13467 file#=1 block#=1847 blocks=1 obj#=-1 tim=1333153647716979
FETCH #4:c=0,e=13657,p=1,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647717125
STAT #4 id=1 cnt=75 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=15 pr=3 pw=0 time=29468 us)'
STAT #4 id=2 cnt=75 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=15 pr=3 pw=0 time=29261 us)'
STAT #4 id=3 cnt=5 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=10 pr=0 pw=0 time=126 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647717389 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647717384
FETCH #4:c=0,e=46,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647717480
STAT #4 id=1 cnt=40 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=120 pr=0 pw=0 time=2396 us)'
STAT #4 id=2 cnt=40 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=80 pr=0 pw=0 time=1059 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647717632 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=1000,e=27,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647717628
FETCH #4:c=0,e=33,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647717708
STAT #4 id=1 cnt=41 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=123 pr=0 pw=0 time=2428 us)'
STAT #4 id=2 cnt=41 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=82 pr=0 pw=0 time=1073 us)'
=====================
PARSING IN CURSOR #4 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647717949 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #4:c=0,e=35,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647717945
WAIT #4: nam='db file sequential read' ela= 607 file#=1 block#=1845 blocks=1 obj#=-1 tim=1333153647718638
FETCH #4:c=1000,e=801,p=1,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647718791
STAT #4 id=1 cnt=95 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=18 pr=4 pw=0 time=30337 us)'
STAT #4 id=2 cnt=95 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=18 pr=4 pw=0 time=30028 us)'
STAT #4 id=3 cnt=6 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=12 pr=0 pw=0 time=146 us)'
=====================
PARSING IN CURSOR #4 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647719034 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #4:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647719029
FETCH #4:c=0,e=140,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647719218
STAT #4 id=1 cnt=115 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=21 pr=4 pw=0 time=30546 us)'
STAT #4 id=2 cnt=115 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=21 pr=4 pw=0 time=30144 us)'
STAT #4 id=3 cnt=7 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=14 pr=0 pw=0 time=167 us)'
=====================
PARSING IN CURSOR #4 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647719358 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #4:c=0,e=34,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647719354
FETCH #4:c=999,e=244,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647719695
STAT #4 id=1 cnt=135 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=24 pr=4 pw=0 time=30813 us)'
STAT #4 id=2 cnt=135 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=24 pr=4 pw=0 time=30255 us)'
STAT #4 id=3 cnt=8 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=16 pr=0 pw=0 time=271 us)'
=====================
PARSING IN CURSOR #4 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647719894 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #4:c=0,e=36,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647719889
FETCH #4:c=0,e=111,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647720047
STAT #4 id=1 cnt=155 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=27 pr=4 pw=0 time=30993 us)'
STAT #4 id=2 cnt=155 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=27 pr=4 pw=0 time=30369 us)'
STAT #4 id=3 cnt=9 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=18 pr=0 pw=0 time=287 us)'
=====================
PARSING IN CURSOR #4 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647720237 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #4:c=0,e=93,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647720231
FETCH #4:c=0,e=113,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647720398
STAT #4 id=1 cnt=175 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=30 pr=4 pw=0 time=31213 us)'
STAT #4 id=2 cnt=175 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=30 pr=4 pw=0 time=30493 us)'
STAT #4 id=3 cnt=10 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=20 pr=0 pw=0 time=305 us)'
=====================
PARSING IN CURSOR #4 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647720592 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #4:c=0,e=35,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647720587
FETCH #4:c=0,e=129,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647720763
STAT #4 id=1 cnt=195 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=33 pr=4 pw=0 time=31391 us)'
STAT #4 id=2 cnt=195 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=33 pr=4 pw=0 time=30611 us)'
STAT #4 id=3 cnt=11 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=22 pr=0 pw=0 time=320 us)'
=====================
PARSING IN CURSOR #4 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647720897 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #4:c=0,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647720893
FETCH #4:c=0,e=106,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647721044
STAT #4 id=1 cnt=215 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=36 pr=4 pw=0 time=31566 us)'
STAT #4 id=2 cnt=215 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=36 pr=4 pw=0 time=30714 us)'
STAT #4 id=3 cnt=12 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=24 pr=0 pw=0 time=335 us)'
=====================
PARSING IN CURSOR #4 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647721185 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #4:c=0,e=47,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647721180
FETCH #4:c=0,e=107,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647721335
STAT #4 id=1 cnt=235 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=39 pr=4 pw=0 time=31736 us)'
STAT #4 id=2 cnt=235 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=39 pr=4 pw=0 time=30833 us)'
STAT #4 id=3 cnt=13 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=26 pr=0 pw=0 time=350 us)'
=====================
PARSING IN CURSOR #4 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647721534 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #4:c=1000,e=32,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647721528
FETCH #4:c=0,e=232,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647721806
STAT #4 id=1 cnt=255 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=42 pr=4 pw=0 time=31944 us)'
STAT #4 id=2 cnt=255 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=42 pr=4 pw=0 time=30943 us)'
STAT #4 id=3 cnt=14 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=28 pr=0 pw=0 time=366 us)'
=====================
PARSING IN CURSOR #4 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647721943 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #4:c=0,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647721939
FETCH #4:c=0,e=109,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647722092
STAT #4 id=1 cnt=275 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=45 pr=4 pw=0 time=32123 us)'
STAT #4 id=2 cnt=275 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=45 pr=4 pw=0 time=31038 us)'
STAT #4 id=3 cnt=15 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=30 pr=0 pw=0 time=384 us)'
=====================
PARSING IN CURSOR #4 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647722236 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #4:c=0,e=32,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647722232
FETCH #4:c=0,e=106,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647722382
STAT #4 id=1 cnt=295 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=48 pr=4 pw=0 time=32279 us)'
STAT #4 id=2 cnt=295 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=48 pr=4 pw=0 time=31153 us)'
STAT #4 id=3 cnt=16 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=32 pr=0 pw=0 time=400 us)'
=====================
PARSING IN CURSOR #4 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647722520 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #4:c=1000,e=31,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647722515
FETCH #4:c=0,e=123,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647722683
STAT #4 id=1 cnt=315 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=51 pr=4 pw=0 time=32433 us)'
STAT #4 id=2 cnt=315 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=51 pr=4 pw=0 time=31270 us)'
STAT #4 id=3 cnt=17 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=34 pr=0 pw=0 time=415 us)'
=====================
PARSING IN CURSOR #4 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647722878 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #4:c=0,e=34,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647722874
FETCH #4:c=0,e=105,p=0,cr=3,cu=0,mis=0,r=11,dep=2,og=3,tim=1333153647723025
STAT #4 id=1 cnt=326 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=54 pr=4 pw=0 time=32561 us)'
STAT #4 id=2 cnt=326 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=54 pr=4 pw=0 time=31374 us)'
STAT #4 id=3 cnt=18 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=36 pr=0 pw=0 time=430 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647723192 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=0,e=30,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647723187
FETCH #4:c=0,e=39,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647723272
STAT #4 id=1 cnt=42 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=126 pr=0 pw=0 time=2467 us)'
STAT #4 id=2 cnt=42 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=84 pr=0 pw=0 time=1093 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647723492 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=1000,e=28,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647723488
FETCH #4:c=0,e=32,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647723565
STAT #4 id=1 cnt=43 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=129 pr=0 pw=0 time=2499 us)'
STAT #4 id=2 cnt=43 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=86 pr=0 pw=0 time=1108 us)'
=====================
PARSING IN CURSOR #4 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647723777 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #4:c=0,e=31,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647723772
WAIT #4: nam='db file sequential read' ela= 516 file#=1 block#=1846 blocks=1 obj#=-1 tim=1333153647724370
FETCH #4:c=1000,e=675,p=1,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647724493
STAT #4 id=1 cnt=346 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=57 pr=5 pw=0 time=33301 us)'
STAT #4 id=2 cnt=346 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=57 pr=5 pw=0 time=32066 us)'
STAT #4 id=3 cnt=19 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=38 pr=0 pw=0 time=444 us)'
=====================
PARSING IN CURSOR #4 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647724674 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #4:c=0,e=41,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647724669
FETCH #4:c=0,e=77,p=0,cr=3,cu=0,mis=0,r=11,dep=2,og=3,tim=1333153647724794
STAT #4 id=1 cnt=357 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=60 pr=5 pw=0 time=33402 us)'
STAT #4 id=2 cnt=357 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=60 pr=5 pw=0 time=32133 us)'
STAT #4 id=3 cnt=20 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=40 pr=0 pw=0 time=464 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647724939 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=0,e=27,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647724934
FETCH #4:c=0,e=35,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647725015
STAT #4 id=1 cnt=44 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=132 pr=0 pw=0 time=2536 us)'
STAT #4 id=2 cnt=44 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=88 pr=0 pw=0 time=1127 us)'
EXEC #1:c=9998,e=23256,p=3,cr=69,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647725481
WAIT #1: nam='db file sequential read' ela= 7422 file#=1 block#=56905 blocks=1 obj#=-1 tim=1333153647733002
FETCH #1:c=0,e=7580,p=1,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1333153647733095
FETCH #1:c=0,e=16,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=1333153647733157
STAT #1 id=1 cnt=1 pid=0 pos=1 obj=20 op='TABLE ACCESS BY INDEX ROWID ICOL$ (cr=4 pr=1 pw=0 time=7578 us)'
STAT #1 id=2 cnt=1 pid=1 pos=1 obj=40 op='INDEX RANGE SCAN I_ICOL1 (cr=3 pr=1 pw=0 time=7555 us)'
FETCH #3:c=0,e=14,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1333153647733291
STAT #3 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=8 pr=2 pw=0 time=20052 us)'
STAT #3 id=2 cnt=1 pid=1 pos=1 obj=0 op='HASH JOIN OUTER (cr=8 pr=2 pw=0 time=19935 us)'
STAT #3 id=3 cnt=1 pid=2 pos=1 obj=0 op='NESTED LOOPS OUTER (cr=5 pr=0 pw=0 time=107 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=62 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=25 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=26 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=15 us)'
STAT #3 id=8 cnt=1 pid=2 pos=2 obj=0 op='VIEW  (cr=3 pr=2 pw=0 time=17658 us)'
STAT #3 id=9 cnt=1 pid=8 pos=1 obj=0 op='SORT GROUP BY (cr=3 pr=2 pw=0 time=17643 us)'
STAT #3 id=10 cnt=1 pid=9 pos=1 obj=31 op='TABLE ACCESS BY INDEX ROWID CDEF$ (cr=3 pr=2 pw=0 time=17232 us)'
STAT #3 id=11 cnt=2 pid=10 pos=1 obj=51 op='INDEX RANGE SCAN I_CDEF2 (cr=2 pr=1 pw=0 time=4532 us)'
=====================
PARSING IN CURSOR #4 len=348 dep=1 uid=0 oct=3 lid=0 tim=1333153647734490 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 STMT
PARSE #4:c=1000,e=741,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647734484
=====================
PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647735596 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #1:c=0,e=51,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647735589
FETCH #1:c=0,e=63,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647735716
STAT #1 id=1 cnt=45 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=135 pr=0 pw=0 time=2600 us)'
STAT #1 id=2 cnt=45 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=90 pr=0 pw=0 time=1155 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647735930 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647735924
FETCH #3:c=0,e=37,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647736017
STAT #3 id=1 cnt=46 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=138 pr=0 pw=0 time=2636 us)'
STAT #3 id=2 cnt=46 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=92 pr=0 pw=0 time=1171 us)'
=====================
PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647736243 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #1:c=0,e=32,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647736237
FETCH #1:c=0,e=72,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647736363
STAT #1 id=1 cnt=47 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=141 pr=0 pw=0 time=2709 us)'
STAT #1 id=2 cnt=47 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=94 pr=0 pw=0 time=1222 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647736551 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=31,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647736546
FETCH #3:c=0,e=35,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647736635
STAT #3 id=1 cnt=48 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=144 pr=0 pw=0 time=2746 us)'
STAT #3 id=2 cnt=48 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=96 pr=0 pw=0 time=1238 us)'
EXEC #4:c=3000,e=2900,p=0,cr=12,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647737505
FETCH #4:c=0,e=103,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1333153647737652
FETCH #4:c=0,e=8,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=1333153647737699
FETCH #4:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=1333153647737734
FETCH #4:c=0,e=209,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=1333153647737969
FETCH #4:c=0,e=8,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=1333153647738016
FETCH #4:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=1333153647738050
FETCH #4:c=0,e=8,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=1333153647738113
FETCH #4:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=1,dep=1,og=4,tim=1333153647738147
FETCH #4:c=0,e=10,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1333153647738184
STAT #4 id=1 cnt=8 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=3 pr=0 pw=0 time=112 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=79 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=25 us)'
=====================
PARSING IN CURSOR #1 len=206 dep=1 uid=0 oct=3 lid=0 tim=1333153647738838 hv=2888850659 ad='30f176cc'
select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0),NVL(scanhint,0) from seg$ where ts#=:1 and file#=:2 and block#=:3
END OF STMT
PARSE #1:c=0,e=472,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647738833
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647739500 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=44,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647739494
FETCH #3:c=0,e=59,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647739613
STAT #3 id=1 cnt=49 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=147 pr=0 pw=0 time=2807 us)'
STAT #3 id=2 cnt=49 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=98 pr=0 pw=0 time=1263 us)'
=====================
PARSING IN CURSOR #4 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647739833 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #4:c=0,e=43,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647739828
WAIT #4: nam='db file sequential read' ela= 671 file#=1 block#=1919 blocks=1 obj#=-1 tim=1333153647740600
FETCH #4:c=1000,e=841,p=1,cr=3,cu=0,mis=0,r=5,dep=2,og=3,tim=1333153647740723
STAT #4 id=1 cnt=362 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=63 pr=6 pw=0 time=34234 us)'
STAT #4 id=2 cnt=362 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=63 pr=6 pw=0 time=32919 us)'
STAT #4 id=3 cnt=21 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=42 pr=0 pw=0 time=487 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647740940 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=40,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647740934
FETCH #3:c=1000,e=75,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647741063
STAT #3 id=1 cnt=50 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=150 pr=0 pw=0 time=2885 us)'
STAT #3 id=2 cnt=50 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=100 pr=0 pw=0 time=1286 us)'
=====================
PARSING IN CURSOR #4 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647741346 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #4:c=0,e=57,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647741221
WAIT #4: nam='db file sequential read' ela= 531 file#=1 block#=1918 blocks=1 obj#=-1 tim=1333153647742036
FETCH #4:c=999,e=663,p=1,cr=3,cu=0,mis=0,r=5,dep=2,og=3,tim=1333153647742124
STAT #4 id=1 cnt=367 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=66 pr=7 pw=0 time=34908 us)'
STAT #4 id=2 cnt=367 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=66 pr=7 pw=0 time=33546 us)'
STAT #4 id=3 cnt=22 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=44 pr=0 pw=0 time=508 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647742375 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647742369
FETCH #3:c=0,e=40,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647742463
STAT #3 id=1 cnt=51 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=153 pr=0 pw=0 time=2928 us)'
STAT #3 id=2 cnt=51 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=102 pr=0 pw=0 time=1307 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647742711 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=0,e=50,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647742706
FETCH #4:c=0,e=38,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647742802
STAT #4 id=1 cnt=52 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=156 pr=0 pw=0 time=2969 us)'
STAT #4 id=2 cnt=52 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=104 pr=0 pw=0 time=1326 us)'
=====================
PARSING IN CURSOR #3 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647742942 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #3:c=0,e=38,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647742937
WAIT #3: nam='db file sequential read' ela= 3860 file#=1 block#=2050 blocks=1 obj#=-1 tim=1333153647746904
FETCH #3:c=2000,e=3998,p=1,cr=3,cu=0,mis=0,r=5,dep=2,og=3,tim=1333153647747004
STAT #3 id=1 cnt=372 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=69 pr=8 pw=0 time=38918 us)'
STAT #3 id=2 cnt=372 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=69 pr=8 pw=0 time=37513 us)'
STAT #3 id=3 cnt=23 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=46 pr=0 pw=0 time=528 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647747312 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=0,e=39,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647747307
FETCH #4:c=0,e=43,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647747404
STAT #4 id=1 cnt=53 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=159 pr=0 pw=0 time=3012 us)'
STAT #4 id=2 cnt=53 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=106 pr=0 pw=0 time=1348 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647747572 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=50,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647747567
FETCH #3:c=0,e=37,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647747660
STAT #3 id=1 cnt=54 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=162 pr=0 pw=0 time=3070 us)'
STAT #3 id=2 cnt=54 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=108 pr=0 pw=0 time=1381 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647747879 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=1000,e=52,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647747875
FETCH #4:c=0,e=36,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647747963
STAT #4 id=1 cnt=55 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=165 pr=0 pw=0 time=3109 us)'
STAT #4 id=2 cnt=55 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=110 pr=0 pw=0 time=1398 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647748127 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=32,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647748123
FETCH #3:c=0,e=35,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647748210
STAT #3 id=1 cnt=56 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=168 pr=0 pw=0 time=3145 us)'
STAT #3 id=2 cnt=56 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=112 pr=0 pw=0 time=1416 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647748352 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=0,e=28,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647748347
FETCH #4:c=0,e=34,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647748432
STAT #4 id=1 cnt=57 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=171 pr=0 pw=0 time=3180 us)'
STAT #4 id=2 cnt=57 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=114 pr=0 pw=0 time=1433 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647748626 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=32,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647748621
FETCH #3:c=0,e=34,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647748708
STAT #3 id=1 cnt=58 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=174 pr=0 pw=0 time=3216 us)'
STAT #3 id=2 cnt=58 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=116 pr=0 pw=0 time=1450 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647748872 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=1000,e=30,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647748867
FETCH #4:c=0,e=35,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647748953
STAT #4 id=1 cnt=59 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=177 pr=0 pw=0 time=3253 us)'
STAT #4 id=2 cnt=59 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=118 pr=0 pw=0 time=1466 us)'
=====================
PARSING IN CURSOR #3 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647749189 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #3:c=0,e=39,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647749184
WAIT #3: nam='db file sequential read' ela= 576 file#=1 block#=2049 blocks=1 obj#=-1 tim=1333153647749933
FETCH #3:c=0,e=740,p=1,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647750054
STAT #3 id=1 cnt=392 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=72 pr=9 pw=0 time=39725 us)'
STAT #3 id=2 cnt=392 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=72 pr=9 pw=0 time=38249 us)'
STAT #3 id=3 cnt=24 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=48 pr=0 pw=0 time=549 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647750248 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=0,e=36,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647750243
FETCH #4:c=0,e=40,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647750334
STAT #4 id=1 cnt=60 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=180 pr=0 pw=0 time=3296 us)'
STAT #4 id=2 cnt=60 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=120 pr=0 pw=0 time=1486 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647750498 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=45,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647750491
FETCH #3:c=0,e=35,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647750583
STAT #3 id=1 cnt=61 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=183 pr=0 pw=0 time=3333 us)'
STAT #3 id=2 cnt=61 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=122 pr=0 pw=0 time=1502 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647750727 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=0,e=29,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647750722
FETCH #4:c=1000,e=34,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647750825
STAT #4 id=1 cnt=62 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=186 pr=0 pw=0 time=3368 us)'
STAT #4 id=2 cnt=62 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=124 pr=0 pw=0 time=1518 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647751097 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=149,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647751091
FETCH #3:c=0,e=36,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647751186
STAT #3 id=1 cnt=63 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=189 pr=0 pw=0 time=3523 us)'
STAT #3 id=2 cnt=63 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=126 pr=0 pw=0 time=1653 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647751375 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=0,e=32,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647751370
FETCH #4:c=0,e=52,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647751474
STAT #4 id=1 cnt=64 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=192 pr=0 pw=0 time=3561 us)'
STAT #4 id=2 cnt=64 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=128 pr=0 pw=0 time=1671 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647751671 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=30,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647751666
FETCH #3:c=1000,e=60,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647751778
STAT #3 id=1 cnt=65 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=195 pr=0 pw=0 time=3621 us)'
STAT #3 id=2 cnt=65 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=130 pr=0 pw=0 time=1688 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647751921 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=0,e=29,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647751916
FETCH #4:c=0,e=36,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647752026
STAT #4 id=1 cnt=66 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=198 pr=0 pw=0 time=3658 us)'
STAT #4 id=2 cnt=66 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=132 pr=0 pw=0 time=1705 us)'
EXEC #1:c=9999,e=13628,p=4,cr=66,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647752570
WAIT #1: nam='db file sequential read' ela= 627 file#=1 block#=59537 blocks=1 obj#=-1 tim=1333153647753279
WAIT #1: nam='db file sequential read' ela= 99 file#=1 block#=56919 blocks=1 obj#=-1 tim=1333153647753441
FETCH #1:c=999,e=884,p=2,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1333153647753492
STAT #1 id=1 cnt=1 pid=0 pos=1 obj=14 op='TABLE ACCESS CLUSTER SEG$ (cr=3 pr=2 pw=0 time=880 us)'
STAT #1 id=2 cnt=1 pid=1 pos=1 obj=9 op='INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=2 pr=1 pw=0 time=711 us)'
=====================
PARSING IN CURSOR #3 len=116 dep=1 uid=0 oct=3 lid=0 tim=1333153647754189 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#=:1
END OF STMT
PARSE #3:c=1000,e=567,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647754184
EXEC #3:c=999,e=860,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647755140
FETCH #3:c=0,e=64,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1333153647755247
STAT #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=65 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=40 us)'
=====================
PARSING IN CURSOR #4 len=206 dep=1 uid=0 oct=3 lid=0 tim=1333153647755441 hv=2888850659 ad='30f176cc'
select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0),NVL(scanhint,0) from seg$ where ts#=:1 and file#=:2 and block#=:3
END OF STMT
PARSE #4:c=0,e=44,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1333153647755435
EXEC #4:c=0,e=35,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1333153647755572
FETCH #4:c=0,e=46,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1333153647755647
STAT #4 id=1 cnt=1 pid=0 pos=1 obj=14 op='TABLE ACCESS CLUSTER SEG$ (cr=3 pr=0 pw=0 time=46 us)'
STAT #4 id=2 cnt=1 pid=1 pos=1 obj=9 op='INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=2 pr=0 pw=0 time=18 us)'
=====================
PARSING IN CURSOR #1 len=169 dep=1 uid=0 oct=3 lid=0 tim=1333153647756532 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 STMT
PARSE #1:c=0,e=455,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647756527
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647757102 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=43,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647757096
FETCH #3:c=0,e=52,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647757258
STAT #3 id=1 cnt=67 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=201 pr=0 pw=0 time=3713 us)'
STAT #3 id=2 cnt=67 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=134 pr=0 pw=0 time=1732 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647757435 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=0,e=29,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647757430
FETCH #4:c=0,e=33,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647757509
STAT #4 id=1 cnt=68 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=204 pr=0 pw=0 time=3749 us)'
STAT #4 id=2 cnt=68 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=136 pr=0 pw=0 time=1749 us)'
=====================
PARSING IN CURSOR #3 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647757697 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #3:c=1000,e=40,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647757692
WAIT #3: nam='db file sequential read' ela= 535 file#=1 block#=1892 blocks=1 obj#=-1 tim=1333153647758351
FETCH #3:c=0,e=722,p=1,cr=3,cu=0,mis=0,r=17,dep=2,og=3,tim=1333153647758463
STAT #3 id=1 cnt=409 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=75 pr=10 pw=0 time=40485 us)'
STAT #3 id=2 cnt=409 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=75 pr=10 pw=0 time=38986 us)'
STAT #3 id=3 cnt=25 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=50 pr=0 pw=0 time=584 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647758655 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=1000,e=35,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647758650
FETCH #4:c=0,e=40,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647758738
STAT #4 id=1 cnt=69 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=207 pr=0 pw=0 time=3790 us)'
STAT #4 id=2 cnt=69 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=138 pr=0 pw=0 time=1770 us)'
=====================
PARSING IN CURSOR #3 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647758949 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #3:c=0,e=35,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647758945
WAIT #3: nam='db file sequential read' ela= 589 file#=1 block#=1893 blocks=1 obj#=-1 tim=1333153647759615
FETCH #3:c=1000,e=723,p=1,cr=3,cu=0,mis=0,r=16,dep=2,og=3,tim=1333153647759713
STAT #3 id=1 cnt=425 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=78 pr=11 pw=0 time=41243 us)'
STAT #3 id=2 cnt=425 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=78 pr=11 pw=0 time=39714 us)'
STAT #3 id=3 cnt=26 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=52 pr=0 pw=0 time=603 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647759929 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=0,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647759924
FETCH #4:c=0,e=38,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647760010
STAT #4 id=1 cnt=70 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=210 pr=0 pw=0 time=3829 us)'
STAT #4 id=2 cnt=70 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=140 pr=0 pw=0 time=1790 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647760265 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=44,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647760260
FETCH #3:c=0,e=33,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647760344
STAT #3 id=1 cnt=71 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=213 pr=0 pw=0 time=3876 us)'
STAT #3 id=2 cnt=71 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=142 pr=0 pw=0 time=1806 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647760510 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=0,e=28,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647760506
FETCH #4:c=999,e=85,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647760657
STAT #4 id=1 cnt=72 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=216 pr=0 pw=0 time=3909 us)'
STAT #4 id=2 cnt=72 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=144 pr=0 pw=0 time=1822 us)'
EXEC #1:c=4999,e=4589,p=2,cr=24,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647761198
WAIT #1: nam='db file sequential read' ela= 5991 file#=1 block#=53200 blocks=1 obj#=-1 tim=1333153647767284
FETCH #1:c=1000,e=6513,p=1,cr=2,cu=0,mis=0,r=0,dep=1,og=4,tim=1333153647767762
STAT #1 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT GROUP BY (cr=2 pr=1 pw=0 time=6534 us)'
STAT #1 id=2 cnt=0 pid=1 pos=1 obj=57 op='TABLE ACCESS BY INDEX ROWID OBJAUTH$ (cr=2 pr=1 pw=0 time=6506 us)'
STAT #1 id=3 cnt=0 pid=2 pos=1 obj=103 op='INDEX RANGE SCAN I_OBJAUTH1 (cr=2 pr=1 pw=0 time=6495 us)'
=====================
PARSING IN CURSOR #3 len=151 dep=1 uid=0 oct=3 lid=0 tim=1333153647768317 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 STMT
PARSE #3:c=0,e=411,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647768312
EXEC #3:c=0,e=884,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647769293
FETCH #3:c=0,e=44,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,tim=1333153647769461
STAT #3 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT GROUP BY (cr=2 pr=0 pw=0 time=66 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=41 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=29 us)'
=====================
PARSING IN CURSOR #4 len=69 dep=1 uid=0 oct=3 lid=0 tim=1333153647769974 hv=1471956217 ad='30f1ea58'
select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1
END OF STMT
PARSE #4:c=0,e=334,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647769969
=====================
PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647770451 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #1:c=1000,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647770445
FETCH #1:c=0,e=54,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647770595
STAT #1 id=1 cnt=73 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=219 pr=0 pw=0 time=3963 us)'
STAT #1 id=2 cnt=73 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=146 pr=0 pw=0 time=1845 us)'
=====================
PARSING IN CURSOR #3 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647770771 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #3:c=0,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647770766
WAIT #3: nam='db file sequential read' ela= 11147 file#=1 block#=60652 blocks=1 obj#=-1 tim=1333153647782086
FETCH #3:c=1000,e=11391,p=1,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647782286
STAT #3 id=1 cnt=445 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=81 pr=12 pw=0 time=52697 us)'
STAT #3 id=2 cnt=445 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=81 pr=12 pw=0 time=51048 us)'
STAT #3 id=3 cnt=27 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=54 pr=0 pw=0 time=648 us)'
=====================
PARSING IN CURSOR #1 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647782494 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #1:c=0,e=51,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647782489
FETCH #1:c=0,e=108,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647782645
STAT #1 id=1 cnt=465 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=84 pr=12 pw=0 time=52878 us)'
STAT #1 id=2 cnt=465 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=84 pr=12 pw=0 time=51151 us)'
STAT #1 id=3 cnt=28 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=56 pr=0 pw=0 time=673 us)'
=====================
PARSING IN CURSOR #3 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647782802 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #3:c=0,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647782797
FETCH #3:c=0,e=95,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647782938
STAT #3 id=1 cnt=485 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=87 pr=12 pw=0 time=53022 us)'
STAT #3 id=2 cnt=485 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=87 pr=12 pw=0 time=51242 us)'
STAT #3 id=3 cnt=29 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=58 pr=0 pw=0 time=690 us)'
=====================
PARSING IN CURSOR #1 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647783145 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #1:c=0,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647783140
FETCH #1:c=0,e=100,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647783369
STAT #1 id=1 cnt=505 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=90 pr=12 pw=0 time=53168 us)'
STAT #1 id=2 cnt=505 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=90 pr=12 pw=0 time=51357 us)'
STAT #1 id=3 cnt=30 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=60 pr=0 pw=0 time=707 us)'
=====================
PARSING IN CURSOR #3 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647783500 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #3:c=0,e=34,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647783497
FETCH #3:c=0,e=92,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647783633
STAT #3 id=1 cnt=525 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=93 pr=12 pw=0 time=53309 us)'
STAT #3 id=2 cnt=525 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=93 pr=12 pw=0 time=51452 us)'
STAT #3 id=3 cnt=31 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=62 pr=0 pw=0 time=721 us)'
=====================
PARSING IN CURSOR #1 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647783894 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #1:c=0,e=34,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647783889
FETCH #1:c=1000,e=112,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647784047
STAT #1 id=1 cnt=545 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=96 pr=12 pw=0 time=53470 us)'
STAT #1 id=2 cnt=545 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=96 pr=12 pw=0 time=51570 us)'
STAT #1 id=3 cnt=32 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=64 pr=0 pw=0 time=738 us)'
=====================
PARSING IN CURSOR #3 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647784267 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #3:c=0,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647784263
FETCH #3:c=0,e=93,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647784401
STAT #3 id=1 cnt=565 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=99 pr=12 pw=0 time=53611 us)'
STAT #3 id=2 cnt=565 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=99 pr=12 pw=0 time=51673 us)'
STAT #3 id=3 cnt=33 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=66 pr=0 pw=0 time=753 us)'
=====================
PARSING IN CURSOR #1 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647784564 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #1:c=0,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647784559
FETCH #1:c=0,e=104,p=0,cr=3,cu=0,mis=0,r=8,dep=2,og=3,tim=1333153647784709
STAT #1 id=1 cnt=573 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=102 pr=12 pw=0 time=53736 us)'
STAT #1 id=2 cnt=573 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=102 pr=12 pw=0 time=51757 us)'
STAT #1 id=3 cnt=34 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=68 pr=0 pw=0 time=769 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647784929 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=30,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647784924
FETCH #3:c=999,e=40,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647785027
STAT #3 id=1 cnt=74 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=222 pr=0 pw=0 time=4003 us)'
STAT #3 id=2 cnt=74 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=148 pr=0 pw=0 time=1866 us)'
=====================
PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647785384 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #1:c=0,e=36,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647785379
FETCH #1:c=0,e=36,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647785468
STAT #1 id=1 cnt=75 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=225 pr=0 pw=0 time=4040 us)'
STAT #1 id=2 cnt=75 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=150 pr=0 pw=0 time=1883 us)'
=====================
PARSING IN CURSOR #3 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647785598 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #3:c=0,e=34,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647785594
WAIT #3: nam='db file sequential read' ela= 701 file#=1 block#=60653 blocks=1 obj#=-1 tim=1333153647786445
FETCH #3:c=0,e=876,p=1,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647786575
STAT #3 id=1 cnt=593 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=105 pr=13 pw=0 time=54675 us)'
STAT #3 id=2 cnt=593 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=105 pr=13 pw=0 time=52606 us)'
STAT #3 id=3 cnt=35 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=70 pr=0 pw=0 time=786 us)'
=====================
PARSING IN CURSOR #1 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647786770 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #1:c=0,e=44,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647786765
FETCH #1:c=1000,e=140,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647787007
STAT #1 id=1 cnt=613 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=108 pr=13 pw=0 time=54865 us)'
STAT #1 id=2 cnt=613 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=108 pr=13 pw=0 time=52751 us)'
STAT #1 id=3 cnt=36 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=72 pr=0 pw=0 time=836 us)'
=====================
PARSING IN CURSOR #3 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647787176 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #3:c=0,e=39,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647787171
FETCH #3:c=0,e=104,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647787327
STAT #3 id=1 cnt=633 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=111 pr=13 pw=0 time=55036 us)'
STAT #3 id=2 cnt=633 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=111 pr=13 pw=0 time=52866 us)'
STAT #3 id=3 cnt=37 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=74 pr=0 pw=0 time=854 us)'
=====================
PARSING IN CURSOR #1 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647787467 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #1:c=0,e=35,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647787462
FETCH #1:c=0,e=121,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647787632
STAT #1 id=1 cnt=653 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=114 pr=13 pw=0 time=55565 us)'
STAT #1 id=2 cnt=653 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=114 pr=13 pw=0 time=52982 us)'
STAT #1 id=3 cnt=38 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=76 pr=0 pw=0 time=870 us)'
=====================
PARSING IN CURSOR #3 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647787777 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #3:c=0,e=35,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647787772
FETCH #3:c=1000,e=117,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647787939
STAT #3 id=1 cnt=673 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=117 pr=13 pw=0 time=55751 us)'
STAT #3 id=2 cnt=673 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=117 pr=13 pw=0 time=53101 us)'
STAT #3 id=3 cnt=39 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=78 pr=0 pw=0 time=885 us)'
=====================
PARSING IN CURSOR #1 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647788166 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #1:c=0,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647788160
FETCH #1:c=0,e=102,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647788313
STAT #1 id=1 cnt=693 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=120 pr=13 pw=0 time=55903 us)'
STAT #1 id=2 cnt=693 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=120 pr=13 pw=0 time=53225 us)'
STAT #1 id=3 cnt=40 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=80 pr=0 pw=0 time=903 us)'
=====================
PARSING IN CURSOR #3 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647788450 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #3:c=0,e=34,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647788445
FETCH #3:c=0,e=121,p=0,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647788615
STAT #3 id=1 cnt=713 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=123 pr=13 pw=0 time=56070 us)'
STAT #3 id=2 cnt=713 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=123 pr=13 pw=0 time=53350 us)'
STAT #3 id=3 cnt=41 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=82 pr=0 pw=0 time=919 us)'
=====================
PARSING IN CURSOR #1 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647788807 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #1:c=0,e=35,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647788802
FETCH #1:c=1000,e=95,p=0,cr=3,cu=0,mis=0,r=8,dep=2,og=3,tim=1333153647788963
STAT #1 id=1 cnt=721 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=126 pr=13 pw=0 time=56186 us)'
STAT #1 id=2 cnt=721 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=126 pr=13 pw=0 time=53430 us)'
STAT #1 id=3 cnt=42 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=84 pr=0 pw=0 time=935 us)'
EXEC #4:c=7999,e=19607,p=2,cr=57,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647789676
FETCH #4:c=0,e=31,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=1333153647789747
STAT #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=36 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=25 us)'
=====================
PARSING IN CURSOR #3 len=146 dep=1 uid=0 oct=3 lid=0 tim=1333153647790412 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#=:1
END OF STMT
PARSE #3:c=1000,e=549,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647790407
=====================
PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647791093 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #1:c=1000,e=43,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647791086
FETCH #1:c=0,e=48,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647791193
STAT #1 id=1 cnt=76 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=228 pr=0 pw=0 time=4089 us)'
STAT #1 id=2 cnt=76 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=152 pr=0 pw=0 time=1906 us)'
=====================
PARSING IN CURSOR #4 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647791335 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #4:c=0,e=39,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647791331
WAIT #4: nam='db file sequential read' ela= 7693 file#=1 block#=1818 blocks=1 obj#=-1 tim=1333153647799111
FETCH #4:c=0,e=7854,p=1,cr=3,cu=0,mis=0,r=8,dep=2,og=3,tim=1333153647799233
STAT #4 id=1 cnt=729 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=129 pr=14 pw=0 time=64060 us)'
STAT #4 id=2 cnt=729 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=129 pr=14 pw=0 time=61256 us)'
STAT #4 id=3 cnt=43 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=86 pr=0 pw=0 time=955 us)'
=====================
PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647799468 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #1:c=0,e=42,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647799463
FETCH #1:c=0,e=47,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647799562
STAT #1 id=1 cnt=77 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=231 pr=0 pw=0 time=4137 us)'
STAT #1 id=2 cnt=77 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=154 pr=0 pw=0 time=1932 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647799729 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=999,e=29,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647799724
FETCH #4:c=0,e=37,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647799887
STAT #4 id=1 cnt=78 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=234 pr=0 pw=0 time=4173 us)'
STAT #4 id=2 cnt=78 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=156 pr=0 pw=0 time=1950 us)'
=====================
PARSING IN CURSOR #1 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647800098 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #1:c=0,e=39,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647800092
WAIT #1: nam='db file sequential read' ela= 646 file#=1 block#=1819 blocks=1 obj#=-1 tim=1333153647800828
FETCH #1:c=0,e=858,p=1,cr=3,cu=0,mis=0,r=10,dep=2,og=3,tim=1333153647801002
STAT #1 id=1 cnt=739 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=132 pr=15 pw=0 time=64910 us)'
STAT #1 id=2 cnt=739 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=132 pr=15 pw=0 time=62044 us)'
STAT #1 id=3 cnt=44 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=88 pr=0 pw=0 time=976 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647801222 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=0,e=40,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647801216
FETCH #4:c=0,e=45,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647801338
STAT #4 id=1 cnt=79 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=237 pr=0 pw=0 time=4220 us)'
STAT #4 id=2 cnt=79 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=158 pr=0 pw=0 time=1974 us)'
=====================
PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647801484 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #1:c=0,e=30,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647801479
FETCH #1:c=1000,e=64,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647801592
STAT #1 id=1 cnt=80 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=240 pr=0 pw=0 time=4285 us)'
STAT #1 id=2 cnt=80 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=160 pr=0 pw=0 time=1990 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647801757 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=0,e=29,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647801734
FETCH #4:c=0,e=23,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647801830
STAT #4 id=1 cnt=80 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=242 pr=0 pw=0 time=4314 us)'
STAT #4 id=2 cnt=80 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=162 pr=0 pw=0 time=2008 us)'
=====================
PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647801975 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #1:c=0,e=28,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647801970
FETCH #1:c=0,e=34,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647802052
STAT #1 id=1 cnt=81 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=245 pr=0 pw=0 time=4348 us)'
STAT #1 id=2 cnt=81 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=164 pr=0 pw=0 time=2023 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647802191 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=0,e=27,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647802187
FETCH #4:c=0,e=35,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647802324
STAT #4 id=1 cnt=82 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=248 pr=0 pw=0 time=4383 us)'
STAT #4 id=2 cnt=82 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=166 pr=0 pw=0 time=2040 us)'
EXEC #3:c=3999,e=12488,p=2,cr=29,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647802994
FETCH #3:c=0,e=47,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1333153647803081
=====================
PARSING IN CURSOR #1 len=70 dep=1 uid=0 oct=3 lid=0 tim=1333153647803625 hv=3849548163 ad='30f1e568'
select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1
END OF STMT
PARSE #1:c=1000,e=491,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647803620
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647804127 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=0,e=39,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647804122
WAIT #4: nam='db file sequential read' ela= 11152 file#=1 block#=1777 blocks=1 obj#=-1 tim=1333153647815396
FETCH #4:c=0,e=11312,p=1,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647815488
STAT #4 id=1 cnt=83 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=251 pr=1 pw=0 time=15672 us)'
STAT #4 id=2 cnt=83 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=168 pr=0 pw=0 time=2061 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647815814 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=0,e=50,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647815808
FETCH #4:c=0,e=66,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647815935
STAT #4 id=1 cnt=84 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=254 pr=1 pw=0 time=15738 us)'
STAT #4 id=2 cnt=84 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=170 pr=0 pw=0 time=2088 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647816128 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=0,e=35,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647816124
FETCH #4:c=1000,e=40,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647816248
STAT #4 id=1 cnt=85 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=257 pr=1 pw=0 time=15779 us)'
STAT #4 id=2 cnt=85 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=172 pr=0 pw=0 time=2107 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647816447 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=0,e=38,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647816440
FETCH #4:c=0,e=44,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647816838
STAT #4 id=1 cnt=86 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=260 pr=1 pw=0 time=15822 us)'
STAT #4 id=2 cnt=86 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=174 pr=0 pw=0 time=2128 us)'
=====================
PARSING IN CURSOR #4 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647817086 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #4:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647817080
WAIT #4: nam='db file sequential read' ela= 3420 file#=1 block#=1816 blocks=1 obj#=-1 tim=1333153647820623
FETCH #4:c=1000,e=3668,p=1,cr=3,cu=0,mis=0,r=20,dep=2,og=3,tim=1333153647820804
STAT #4 id=1 cnt=759 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=135 pr=16 pw=0 time=68627 us)'
STAT #4 id=2 cnt=759 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=135 pr=16 pw=0 time=65698 us)'
STAT #4 id=3 cnt=45 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=90 pr=0 pw=0 time=1001 us)'
=====================
PARSING IN CURSOR #4 len=121 dep=2 uid=0 oct=3 lid=0 tim=1333153647821002 hv=3150898423 ad='30e94488'
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
END OF STMT
EXEC #4:c=0,e=47,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647820997
FETCH #4:c=1000,e=117,p=0,cr=3,cu=0,mis=0,r=14,dep=2,og=3,tim=1333153647821170
STAT #4 id=1 cnt=773 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=138 pr=16 pw=0 time=68785 us)'
STAT #4 id=2 cnt=773 pid=1 pos=1 obj=253 op='TABLE ACCESS CLUSTER HISTGRM$ (cr=138 pr=16 pw=0 time=65812 us)'
STAT #4 id=3 cnt=46 pid=2 pos=1 obj=252 op='INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=92 pr=0 pw=0 time=1041 us)'
=====================
PARSING IN CURSOR #4 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647821410 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #4:c=0,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647821405
FETCH #4:c=0,e=43,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647821504
STAT #4 id=1 cnt=87 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=263 pr=1 pw=0 time=15866 us)'
STAT #4 id=2 cnt=87 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=176 pr=0 pw=0 time=2151 us)'
EXEC #1:c=3999,e=18355,p=2,cr=21,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647822080
WAIT #1: nam='db file sequential read' ela= 9920 file#=1 block#=362 blocks=1 obj#=-1 tim=1333153647832081
WAIT #1: nam='db file sequential read' ela= 8311 file#=1 block#=26736 blocks=1 obj#=-1 tim=1333153647840502
FETCH #1:c=1000,e=18526,p=2,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1333153647840647
FETCH #1:c=0,e=18,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=1333153647840724
STAT #1 id=1 cnt=1 pid=0 pos=1 obj=32 op='TABLE ACCESS BY INDEX ROWID CCOL$ (cr=4 pr=2 pw=0 time=18518 us)'
STAT #1 id=2 cnt=1 pid=1 pos=1 obj=54 op='INDEX RANGE SCAN I_CCOL1 (cr=3 pr=2 pw=0 time=18479 us)'
FETCH #3:c=0,e=31,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1333153647840986
=====================
PARSING IN CURSOR #4 len=70 dep=1 uid=0 oct=3 lid=0 tim=1333153647841154 hv=3849548163 ad='30f1e568'
select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1
END OF STMT
EXEC #4:c=0,e=48,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1333153647841147
FETCH #4:c=0,e=40,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1333153647841250
FETCH #4:c=0,e=33,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=1333153647841315
FETCH #3:c=0,e=12,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=1333153647841379
STAT #3 id=1 cnt=2 pid=0 pos=1 obj=31 op='TABLE ACCESS BY INDEX ROWID CDEF$ (cr=6 pr=0 pw=0 time=44 us)'
STAT #3 id=2 cnt=2 pid=1 pos=1 obj=51 op='INDEX RANGE SCAN I_CDEF2 (cr=4 pr=0 pw=0 time=35 us)'
=====================
PARSING IN CURSOR #1 len=116 dep=1 uid=0 oct=3 lid=0 tim=1333153647842032 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#=:1
END OF STMT
EXEC #1:c=0,e=45,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1333153647842026
FETCH #1:c=0,e=48,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=1333153647842140
=====================
PARSING IN CURSOR #4 len=196 dep=1 uid=0 oct=3 lid=0 tim=1333153647842885 hv=3275427458 ad='30ee6aa0'
select name,password,datats#,tempts#,type#,defrole,resource$, ptime, exptime, ltime, astatus, lcount, decode(defschclass,NULL,'DEFAULT_CONSUMER_GROUP',defschclass),spare1 from user$ where user#=:1
END OF STMT
PARSE #4:c=1000,e=567,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647842877
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647843829 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=1000,e=113,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647843820
FETCH #3:c=0,e=60,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647843957
STAT #3 id=1 cnt=88 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=266 pr=1 pw=0 time=15985 us)'
STAT #3 id=2 cnt=88 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=178 pr=0 pw=0 time=2239 us)'
=====================
PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647844142 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #1:c=0,e=35,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647844136
FETCH #1:c=0,e=72,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647844264
STAT #1 id=1 cnt=89 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=269 pr=1 pw=0 time=16055 us)'
STAT #1 id=2 cnt=89 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=180 pr=0 pw=0 time=2256 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647844432 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647844427
FETCH #3:c=1000,e=57,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647844539
STAT #3 id=1 cnt=90 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=272 pr=1 pw=0 time=16113 us)'
STAT #3 id=2 cnt=90 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=182 pr=0 pw=0 time=2274 us)'
=====================
PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647844732 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #1:c=0,e=50,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647844724
FETCH #1:c=0,e=40,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647844826
STAT #1 id=1 cnt=91 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=275 pr=1 pw=0 time=16153 us)'
STAT #1 id=2 cnt=91 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=184 pr=0 pw=0 time=2293 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647844980 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=32,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647844975
FETCH #3:c=0,e=36,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647845065
STAT #3 id=1 cnt=92 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=278 pr=1 pw=0 time=16191 us)'
STAT #3 id=2 cnt=92 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=186 pr=0 pw=0 time=2309 us)'
=====================
PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647845335 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #1:c=0,e=34,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647845330
FETCH #1:c=0,e=39,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647845424
STAT #1 id=1 cnt=93 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=281 pr=1 pw=0 time=16232 us)'
STAT #1 id=2 cnt=93 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=188 pr=0 pw=0 time=2327 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647845645 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647845639
FETCH #3:c=0,e=38,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647845759
STAT #3 id=1 cnt=94 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=284 pr=1 pw=0 time=16271 us)'
STAT #3 id=2 cnt=94 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=190 pr=0 pw=0 time=2345 us)'
=====================
PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647845915 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #1:c=0,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647845910
FETCH #1:c=0,e=37,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647846000
STAT #1 id=1 cnt=95 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=287 pr=1 pw=0 time=16310 us)'
STAT #1 id=2 cnt=95 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=192 pr=0 pw=0 time=2362 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647846230 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647846224
FETCH #3:c=0,e=37,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647846320
STAT #3 id=1 cnt=96 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=290 pr=1 pw=0 time=16349 us)'
STAT #3 id=2 cnt=96 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=194 pr=0 pw=0 time=2379 us)'
=====================
PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647846492 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #1:c=999,e=53,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647846487
FETCH #1:c=0,e=38,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647846579
STAT #1 id=1 cnt=97 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=293 pr=1 pw=0 time=16409 us)'
STAT #1 id=2 cnt=97 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=196 pr=0 pw=0 time=2418 us)'
=====================
PARSING IN CURSOR #3 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647846757 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #3:c=0,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647846751
FETCH #3:c=0,e=38,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647846844
STAT #3 id=1 cnt=98 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=296 pr=1 pw=0 time=16447 us)'
STAT #3 id=2 cnt=98 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=198 pr=0 pw=0 time=2436 us)'
=====================
PARSING IN CURSOR #1 len=210 dep=2 uid=0 oct=3 lid=0 tim=1333153647847089 hv=864012087 ad='30e96948'
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#=:2
END OF STMT
EXEC #1:c=0,e=32,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,tim=1333153647847083
FETCH #1:c=0,e=111,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,tim=1333153647847252
STAT #1 id=1 cnt=99 pid=0 pos=1 obj=255 op='TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=299 pr=1 pw=0 time=16558 us)'
STAT #1 id=2 cnt=99 pid=1 pos=1 obj=257 op='INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=200 pr=0 pw=0 time=2522 us)'
EXEC #4:c=4999,e=5057,p=0,cr=36,cu=0,mis=1,r=0,dep=1,og=4,tim=1333153647848047
FETCH #4:c=0,e=81,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=1333153647848172
STAT #4 id=1 cnt=1 pid=0 pos=1 obj=22 op='TABLE ACCESS CLUSTER USER$ (cr=2 pr=0 pw=0 time=79 us)'
STAT #4 id=2 cnt=1 pid=1 pos=1 obj=11 op='INDEX UNIQUE SCAN I_USER# (cr=1 pr=0 pw=0 time=32 us)'
=====================
PARSING IN CURSOR #2 len=30 dep=0 uid=0 oct=3 lid=0 tim=1333153647848433 hv=2575340915 ad='30d778cc'
select count(*) from scott.emp
END OF STMT
PARSE #2:c=121981,e=247311,p=25,cr=494,cu=0,mis=1,r=0,dep=0,og=1,tim=1333153647848408
EXEC #2:c=0,e=84,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=1333153647848569
WAIT #2: nam='SQL*Net message to client' ela= 7 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1333153647848666
WAIT #2: nam='db file sequential read' ela= 14483 file#=4 block#=36 blocks=1 obj#=51149 tim=1333153647863731
FETCH #2:c=1000,e=15212,p=1,cr=1,cu=0,mis=0,r=1,dep=0,og=1,tim=1333153647863922
WAIT #2: nam='SQL*Net message from client' ela= 392 driver id=1650815232 #bytes=1 p3=0 obj#=51149 tim=1333153647864452
FETCH #2:c=0,e=2,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=1333153647864501
WAIT #2: nam='SQL*Net message to client' ela= 3 driver id=1650815232 #bytes=1 p3=0 obj#=51149 tim=1333153647864534
WAIT #2: nam='SQL*Net message from client' ela= 384 driver id=1650815232 #bytes=1 p3=0 obj#=51149 tim=1333153647864986
STAT #2 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT AGGREGATE (cr=1 pr=1 pw=0 time=15252 us)'
STAT #2 id=2 cnt=14 pid=1 pos=1 obj=51149 op='INDEX FULL SCAN PK_EMP (cr=1 pr=1 pw=0 time=15222 us)'
WAIT #0: nam='SQL*Net message to client' ela= 3 driver id=1650815232 #bytes=1 p3=0 obj#=51149 tim=1333153647865143
*** 2013-04-05 16:09:13.642
WAIT #0: nam='SQL*Net message from client' ela= 17801270 driver id=1650815232 #bytes=1 p3=0 obj#=51149 tim=1333153665666458
=====================
PARSING IN CURSOR #3 len=55 dep=0 uid=0 oct=42 lid=0 tim=1333153665667388 hv=2217940283 ad='30d6053c'
alter session set events '10046 trace name context off'
END OF STMT
PARSE #3:c=1000,e=705,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=1333153665667376
EXEC #3:c=0,e=110,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=1333153665667601
[oracle@sunblaze ~]$

本版精华
热门帖子

操作引用/回复

总帖数

每页帖数

1/1页

返回列表

用户登录

Weblogic中间件技术论坛

Tuxedo中间件技术论坛

数据库论坛

Java论坛

Linux/unix论坛

网站地图