31 DBMS_AUTO_TASK_ADMIN
The DBMS_AUTO_TASK_ADMIN
package provides an interface to AUTOTASK
functionality. It is used by the DBA as well as Enterprise Manager to access the AUTOTASK
controls. Enterprise Manager also uses the AUTOTASK
Advisor.
See Also:
Oracle Database Administrator's Guide for more information about "Configuring Automated Maintenance Task"
31.1 DBMS_AUTO_TASK_ADMIN Deprecated Subprograms
The DBMS_AUTO_TASK_ADMIN OVERRIDE_PRIORITY subprogram has been deprecated.
Note:
Oracle recommends that you do not use deprecated procedures in new applications. Support for deprecated features is for backward compatibility only.
31.2 DBMS_AUTO_TASK_ADMIN Security Model
DBMS_AUTO_TASK_ADMIN
is a definer's rights package, and EXECUTE
is automatically granted to DBA
, IMP_FULL_DATABASE
and DATAPUMP_IMP_FULL_DATABASE
.
31.3 DBMS_AUTO_TASK_ADMIN Constants
The DBMS_AUTO_TASK_ADMIN
package defines several constants that can be used for specifying parameter values.
These constants shown in the following table:
Table 31-1 DBMS_AUTO_TASK_ADMIN Constants
Name | Type | Value | Description |
---|---|---|---|
|
|
|
Task with this priority should be executed as time permits |
|
|
|
Task with this priority should be executed within the current Maintenance Window |
|
|
|
Task with this priority is to be executed at the earliest opportunity |
31.4 Summary of DBMS_AUTO_TASK_ADMIN Subprograms
This table lists the DBMS_AUTO_TASK_ADMIN
subprograms and briefly describes them.
Table 31-2 DBMS_AUTO_TASK_ADMIN Package Subprograms
Method | Description |
---|---|
Prevents |
|
Allows a previously disabled client, operation, target type, or individual target to be enabled under |
|
Returns values of select client attributes |
|
Returns percent of resources allocated to each |
|
Manually overrides task priority. |
|
Associates an |
|
Sets percentage-based resource allocation for each High Priority Consumer Group used by |
31.4.1 DISABLE Procedures
This procedure prevents AUTOTASK
from executing any requests from a specified client or operation.
Syntax
Disables all AUTOTASK
functionality.
DBMS_AUTO_TASK_ADMIN.DISABLE;
Disables all tasks for the client or operation.
DBMS_AUTO_TASK_ADMIN.DISABLE ( client_name IN VARCHAR2, operation IN VARCHAR2, window_name IN VARCHAR2);
Parameters
Table 31-3 DISABLE Procedure Parameters
Parameter | Description |
---|---|
|
Name of the client, as found in |
|
Name of the operation as specified in |
|
Optional name of the window in which client is to be disabled |
Usage Notes
-
If
operation
andwindow_name
are bothNULL
, the client is disabled. -
If
operation
is notNULL
,window_name
is ignored and the operation is disabled -
If
operation
isNULL
andwindow_name
is notNULL
, the client is disabled in the specified window.
31.4.2 ENABLE Procedures
This procedure allows a previously disabled client, operation, target type, or individual target to be enabled under AUTOTASK
control.
Specifying the DEFERRED
option postpones the effect of the call until the start of the next maintenance window. If IMMEDIATE
option is specified the effect of this call is immediate – as long as there is a currently open maintenance window.
Syntax
Re-enabling AUTOTASK
. This version enables the specified client. Note that any explicitly disabled tasks or operations must be re-enabled individually.
DBMS_AUTO_TASK_ADMIN.ENABLE;
Re-enabling a client or operation.Note that any explicitly disabled tasks or operations must be re-enabled individually.
DBMS_AUTO_TASK_ADMIN.ENABLE ( client_name IN VARCHAR2, operation IN VARCHAR2, window_name IN VARCHAR2);
Parameters
Table 31-4 ENABLE Procedure Parameters
Parameter | Description |
---|---|
|
Name of the client, as found in |
|
Name of the operation as specified in |
|
Optional name of the window in which client is to be enabled |
Usage Notes
-
If
operation
andwindow_name
are bothNULL
, the client is enabled. -
If
operation
is notNULL
,window_name
is ignored and the specified operation is enabled -
If
operation
isNULL
andwindow_name
is notNULL
, the client is enabled in the specified window.
31.4.3 GET_CLIENT_ATTRIBUTES Procedure
This procedure returns values of select client attributes.
Syntax
DBMS_AUTO_TASK_ADMIN.GET_CLIENT_ATTRIBUTES( client_name IN VARCHAR2, service_name OUT VARCHAR2, window_group OUT VARCHAR2);
Parameters
Table 31-5 GET_CLIENT_ATTRIBUTES Procedure Parameters
Parameter | Description |
---|---|
|
Name of the client, as found in |
|
Service name for client, may be |
|
Name of the window group in which the client is active |
31.4.4 GET_P1_RESOURCES Procedure
This procedure returns percent of resources allocated to each AUTOTASK
High Priority Consumer Group.
Syntax
DBMS_AUTO_TASK_ADMIN.GET_P1_RESOURCES( stats_group_pct OUT NUMBER, seg_group_pct OUT NUMBER, tune_group_pct OUT NUMBER, health_group_pct OUT NUMBER);
Parameters
Table 31-6 GET_P1_RESOURCES Procedure Parameters
Parameter | Description |
---|---|
|
%resources for Statistics Gathering |
|
%resources for Space Management |
|
%resources for SQL Tuning |
|
%resources for Health Checks |
Usage Notes
Values will add up to 100%.
31.4.5 OVERRIDE_PRIORITY Procedures
This deprecated procedure is used to manually override task priority.
Note:
This subprogram is deprecated and becomes nonoperative with Oracle Database 12c.
This can be done at the client, operation or individual task level. This priority assignment is honored during the next maintenance window in which the named client is active. Specifically, setting the priority to URGENT
causes a high priority job to be generated at the start of the maintenance window. Setting priority
to CLEAR
removes the override.
Syntax
Override Priority for a Client.
DBMS_AUTO_TASK_ADMIN.OVERRIDE_PRIORITY ( client_name IN VARCHAR2, priority IN VARCHAR2);
Override Priority for an Operation.
DBMS_AUTO_TASK_ADMIN.OVERRIDE_PRIORITY ( client_name IN VARCHAR2, operation IN VARCHAR2, priority IN VARCHAR2);
Override Priority for a Task.
DBMS_AUTO_TASK_ADMIN.OVERRIDE_PRIORITY ( client_name IN VARCHAR2, operation IN VARCHAR2, task_target_type IN VARCHAR2, task_target_name IN VARCHAR2, priority IN VARCHAR2);
Parameters
Table 31-7 OVERRIDE_PRIORITY Procedure Parameters
Parameter | Description |
---|---|
|
Name of the client, as found in |
|
|
|
Name of the operation as specified in |
|
Type of target to be affected, as found in V$ |
|
Name of the specific target to be affected |
31.4.6 SET_CLIENT_SERVICE Procedure
This procedure associates an AUTOTASK
Client with a specified Service.
Syntax
DBMS_AUTO_TASK_ADMIN.SET_CLIENT_SERVICE( client_name IN VARCHAR2, service_name IN VARCHAR2);
Parameters
Table 31-8 SET_CLIENT_SERVICE Procedure Parameters
Parameter | Description |
---|---|
|
Name of the client, as found in |
|
Service name for client, may be |
Usage Notes
All work performed on behalf of the Client takes place only on instances where the service is enabled.
31.4.7 SET_P1_RESOURCES Procedure
This procedure sets percentage-based resource allocation for each High Priority Consumer Group used by AUTOTASK
Clients.
Syntax
DBMS_AUTO_TASK_ADMIN.SET_P1_RESOURCES( stats_group_pct OUT NUMBER, seg_group_pct OUT NUMBER, tune_group_pct OUT NUMBER, health_group_pct OUT NUMBER);
Parameters
Table 31-9 SET_P1_RESOURCES Procedure Parameters
Parameter | Description |
---|---|
|
%resources for Statistics Gathering |
|
%resources for Space Management |
|
%resources for SQL Tuning |
|
%resources for Health Checks |
Usage Notes
Values must be integers in the range 0 to 100, and must add up to 100 (percent), otherwise, an exception is raised.