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_AUTO_SQLTUNE dependencies on DBMS_SQLTUNE

Line 6: TYPE_TEXT CONSTANT VARCHAR2(4) := dbms_sqltune.TYPE_TEXT;

2:
3: --
4: -- report type (possible values) constants
5: --
6: TYPE_TEXT CONSTANT VARCHAR2(4) := dbms_sqltune.TYPE_TEXT;
7: TYPE_XML CONSTANT VARCHAR2(3) := dbms_sqltune.TYPE_XML;
8: TYPE_HTML CONSTANT VARCHAR2(4) := dbms_sqltune.TYPE_HTML;
9:
10: --

Line 7: TYPE_XML CONSTANT VARCHAR2(3) := dbms_sqltune.TYPE_XML;

3: --
4: -- report type (possible values) constants
5: --
6: TYPE_TEXT CONSTANT VARCHAR2(4) := dbms_sqltune.TYPE_TEXT;
7: TYPE_XML CONSTANT VARCHAR2(3) := dbms_sqltune.TYPE_XML;
8: TYPE_HTML CONSTANT VARCHAR2(4) := dbms_sqltune.TYPE_HTML;
9:
10: --
11: -- report level (possible values) constants

Line 8: TYPE_HTML CONSTANT VARCHAR2(4) := dbms_sqltune.TYPE_HTML;

4: -- report type (possible values) constants
5: --
6: TYPE_TEXT CONSTANT VARCHAR2(4) := dbms_sqltune.TYPE_TEXT;
7: TYPE_XML CONSTANT VARCHAR2(3) := dbms_sqltune.TYPE_XML;
8: TYPE_HTML CONSTANT VARCHAR2(4) := dbms_sqltune.TYPE_HTML;
9:
10: --
11: -- report level (possible values) constants
12: --

Line 13: LEVEL_TYPICAL CONSTANT VARCHAR2(7) := dbms_sqltune.LEVEL_TYPICAL;

9:
10: --
11: -- report level (possible values) constants
12: --
13: LEVEL_TYPICAL CONSTANT VARCHAR2(7) := dbms_sqltune.LEVEL_TYPICAL;
14: LEVEL_BASIC CONSTANT VARCHAR2(5) := dbms_sqltune.LEVEL_BASIC;
15: LEVEL_ALL CONSTANT VARCHAR2(3) := dbms_sqltune.LEVEL_ALL;
16:
17: --

Line 14: LEVEL_BASIC CONSTANT VARCHAR2(5) := dbms_sqltune.LEVEL_BASIC;

10: --
11: -- report level (possible values) constants
12: --
13: LEVEL_TYPICAL CONSTANT VARCHAR2(7) := dbms_sqltune.LEVEL_TYPICAL;
14: LEVEL_BASIC CONSTANT VARCHAR2(5) := dbms_sqltune.LEVEL_BASIC;
15: LEVEL_ALL CONSTANT VARCHAR2(3) := dbms_sqltune.LEVEL_ALL;
16:
17: --
18: -- report section (possible values) constants

Line 15: LEVEL_ALL CONSTANT VARCHAR2(3) := dbms_sqltune.LEVEL_ALL;

11: -- report level (possible values) constants
12: --
13: LEVEL_TYPICAL CONSTANT VARCHAR2(7) := dbms_sqltune.LEVEL_TYPICAL;
14: LEVEL_BASIC CONSTANT VARCHAR2(5) := dbms_sqltune.LEVEL_BASIC;
15: LEVEL_ALL CONSTANT VARCHAR2(3) := dbms_sqltune.LEVEL_ALL;
16:
17: --
18: -- report section (possible values) constants
19: --

Line 20: SECTION_FINDINGS CONSTANT VARCHAR2(8) := dbms_sqltune.SECTION_FINDINGS;

16:
17: --
18: -- report section (possible values) constants
19: --
20: SECTION_FINDINGS CONSTANT VARCHAR2(8) := dbms_sqltune.SECTION_FINDINGS;
21: SECTION_PLANS CONSTANT VARCHAR2(5) := dbms_sqltune.SECTION_PLANS;
22: SECTION_INFORMATION CONSTANT VARCHAR2(11):=
23: dbms_sqltune.SECTION_INFORMATION;
24: SECTION_ERRORS CONSTANT VARCHAR2(6) := dbms_sqltune.SECTION_ERRORS;

Line 21: SECTION_PLANS CONSTANT VARCHAR2(5) := dbms_sqltune.SECTION_PLANS;

17: --
18: -- report section (possible values) constants
19: --
20: SECTION_FINDINGS CONSTANT VARCHAR2(8) := dbms_sqltune.SECTION_FINDINGS;
21: SECTION_PLANS CONSTANT VARCHAR2(5) := dbms_sqltune.SECTION_PLANS;
22: SECTION_INFORMATION CONSTANT VARCHAR2(11):=
23: dbms_sqltune.SECTION_INFORMATION;
24: SECTION_ERRORS CONSTANT VARCHAR2(6) := dbms_sqltune.SECTION_ERRORS;
25: SECTION_ALL CONSTANT VARCHAR2(3) := dbms_sqltune.SECTION_ALL;

Line 23: dbms_sqltune.SECTION_INFORMATION;

