 |
|
DBMS_ADDM package tips
Oracle Tips by Burleson Consulting |
DBMS_ADDM
<< Return to the index
Oracle 11g provides the following information about the DBMS_ADDM package:
Description of the DBMS_ADDM package:
PROCEDURE DBMS_ADDM.ANALYZE_DB
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TASK_NAME VARCHAR2 IN/OUT
BEGIN_SNAPSHOT NUMBER IN
END_SNAPSHOT NUMBER IN
DB_ID NUMBER IN DEFAULT
PROCEDURE DBMS_ADDM.ANALYZE_INST
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TASK_NAME VARCHAR2 IN/OUT
BEGIN_SNAPSHOT NUMBER IN
END_SNAPSHOT NUMBER IN
INSTANCE_NUMBER NUMBER IN DEFAULT
DB_ID NUMBER IN DEFAULT
PROCEDURE DBMS_ADDM.ANALYZE_PARTIAL
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TASK_NAME VARCHAR2 IN/OUT
INSTANCE_NUMBERS VARCHAR2 IN
BEGIN_SNAPSHOT NUMBER IN
END_SNAPSHOT NUMBER IN
DB_ID NUMBER IN DEFAULT
PROCEDURE DBMS_ADDM.DELETE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TASK_NAME VARCHAR2 IN
PROCEDURE DBMS_ADDM.DELETE_FINDING_DIRECTIVE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TASK_NAME VARCHAR2 IN
DIR_NAME VARCHAR2 IN
PROCEDURE DBMS_ADDM.DELETE_PARAMETER_DIRECTIVE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TASK_NAME VARCHAR2 IN
DIR_NAME VARCHAR2 IN
PROCEDURE DBMS_ADDM.DELETE_SEGMENT_DIRECTIVE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TASK_NAME VARCHAR2 IN
DIR_NAME VARCHAR2 IN
PROCEDURE DBMS_ADDM.DELETE_SQL_DIRECTIVE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TASK_NAME VARCHAR2 IN
DIR_NAME VARCHAR2 IN
FUNCTION DBMS_ADDM.GET_REPORT RETURNS CLOB
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TASK_NAME VARCHAR2 IN
PROCEDURE DBMS_ADDM.INSERT_FINDING_DIRECTIVE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TASK_NAME VARCHAR2 IN
DIR_NAME VARCHAR2 IN
FINDING_NAME VARCHAR2 IN
MIN_ACTIVE_SESSIONS NUMBER IN DEFAULT
MIN_PERC_IMPACT NUMBER IN DEFAULT
PROCEDURE DBMS_ADDM.INSERT_PARAMETER_DIRECTIVE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TASK_NAME VARCHAR2 IN
DIR_NAME VARCHAR2 IN
PARAMETER_NAME VARCHAR2 IN
PROCEDURE DBMS_ADDM.INSERT_SEGMENT_DIRECTIVE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TASK_NAME VARCHAR2 IN
DIR_NAME VARCHAR2 IN
OWNER_NAME VARCHAR2 IN
OBJECT_NAME VARCHAR2 IN DEFAULT
SUB_OBJECT_NAME VARCHAR2 IN DEFAULT
PROCEDURE DBMS_ADDM.INSERT_SEGMENT_DIRECTIVE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TASK_NAME VARCHAR2 IN
DIR_NAME VARCHAR2 IN
OBJECT_NUMBER NUMBER IN
PROCEDURE DBMS_ADDM.INSERT_SQL_DIRECTIVE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TASK_NAME VARCHAR2 IN
DIR_NAME VARCHAR2 IN
SQL_ID VARCHAR2 IN
MIN_ACTIVE_SESSIONS NUMBER IN DEFAULT
MIN_RESPONSE_TIME NUMBER IN DEFAULT
 |
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
 |
 |
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
