APPS.HR_TKPROF_PLUS dependencies on DBA_INDEXES

Line 115: 'FROM '||g_explain_table||' pt, dba_indexes di '||

111: -- open the dynamic cursor
112: OPEN l_cursor FOR
113: 'SELECT di.table_owner table_owner, '||
114: 'di.table_name table_name '||
115: 'FROM '||g_explain_table||' pt, dba_indexes di '||
116: 'WHERE pt.statement_id LIKE ''exp%'' '||
117: 'AND pt.object_owner NOT IN (''SYS'',''SYSTEM'') '||
118: 'AND pt.object_type IN (''UNIQUE'',''NON-UNIQUE'') '||
119: 'AND di.index_name = pt.object_name '||

Line 585: FROM dba_indexes di

581: TO_CHAR(di.blevel,999999) bl,
582: TO_CHAR(di.last_analyzed, 'DD/MM/YYYY HH24:MI:SS') la,
583: di.avg_leaf_blocks_per_key albpk,
584: di.avg_data_blocks_per_key adbpk
585: FROM dba_indexes di
586: WHERE di.table_name = c_table_name
587: AND di.table_owner = c_owner
588: AND di.owner = c_owner
589: AND di.num_rows > 0

Line 598: dba_indexes i

594: i.uniqueness uniqueness,
595: SUBSTR(c.column_name,1,30) column_name,
596: c.column_position column_position
597: FROM dba_ind_columns c,
598: dba_indexes i
599: WHERE i.table_name = c_table_name
600: AND i.table_owner = c_owner
601: AND i.owner = c_owner
602: AND c.index_name = i.index_name