eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

SYS.DBMS_FEATURE_SPD dependencies on DBA_SQL_PLAN_DIRECTIVES

Line 16: select reason c1, count(*) c2 from dba_sql_plan_directives group by reason;

12: num_dir_obj NUMBER;
13: num_dir_subobj NUMBER;
14: tmp_buf VARCHAR2(32767);
15: CURSOR spd_reason_cursor IS
16: select reason c1, count(*) c2 from dba_sql_plan_directives group by reason;
17: CURSOR spd_state_cursor IS
18: select state c1, count(*) c2 from dba_sql_plan_directives group by state;
19: CURSOR spd_type_cursor IS
20: select type c1, count(*) c2 from dba_sql_plan_directives group by type;

Line 18: select state c1, count(*) c2 from dba_sql_plan_directives group by state;

14: tmp_buf VARCHAR2(32767);
15: CURSOR spd_reason_cursor IS
16: select reason c1, count(*) c2 from dba_sql_plan_directives group by reason;
17: CURSOR spd_state_cursor IS
18: select state c1, count(*) c2 from dba_sql_plan_directives group by state;
19: CURSOR spd_type_cursor IS
20: select type c1, count(*) c2 from dba_sql_plan_directives group by type;
21: BEGIN
22: -- get total number of rows in dba_sql_plan_directives

Line 20: select type c1, count(*) c2 from dba_sql_plan_directives group by type;

16: select reason c1, count(*) c2 from dba_sql_plan_directives group by reason;
17: CURSOR spd_state_cursor IS
18: select state c1, count(*) c2 from dba_sql_plan_directives group by state;
19: CURSOR spd_type_cursor IS
20: select type c1, count(*) c2 from dba_sql_plan_directives group by type;
21: BEGIN
22: -- get total number of rows in dba_sql_plan_directives
23: SELECT count(*)
24: INTO num_dirs

Line 22: -- get total number of rows in dba_sql_plan_directives

18: select state c1, count(*) c2 from dba_sql_plan_directives group by state;
19: CURSOR spd_type_cursor IS
20: select type c1, count(*) c2 from dba_sql_plan_directives group by type;
21: BEGIN
22: -- get total number of rows in dba_sql_plan_directives
23: SELECT count(*)
24: INTO num_dirs
25: FROM dba_sql_plan_directives;
26:

Line 25: FROM dba_sql_plan_directives;

21: BEGIN
22: -- get total number of rows in dba_sql_plan_directives
23: SELECT count(*)
24: INTO num_dirs
25: FROM dba_sql_plan_directives;
26:
27: dbms_lob.createtemporary(feature_info, TRUE);
28:
29: -- # of directives with each type