TKPROF: Release 10.1.0.3.0 - Production on Fri Apr 30 06:44:26 2010 Copyright (c) 1982, 2004, Oracle. All rights reserved. Trace file: C:\Orant\Ora103\admin\qdms\Udump\qdms_ora_3304.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 TO_CHAR(A.ID) A118,A.ASSET_GROUP_XID A2,A.ACL_ID A106,A.OWNER A4,CONVERT(A.NAME,:"SYS_B_00") A1,A.FIRST_VERSION_CREATED_BY A15,LPAD(LTRIM(TO_CHAR(A.FIRST_VERSION_DATE_CREATED,:"SYS_B_01")),:"SYS_B_02",:"SYS_B_03") A16,LPAD(LTRIM(TO_CHAR(A.DATE_CREATED,:"SYS_B_04")),:"SYS_B_05",:"SYS_B_06") A18,CONVERT(A.CHECKOUT_LOCATION,:"SYS_B_07") A24,TO_CHAR(A.ASSET_SIZE) A7,A.CHECKED_OUT_BY A23,A.ARCHIVE_STATUS A27,A.STORAGE_CHANGE_REQUEST A110,A.HAS_HISTORY A74,TO_CHAR(A.CONTAINED_IN_COUNT) A73,TO_CHAR(A.CONTAINER_OF_COUNT) A72,TO_CHAR(A.RELATED_WITH_COUNT) A71,CONVERT(A.FILE_TYPE,:"SYS_B_08") A12,CONVERT(A.FILE_CREATOR_APPLICATION,:"SYS_B_09") A13,CONVERT(A.FILE_EXTENSION,:"SYS_B_10") A9,TO_CHAR(A.REVISION) A21,A.IS_CURRENT_VERSION A109,TO_CHAR(A.FAMILY_ID) A112,LPAD(LTRIM(TO_CHAR(A.FILE_DATE_CREATED,:"SYS_B_11")),:"SYS_B_12",:"SYS_B_13") A11,LPAD(LTRIM(TO_CHAR(A.FILE_DATE_LAST_MODIFIED,:"SYS_B_14")),:"SYS_B_15",:"SYS_B_16") A10 FROM MAM_ASSETS A WHERE ((A.ACL_ID=:"SYS_B_17") AND (A.ASSET_GROUP_XID=:"SYS_B_18") AND (A.IS_CURRENT_VERSION=:"SYS_B_19") AND A.ID IN ( SELECT A.ID ASSET_ID FROM MAM_ASSETS A WHERE (A.ID IN (SELECT SV65539.ID FROM MAM_ATTR_STRING_VALUES SV65539 WHERE (SV65539.LOWER_CASE_STRING_VALUE LIKE LOWER(CONVERT(:"SYS_B_20",:"SYS_B_21",:"SYS_B_22"))) AND (SV65539.ATTRIBUTE_XID=:"SYS_B_23"))) ) ) ORDER BY A.ASSET_SIZE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.06 0.62 0 0 0 0 Fetch 2 29100.10 1464.02 6159 217972192 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 29100.17 1464.64 6159 217972192 0 4 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 24 ******************************************************************************** select condition from cdef$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 14 0.01 0.00 0 0 0 0 Execute 14 0.00 0.00 0 0 0 0 Fetch 14 0.00 0.00 0 28 0 14 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 42 0.01 0.00 0 28 0 14 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 ------- --------------------------------------------------- 0 TABLE ACCESS BY USER ROWID CDEF$ (cr=0 pr=0 pw=0 time=0 us) ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.06 0.62 0 0 0 0 Fetch 2 29100.10 1464.02 6159 217972192 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 29100.17 1464.64 6159 217972192 0 4 Misses in library cache during parse: 1 Misses in library cache during execute: 1 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 14 0.01 0.00 0 0 0 0 Execute 14 0.00 0.00 0 0 0 0 Fetch 14 0.00 0.00 0 28 0 14 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 42 0.01 0.00 0 28 0 14 Misses in library cache during parse: 1 Misses in library cache during execute: 1 1 user SQL statements in session. 14 internal SQL statements in session. 15 SQL statements in session. ******************************************************************************** Trace file: C:\Orant\Ora103\admin\qdms\Udump\qdms_ora_3304.trc Trace file compatibility: 10.01.00 Sort options: default 1 session in tracefile. 1 user SQL statements in trace file. 14 internal SQL statements in trace file. 15 SQL statements in trace file. 2 unique SQL statements in trace file. 146 lines in trace file. 1465 elapsed seconds in trace file.