19: --
20: SECTION_FINDINGS CONSTANT VARCHAR2(8) := dbms_sqltune.SECTION_FINDINGS;
21: SECTION_PLANS CONSTANT VARCHAR2(5) := dbms_sqltune.SECTION_PLANS;
22: SECTION_INFORMATION CONSTANT VARCHAR2(11):=
23: dbms_sqltune.SECTION_INFORMATION;
24: SECTION_ERRORS CONSTANT VARCHAR2(6) := dbms_sqltune.SECTION_ERRORS;
25: SECTION_ALL CONSTANT VARCHAR2(3) := dbms_sqltune.SECTION_ALL;
26: SECTION_SUMMARY CONSTANT VARCHAR2(7) := dbms_sqltune.SECTION_SUMMARY;
27:

Line 24: SECTION_ERRORS CONSTANT VARCHAR2(6) := dbms_sqltune.SECTION_ERRORS;

20: SECTION_FINDINGS CONSTANT VARCHAR2(8) := dbms_sqltune.SECTION_FINDINGS;
21: SECTION_PLANS CONSTANT VARCHAR2(5) := dbms_sqltune.SECTION_PLANS;
22: SECTION_INFORMATION CONSTANT VARCHAR2(11):=
23: dbms_sqltune.SECTION_INFORMATION;
24: SECTION_ERRORS CONSTANT VARCHAR2(6) := dbms_sqltune.SECTION_ERRORS;
25: SECTION_ALL CONSTANT VARCHAR2(3) := dbms_sqltune.SECTION_ALL;
26: SECTION_SUMMARY CONSTANT VARCHAR2(7) := dbms_sqltune.SECTION_SUMMARY;
27:
28:

Line 25: SECTION_ALL CONSTANT VARCHAR2(3) := dbms_sqltune.SECTION_ALL;

21: SECTION_PLANS CONSTANT VARCHAR2(5) := dbms_sqltune.SECTION_PLANS;
22: SECTION_INFORMATION CONSTANT VARCHAR2(11):=
23: dbms_sqltune.SECTION_INFORMATION;
24: SECTION_ERRORS CONSTANT VARCHAR2(6) := dbms_sqltune.SECTION_ERRORS;
25: SECTION_ALL CONSTANT VARCHAR2(3) := dbms_sqltune.SECTION_ALL;
26: SECTION_SUMMARY CONSTANT VARCHAR2(7) := dbms_sqltune.SECTION_SUMMARY;
27:
28:
29: --------------------------- execute_auto_tuning_task ------------------------

Line 26: SECTION_SUMMARY CONSTANT VARCHAR2(7) := dbms_sqltune.SECTION_SUMMARY;

22: SECTION_INFORMATION CONSTANT VARCHAR2(11):=
23: dbms_sqltune.SECTION_INFORMATION;
24: SECTION_ERRORS CONSTANT VARCHAR2(6) := dbms_sqltune.SECTION_ERRORS;
25: SECTION_ALL CONSTANT VARCHAR2(3) := dbms_sqltune.SECTION_ALL;
26: SECTION_SUMMARY CONSTANT VARCHAR2(7) := dbms_sqltune.SECTION_SUMMARY;
27:
28:
29: --------------------------- execute_auto_tuning_task ------------------------
30: -- NAME:

Line 76: -- on. NOTE that this API also exists in the DBMS_SQLTUNE package so

72: --
73: -- DESCRIPTION:
74: -- Get a report from the automatic tuning task. This differs from the
75: -- report_tuning_task API in that it takes a range of subtasks to report
76: -- on. NOTE that this API also exists in the DBMS_SQLTUNE package so
77: -- all users with access to the views can see a report.
78: --
79: -- PARAMETERS:
80: -- begin_exec (IN) - name of execution to begin the report from. Null

Line 135: -- using dbms_sqltune.set_tuning_task_parameter only SYS can set them.

131: -- DESCRIPTION:
132: -- Similar to set_tuning_task_parameter, but used for the reserved auto
133: -- tuning task. Using this API any user with ADVISOR privilege and
134: -- EXECUTE on this package can set the auto tuning task parameters;
135: -- using dbms_sqltune.set_tuning_task_parameter only SYS can set them.
136: --
137: -- For a description of the parameters that can be set using this API,
138: -- see the comments for dbms_sqltune.set_tuning_task_parameter.
139: --

Line 138: -- see the comments for dbms_sqltune.set_tuning_task_parameter.

134: -- EXECUTE on this package can set the auto tuning task parameters;
135: -- using dbms_sqltune.set_tuning_task_parameter only SYS can set them.
136: --
137: -- For a description of the parameters that can be set using this API,
138: -- see the comments for dbms_sqltune.set_tuning_task_parameter.
139: --
140: -- PARAMETERS:
141: -- parameter (IN) - name of the parameter to set
142: -- value (IN) - new value of the specified parameter

Line 163: -- using dbms_sqltune.set_tuning_task_parameter only SYS can set them.

159: -- DESCRIPTION:
160: -- Similar to set_tuning_task_parameter, but used for the reserved auto
161: -- tuning task. Using this API any user with ADVISOR privilege and
162: -- EXECUTE on this package can set the auto tuning task parameters;
163: -- using dbms_sqltune.set_tuning_task_parameter only SYS can set them.
164: --
165: -- For a description of the parameters that can be set using this API,
166: -- see the comments for dbms_sqltune.set_tuning_task_parameter.
167: --

Line 166: -- see the comments for dbms_sqltune.set_tuning_task_parameter.

162: -- EXECUTE on this package can set the auto tuning task parameters;
163: -- using dbms_sqltune.set_tuning_task_parameter only SYS can set them.
164: --
165: -- For a description of the parameters that can be set using this API,
166: -- see the comments for dbms_sqltune.set_tuning_task_parameter.
167: --
168: -- PARAMETERS:
169: -- parameter (IN) - name of the parameter to set
170: -- value (IN) - new value of the specified parameter