Oracle Database Discussions

Hi list,

i have find these statments on the top on TKPROF report :

select intcol#,nvl(pos#,0),col#,nvl(spare1,0)
from ccol$ where con#=:1

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
parse 13 0.00 0.00 0 0 0 0
Execute 1121 0.03 0.07 0 0 0 0
Fetch 2343 0.01 1513.09 32 4686 0 1222
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3477 0.04 1513.16 32 4686 0 1222

Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 1)

Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID CCOL$ (cr=4 pr=2 pw=0 time=9966 us)
1 INDEX RANGE SCAN I_CCOL1 (cr=3 pr=2 pw=0 time=9957 us)(object id 54)


Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 32 0.00 0.06
********************************************************************************

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


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 19 0.00 0.00 0 0 0 0
Execute 752 0.12 0.08 0 0 0 0
Fetch 752 0.00 1512.93 1 2255 0 748
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1523 0.12 1513.02 1 2255 0 748

Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: RULE
Parsing user id: SYS (recursive depth: 2)

Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=3 pr=0 pw=0 time=33 us)
1 INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=2 pr=0 pw=0 time=24 us)(object id 257)


Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************

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


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 246 0.00 1503.95 0 0 0 0
Execute 246 0.06 0.04 0 0 0 0
Fetch 246 0.00 0.00 0 738 0 246
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 738 0.06 1503.99 0 738 0 246

Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 2)

Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS CLUSTER SEG$ (cr=3 pr=0 pw=0 time=32 us)
1 INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=2 pr=0 pw=0 time=15 us)(object id 9)

***************************************************


what might be the cause of these ? is it lack of using bind variables or problem with sys tables ??

Oracle 10g relaese 10.2.0.4.0 ,EE.

Thanks for your help.