Databases Reference
In-Depth Information
Procedures
The most relevant procedures are:
F
ANALYZE_DB
: creates an ADDM task to analyze the database and execute it
F
ANALYZE_INST
: creates an ADDM task for analyzing in instance analysis mode
and executes it
F
GET_REPORT
: retrieves the default text report of an executed ADDM task
DBMS_ADVISOR
This package helps in managing the Advisors, a set of expert systems that identify and
help resolve performance problems related to various database server components.
Procedures
The most relevant procedures are:
F
SET_DEFAULT_TASK_PARAMETER
: sets the default values for task parameters
F
QUICK_TUNE
: performs an analysis on a single SQL statement
F
EXECUTE_TASK
: executes the specified task
DBMS_JOB
Schedules and manages jobs in the database job queue.
Oracle recommends using the
DBMS_SCHEDULER
package.
Procedures
The most relevant procedures are:
F
SUBMIT
: submits a new job to the job queue
F
RUN
: forces a specified job to run
F
NEXT_DATE
: alters the next execution time for a specified job
F
BROKEN
: deletes a job execution
F
REMOVE
: removes the specified job from the job queue