SQL> select instance_name, host_name from v$instance; INSTANCE_NAME HOST_NAME ---------------- ---------------------------------------------------------------- qdms BRIQDMS1 Elapsed: 00:00:00.25 SQL> drop table PLAN_TABLE; drop table PLAN_TABLE * ERROR at line 1: ORA-00942: table or view does not exist Elapsed: 00:00:00.09 SQL> @D:\oracle\product\10.1.0\Db_1\RDBMS\ADMIN\utlxplan.sql SP2-0310: unable to open file "D:\oracle\product\10.1.0\Db_1\RDBMS\ADMIN\utlxplan.sql" SQL> alter session set timed_statistics = true; Session altered. Elapsed: 00:00:00.03 SQL> alter session set sql_trace = true; Session altered. Elapsed: 00:00:00.12 SQL> set autotrace on explain SQL> alter session set events '10046 trace name context forever, level 12'; Session altered. Elapsed: 00:00:00.09 SQL> SELECT TO_CHAR(A.ID) A118,A.ASSET_GROUP_XID A2,A.ACL_ID A106,A.OWNER A4,CONVERT(A.NAME,'WE8MACROMAN8') A1, 2 A.FIRST_VERSION_CREATED_BY A15,LPAD(LTRIM(TO_CHAR(A.FIRST_VERSION_DATE_CREATED,'SYYYYMMDDHH24MISS')),15,'+') A16, 3 LPAD(LTRIM(TO_CHAR(A.DATE_CREATED,'SYYYYMMDDHH24MISS')),15,'+') A18,CONVERT(A.CHECKOUT_LOCATION,'WE8MACROMAN8') A24, 4 TO_CHAR(A.ASSET_SIZE) A7,A.CHECKED_OUT_BY A23,A.ARCHIVE_STATUS A27,A.STORAGE_CHANGE_REQUEST A110,A.HAS_HISTORY A74, 5 TO_CHAR(A.CONTAINED_IN_COUNT) A73,TO_CHAR(A.CONTAINER_OF_COUNT) A72,TO_CHAR(A.RELATED_WITH_COUNT) A71, 6 CONVERT(A.FILE_TYPE,'WE8MACROMAN8') A12,CONVERT(A.FILE_CREATOR_APPLICATION,'WE8MACROMAN8') A13, 7 CONVERT(A.FILE_EXTENSION,'WE8MACROMAN8') A9,TO_CHAR(A.REVISION) A21,A.IS_CURRENT_VERSION A109, 8 TO_CHAR(A.FAMILY_ID) A112,LPAD(LTRIM(TO_CHAR(A.FILE_DATE_CREATED,'SYYYYMMDDHH24MISS')),15,'+') A11, 9 LPAD(LTRIM(TO_CHAR(A.FILE_DATE_LAST_MODIFIED,'SYYYYMMDDHH24MISS')),15,'+') A10 10 FROM MAM_ASSETS A 11 WHERE ((A.ACL_ID=65536) AND 12 (A.ASSET_GROUP_XID=120) AND 13 (A.IS_CURRENT_VERSION=1) AND 14 A.ID IN ( SELECT A.ID ASSET_ID FROM MAM_ASSETS A 15 WHERE (A.ID IN (SELECT SV65539.ID FROM MAM_ATTR_STRING_VALUES SV65539 16 WHERE (SV65539.LOWER_CASE_STRING_VALUE LIKE LOWER(CONVERT('%813982%','WE8MSWIN1252','WE8MACROMAN8'))) 17 AND (SV65539.ATTRIBUTE_XID=65539))) ) ) ORDER BY A.ASSET_SIZE; A118 A2 A106 A4 ---------------------------------------- ---------- ---------- ---------- A1 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ A15 ---------- A16 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ A18 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ A24 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ A7 A23 A27 A110 A74 A73 A72 A71 ---------------------------------------- ---------- ---------- ---------- ---------- ---------------------------------------- ---------------------------------------- ---------------------------------------- A12 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ A13 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ A9 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ A21 A109 A112 ---------------------------------------- ---------- ---------------------------------------- A11 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ A10 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 1910068 120 65536 65711 LT-7.1-Friendly Encounter 65711 +20100309161713 +20100423151829 162816 1 4 1 2 3 0 XPRJ XPR3 5 1 1884405 +20100423191414 +20100423191414 1908094 120 65536 65642 RA-Friendly Encounter 65642 +20100212143853 +20100421144630 196608 1 4 1 2 2 0 XPRJ XPR3 5 1 1874580 +20100421183529 +20100421183529 1910072 120 65536 65642 Sell Sheet-Friendly Encounter 65642 +20100212143757 +20100423151843 61604864 1 4 1 3 3 0 XPRJ XPR3 10 1 1874575 +20100423191522 +20100423191524 1910063 120 65536 65642 1-2 pg. Friendly Encounter 65642 +20100212143835 +20100423151826 61685760 1 4 1 2 4 0 XPRJ XPR3 14 1 1874577 +20100423191754 +20100423191755 Elapsed: 08:11:19.28 Execution Plan ---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=1118 Card=86 Bytes=1 5738) 1 0 SORT (ORDER BY) (Cost=1118 Card=86 Bytes=15738) 2 1 NESTED LOOPS (Cost=1107 Card=86 Bytes=15738) 3 2 NESTED LOOPS (Cost=1088 Card=918 Bytes=44064) 4 3 SORT (UNIQUE) (Cost=1072 Card=918 Bytes=38556) 5 4 TABLE ACCESS (BY INDEX ROWID) OF 'MAM_ATTR_STRING_ VALUES' (TABLE) (Cost=1072 Card=918 Bytes=38556) 6 5 INDEX (RANGE SCAN) OF 'ATRVALSTR_ATRDEF_FK_I' (I NDEX) (Cost=819 Card=367018) 7 3 INDEX (UNIQUE SCAN) OF 'AST_PK' (INDEX (UNIQUE)) 8 2 TABLE ACCESS (BY INDEX ROWID) OF 'MAM_ASSETS' (TABLE) (Cost=1 Card=1 Bytes=135) 9 8 INDEX (UNIQUE SCAN) OF 'AST_PK' (INDEX (UNIQUE)) SQL> alter session set sql_trace = false; Session altered. Elapsed: 00:00:00.00 SQL> alter session set timed_statistics = false; Session altered. Elapsed: 00:00:00.01 SQL> spool off