DBA Data[Home] [Help] [Dependency Information]

TYPE: SYS.WRI$_ADV_SQLTUNE

Object Details
Object Name: WRI$_ADV_SQLTUNE
Object Type: TYPE
Owner: SYS
Subobject Name: $VSN_1
Status: VALID
Object Details
Object Name: WRI$_ADV_SQLTUNE
Object Type: TYPE
Owner: SYS
Subobject Name:
Status: VALID
Type Details
Type Code: OBJECT
Predefined: NO
Incomplete: NO
Attributes
Name Datatype Length Prcn
ADVISOR_ID NUMBER

Methods
Name Parameters Result
SUB_CREATE SELF(WRI$_ADV_ABSTRACT_T)
TASK_ID(NUMBER)
FROM_TASK_ID(NUMBER)
SUB_EXECUTE SELF(WRI$_ADV_ABSTRACT_T)
TASK_ID(NUMBER)
ERR_NUM(NUMBER)
SUB_RESET SELF(WRI$_ADV_ABSTRACT_T)
TASK_ID(NUMBER)
SUB_DELETE SELF(WRI$_ADV_ABSTRACT_T)
TASK_ID(NUMBER)
SUB_PARAM_VALIDATE SELF(WRI$_ADV_ABSTRACT_T)
TASK_ID(NUMBER)
NAME(VARCHAR2)
VALUE(VARCHAR2)
SUB_GET_SCRIPT SELF(WRI$_ADV_ABSTRACT_T)
TASK_ID(NUMBER)
TYPE(VARCHAR2)
BUFFER(CLOB)
REC_ID(NUMBER)
ACT_ID(NUMBER)
SUB_GET_REPORT SELF(WRI$_ADV_ABSTRACT_T)
TASK_ID(NUMBER)
TYPE(VARCHAR2)
LEVEL(VARCHAR2)
SECTION(VARCHAR2)
BUFFER(CLOB)
SUB_VALIDATE_DIRECTIVE SELF(WRI$_ADV_ABSTRACT_T)
TASK_ID(NUMBER)
COMMAND_ID(NUMBER)
ATTR1(VARCHAR2)
ATTR2(VARCHAR2)
ATTR3(VARCHAR2)
ATTR4(VARCHAR2)
ATTR5(VARCHAR2)
SUB_UPDATE_REC_ATTR SELF(WRI$_ADV_ABSTRACT_T)
TASK_ID(NUMBER)
REC_ID(NUMBER)
ACT_ID(NUMBER)
NAME(VARCHAR2)
VALUE(VARCHAR2)
SUB_GET_REC_ATTR SELF(WRI$_ADV_ABSTRACT_T)
TASK_ID(NUMBER)
REC_ID(NUMBER)
ACT_ID(NUMBER)
NAME(VARCHAR2)
VALUE(VARCHAR2)
SUB_CLEANUP SELF(WRI$_ADV_ABSTRACT_T)
TASK_ID(NUMBER)
SUB_IMPLEMENT SELF(WRI$_ADV_ABSTRACT_T)
TASK_ID(NUMBER)
SUB_IMPLEMENT SELF(WRI$_ADV_ABSTRACT_T)
TASK_ID(NUMBER)
REC_ID(NUMBER)
EXIT_ON_ERROR(NUMBER)
SUB_USER_SETUP SELF(WRI$_ADV_ABSTRACT_T)
ADV_ID(NUMBER)
SUB_IMPORT_DIRECTIVES SELF(WRI$_ADV_ABSTRACT_T)
TASK_ID(NUMBER)
FROM_ID(NUMBER)
IMPORT_MODE(VARCHAR2)
ACCEPTED(NUMBER)
REJECTED(NUMBER)
SUB_QUICK_TUNE SELF(WRI$_ADV_ABSTRACT_T)
TASK_NAME(VARCHAR2)
ATTR_CLOB(CLOB)
ATTR_VC(VARCHAR2)
ATTR_NUM(NUMBER)
TEMPLATE(VARCHAR2)
IMPLEMENT(PL/SQL BOOLEAN)
SUB_RESUME SELF(WRI$_ADV_ABSTRACT_T)
TASK_ID(NUMBER)
ERR_NUM(NUMBER)
SUB_GET_SCRIPT SELF(WRI$_ADV_ABSTRACT_T)
TASK_ID(NUMBER)
TYPE(VARCHAR2)
BUFFER(CLOB)
REC_ID(NUMBER)
ACT_ID(NUMBER)
EXECUTION_NAME(VARCHAR2)
OBJECT_ID(NUMBER)
SUB_GET_REPORT SELF(WRI$_ADV_ABSTRACT_T)
TASK_ID(NUMBER)
TYPE(VARCHAR2)
LEVEL(VARCHAR2)
SECTION(VARCHAR2)
BUFFER(CLOB)
EXECUTION_NAME(VARCHAR2)
OBJECT_ID(NUMBER)
SUB_DELETE_EXECUTION SELF(WRI$_ADV_ABSTRACT_T)
TASK_ID(NUMBER)
EXECUTION_NAME(VARCHAR2)
SUB_EXECUTE SELF(WRI$_ADV_SQLTUNE)
TASK_ID(NUMBER)
ERR_NUM(NUMBER)
SUB_RESET SELF(WRI$_ADV_SQLTUNE)
TASK_ID(NUMBER)
SUB_DELETE SELF(WRI$_ADV_SQLTUNE)
TASK_ID(NUMBER)
SUB_RESUME SELF(WRI$_ADV_SQLTUNE)
TASK_ID(NUMBER)
ERR_NUM(NUMBER)
SUB_GET_SCRIPT SELF(WRI$_ADV_SQLTUNE)
TASK_ID(NUMBER)
TYPE(VARCHAR2)
BUFFER(CLOB)
REC_ID(NUMBER)
ACT_ID(NUMBER)
EXECUTION_NAME(VARCHAR2)
OBJECT_ID(NUMBER)
SUB_GET_REPORT SELF(WRI$_ADV_SQLTUNE)
TASK_ID(NUMBER)
TYPE(VARCHAR2)
LEVEL(VARCHAR2)
SECTION(VARCHAR2)
BUFFER(CLOB)
EXECUTION_NAME(VARCHAR2)
OBJECT_ID(NUMBER)
SUB_DELETE_EXECUTION SELF(WRI$_ADV_SQLTUNE)
TASK_ID(NUMBER)
EXECUTION_NAME(VARCHAR2)
SUB_PARAM_VALIDATE SELF(WRI$_ADV_SQLTUNE)
TASK_ID(NUMBER)
NAME(VARCHAR2)
VALUE(VARCHAR2)

Dependencies

[top of page]

SYS.WRI$_ADV_SQLTUNE references the following:

SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
TYPEWRI$_ADV_ABSTRACT_T
SYS.WRI$_ADV_SQLTUNE is referenced by following:

SchemaSYS
Package BodyDBMS_ADVISOR - show dependent code
TableWRI$_ADV_DEFINITIONS
TYPEWRI$_ADV_SQLPI
TYPE BODYWRI$_ADV_SQLTUNE