TKPROF: Release 9.2.0.7.0 - Production on Tue Jan 30 18:19:14 2007 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Trace file: mtms_ora_2021.trc Sort options: default ******************************************************************************** count = number of times OCI procedure was executed cpu = cpu time in seconds executing elapsed = elapsed time in seconds executing disk = number of physical reads of buffers from disk query = number of buffers gotten for consistent read current = number of buffers gotten in current mode (usually for update) rows = number of rows processed by the fetch or execute call ******************************************************************************** select privilege#,level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with (grantee#=:1 or grantee#=1) and privilege#>0 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 22 0.00 0.00 0 7 0 21 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 24 0.00 0.00 0 7 0 21 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 21 CONNECT BY WITH FILTERING 2 TABLE ACCESS BY INDEX ROWID SYSAUTH$ 2 CONCATENATION 0 INDEX RANGE SCAN I_SYSAUTH1 (object id 110) 2 INDEX RANGE SCAN I_SYSAUTH1 (object id 110) 19 NESTED LOOPS 17 BUFFER SORT 17 CONNECT BY PUMP 19 INDEX RANGE SCAN I_SYSAUTH1 (object id 110) 0 TABLE ACCESS FULL SYSAUTH$ ******************************************************************************** ALTER SESSION SET NLS_LANGUAGE = 'AMERICAN' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 ******************************************************************************** ALTER SESSION SET NLS_TERRITORY = 'AMERICA' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.00 0 0 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 ******************************************************************************** SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 Rows Row Source Operation ------- --------------------------------------------------- 1 MERGE JOIN 102 FIXED TABLE FULL X$KSPPCV 1 FILTER 1 SORT JOIN 1 FIXED TABLE FULL X$KSPPI ******************************************************************************** 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 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.01 0.00 0 0 0 0 Execute 16 0.00 0.00 0 0 0 0 Fetch 16 0.00 0.01 2 47 0 15 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 38 0.01 0.01 2 47 0 15 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** select audit$,options from procedure$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 6 0.00 0.00 0 0 0 0 Fetch 6 0.00 0.01 2 18 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.00 0.01 2 18 0 6 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID PROCEDURE$ 1 INDEX UNIQUE SCAN I_PROCEDURE1 (object id 115) ******************************************************************************** select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, d_owner#, nvl(property,0),subname from dependency$,obj$ where d_obj#=:1 and p_obj#=obj#(+) order by order# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 11 0.00 0.00 0 0 0 0 Execute 11 0.00 0.00 0 0 0 0 Fetch 23 0.00 0.01 2 60 0 12 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 45 0.00 0.01 2 60 0 12 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT ORDER BY 0 NESTED LOOPS OUTER 0 TABLE ACCESS BY INDEX ROWID DEPENDENCY$ 0 INDEX RANGE SCAN I_DEPENDENCY1 (object id 127) 0 TABLE ACCESS BY INDEX ROWID OBJ$ 0 INDEX UNIQUE SCAN I_OBJ1 (object id 36) ******************************************************************************** select order#,columns,types from access$ where d_obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 11 0.00 0.00 0 0 0 0 Execute 11 0.00 0.00 0 0 0 0 Fetch 18 0.00 0.01 2 35 0 7 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 40 0.00 0.01 2 35 0 7 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID ACCESS$ 0 INDEX RANGE SCAN I_ACCESS1 (object id 129) ******************************************************************************** select ts#,file#,block#,nvl(bobj#,0),nvl(tab#,0),intcols,nvl(clucols,0), audit$,flags,pctfree$,pctused$,initrans,maxtrans,rowcnt,blkcnt,empcnt, avgspc,chncnt,avgrln,analyzetime, samplesize,cols,property,nvl(degree,1), nvl(instances,1),avgspc_flb,flbcnt,kernelcols,nvl(trigflag, 0),nvl(spare1,0) ,nvl(spare2,0),spare4,spare6 from tab$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 11 0.00 0.00 0 0 0 0 Fetch 11 0.01 0.00 0 33 0 11 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 28 0.01 0.00 0 33 0 11 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts, NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0) from seg$ where ts#=:1 and file#=:2 and block#=:3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 22 0.00 0.00 0 0 0 0 Execute 22 0.00 0.00 0 0 0 0 Fetch 22 0.00 0.00 0 66 0 22 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 66 0.00 0.00 0 66 0 22 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS CLUSTER SEG$ 1 INDEX UNIQUE SCAN I_FILE#_BLOCK# (object id 9) ******************************************************************************** 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,spare2,spare6, decode(i.pctthres$,null, null, mod(trunc(i.pctthres$/256),256)) from ind$ i, (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.bo#= :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 11 0.00 0.00 0 0 0 0 Fetch 25 0.00 0.00 0 53 0 14 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 42 0.00 0.00 0 53 0 14 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 14 0.00 0.00 0 0 0 0 Fetch 38 0.00 0.00 0 76 0 24 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 58 0.00 0.00 0 76 0 24 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** 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# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 11 0.00 0.00 0 0 0 0 Fetch 52 0.00 0.00 0 37 0 41 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 69 0.00 0.00 0 37 0 41 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname, o.dataobj#,o.flags from obj$ o where o.obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 8 0.00 0.00 0 0 0 0 Execute 23 0.00 0.00 0 0 0 0 Fetch 23 0.00 0.00 0 69 0 23 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 54 0.00 0.00 0 69 0 23 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#,length,piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 12 0.01 0.01 1 4 0 0 Execute 12 0.00 0.00 0 0 0 0 Fetch 29 0.01 0.05 11 76 0 17 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 53 0.02 0.07 12 80 0 17 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 2 TABLE ACCESS BY INDEX ROWID IDL_SB4$ 2 INDEX RANGE SCAN I_IDL_SB41 (object id 123) ******************************************************************************** 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 1 0.00 0.00 0 0 0 0 Execute 24 0.00 0.00 0 0 0 0 Fetch 24 0.00 0.00 0 48 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 49 0.00 0.00 0 48 0 0 Misses in library cache during parse: 0 Optimizer goal: RULE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#,length,piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 12 0.01 0.01 1 4 0 0 Execute 12 0.00 0.00 0 0 0 0 Fetch 24 0.00 0.04 13 72 0 17 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 48 0.01 0.05 14 76 0 17 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID IDL_UB1$ 1 INDEX RANGE SCAN I_IDL_UB11 (object id 120) ******************************************************************************** select /*+ index(idl_char$ i_idl_char1) +*/ piece#,length,piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 12 0.00 0.00 1 4 0 0 Execute 12 0.00 0.00 0 0 0 0 Fetch 18 0.00 0.01 7 42 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 42 0.00 0.02 8 46 0 6 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID IDL_CHAR$ 1 INDEX RANGE SCAN I_IDL_CHAR1 (object id 121) ******************************************************************************** select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#,length,piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 12 0.00 0.00 1 4 0 0 Execute 12 0.00 0.00 0 0 0 0 Fetch 41 0.00 0.06 58 149 0 35 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 65 0.00 0.07 59 153 0 35 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 24 TABLE ACCESS BY INDEX ROWID IDL_UB2$ 24 INDEX RANGE SCAN I_IDL_UB21 (object id 122) ******************************************************************************** begin :1 := dbms_pickler.get_type_shape(:2,:3,:4,:5,:6,:7); :8 := dbms_pickler.get_format(:9); end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.04 0.01 0 0 0 0 Execute 1 0.03 0.07 6 25 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.07 0.09 6 25 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 30 ******************************************************************************** select node,owner,name from syn$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 2 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 2 3 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** 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# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 5 0.00 0.00 0 0 0 0 Execute 5 0.00 0.00 0 0 0 0 Fetch 6 0.00 0.00 0 11 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16 0.00 0.00 0 11 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** select obj# from oid$ where user#=:1 and oid$=:2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 1 4 0 0 Execute 9 0.00 0.00 0 0 0 0 Fetch 9 0.00 0.02 5 23 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 22 0.00 0.03 6 27 0 5 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID OBJ#(293) 1 INDEX UNIQUE SCAN OBJ#(294) (object id 294) ******************************************************************************** select name,password,datats#,tempts#,type#,defrole,resource$, ptime, exptime, ltime, astatus, lcount, decode(defschclass,NULL,'DEFAULT_CONSUMER_GROUP', defschclass) from user$ where user#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS CLUSTER USER$ 1 INDEX UNIQUE SCAN I_USER# (object id 11) ******************************************************************************** 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# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 8 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.00 0 8 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT GROUP BY 0 TABLE ACCESS BY INDEX ROWID OBJ#(90) 0 INDEX RANGE SCAN OBJ#(108) (object id 108) ******************************************************************************** select col#,intcol#,toid,version#,packed,intcols,intcol#s,flags, synobj#, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 8 0.00 0.00 0 12 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16 0.00 0.00 0 12 0 4 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** select intcol#, toid, version#, intcols, intcol#s, flags, synobj# from subcoltype$ where obj#=:1 order by intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 12 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.00 0 12 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** select col#,intcol#,ntab# from ntab$ where obj#=:1 order by intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 12 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.00 0 12 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.pctversion$, l.flags, l.property, l.retention, l.freepools from lob$ l where l.obj# = :1 order by l.intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 8 0.00 0.00 0 12 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16 0.00 0.00 0 12 0 4 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT ORDER BY 1 TABLE ACCESS CLUSTER LOB$ 1 INDEX UNIQUE SCAN I_OBJ# (object id 3) ******************************************************************************** select col#,intcol#,reftyp,stabid,expctoid from refcon$ where obj#=:1 order by intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 12 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.00 0 12 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** select col#,intcol#,charsetid,charsetform from col$ where obj#=:1 order by intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 12 0.00 0.00 0 12 0 8 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 20 0.00 0.00 0 12 0 8 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** select intcol#,type,flags,lobcol,objcol,extracol,schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.01 0.00 0 12 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.01 0.00 0 12 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** select u.name,o.name, t.update$, t.insert$, t.delete$, t.enabled from obj$ o,user$ u,trigger$ t where t.baseobject=:1 and t.obj#=o.obj# and o.owner#=u.user# order by o.obj# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 4 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.00 0 4 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT ORDER BY 0 NESTED LOOPS 0 NESTED LOOPS 0 TABLE ACCESS BY INDEX ROWID TRIGGER$ 0 INDEX RANGE SCAN I_TRIGGER1 (object id 130) 0 TABLE ACCESS BY INDEX ROWID OBJ$ 0 INDEX UNIQUE SCAN I_OBJ1 (object id 36) 0 TABLE ACCESS CLUSTER USER$ 0 INDEX UNIQUE SCAN I_USER# (object id 11) ******************************************************************************** select parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, definitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextpct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(trunc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpartcnt, mod(trunc(spare2/4294967296), 256) defhscflags from partobj$ where obj# = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 4 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.00 0 4 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID PARTOBJ$ 0 INDEX UNIQUE SCAN I_PARTOBJ$ (object id 227) ******************************************************************************** select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 4 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.00 0 4 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** 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 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 8 0.00 0.00 0 12 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16 0.00 0.00 0 12 0 4 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** select intcol#,nvl(pos#,0),col# from ccol$ where con#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 8 0.00 0.00 1 16 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16 0.00 0.00 1 16 0 4 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** select metadata from kopm$ where name='DB_FDO' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID KOPM$ 1 INDEX UNIQUE SCAN I_KOPM1 (object id 351) ******************************************************************************** BEGIN my_pkg.get_phonetype(:1,:2); END; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 58 0.01 0.00 0 0 0 0 Execute 58 0.12 0.14 14 198 0 58 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 116 0.13 0.15 14 198 0 58 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 30 ******************************************************************************** select audit$,properties from type_misc$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 1 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS CLUSTER TYPE_MISC$ 1 INDEX UNIQUE SCAN I_OBJ# (object id 3) ******************************************************************************** select source from source$ where obj#=:1 order by line call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.01 1 27 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.01 0.01 3 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.02 0.02 4 30 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT ORDER BY 1 TABLE ACCESS BY INDEX ROWID SOURCE$ 1 INDEX RANGE SCAN I_SOURCE1 (object id 119) ******************************************************************************** SELECT STATIC_TERMINAL_PROFILE FROM NTMS40_PHONETYPES A, NTMS40_PHONE_IMEI_RANGES B, TABLE(:B1 ) C WHERE A.PHONETYPE=B.PHONETYPE AND (B.START_IMEI < C.COLUMN_VALUE AND B.END_IMEI > C.COLUMN_VALUE) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 58 0.01 0.00 0 0 0 0 Execute 59 0.06 0.09 1 3 0 0 Fetch 5774 255.01 275.60 11001 13746 174 57179 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5891 255.08 275.70 11002 13749 174 57179 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer goal: CHOOSE Parsing user id: 30 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1000 HASH JOIN 914 TABLE ACCESS FULL NTMS40_PHONETYPES 1000 MERGE JOIN 6691 SORT JOIN 6691 TABLE ACCESS FULL NTMS40_PHONE_IMEI_RANGES 1000 FILTER 4434588 SORT JOIN 1000 COLLECTION ITERATOR PICKLER FETCH ******************************************************************************** select user# from sys.user$ where name = 'OUTLN' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID USER$ 1 INDEX UNIQUE SCAN I_USER1 (object id 44) ******************************************************************************** select condition from cdef$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 4 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 4 0 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY USER ROWID CDEF$ ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 62 0.05 0.02 0 0 0 0 Execute 62 0.16 0.22 20 223 0 59 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 125 0.21 0.25 20 223 0 60 Misses in library cache during parse: 2 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 265 0.05 0.07 6 48 0 0 Execute 342 0.06 0.12 1 3 0 0 Fetch 6266 255.05 275.90 11109 14819 174 57488 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6873 255.16 276.09 11116 14870 174 57488 Misses in library cache during parse: 9 Misses in library cache during execute: 1 120 user SQL statements in session. 207 internal SQL statements in session. 327 SQL statements in session. ******************************************************************************** Trace file: mtms_ora_2021.trc Trace file compatibility: 9.02.00 Sort options: default 1 session in tracefile. 120 user SQL statements in trace file. 207 internal SQL statements in trace file. 327 SQL statements in trace file. 44 unique SQL statements in trace file. 9284 lines in trace file.