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

TYPE: SYS.SQLSET_ROW

Object Details
Object Name: SQLSET_ROW
Object Type: TYPE
Owner: SYS
Subobject Name:
Status: VALID
Type Details
Type Code: OBJECT
Predefined: NO
Incomplete: NO
Attributes
Name Datatype Length Prcn
SQL_ID VARCHAR2 (13)
FORCE_MATCHING_SIGNATURE NUMBER

SQL_TEXT CLOB (0)
OBJECT_LIST TYPESQL_OBJECTS

BIND_DATA RAW (2000)
PARSING_SCHEMA_NAME VARCHAR2 (30)
MODULE VARCHAR2 (64)
ACTION VARCHAR2 (64)
ELAPSED_TIME NUMBER

CPU_TIME NUMBER

BUFFER_GETS NUMBER

DISK_READS NUMBER

DIRECT_WRITES NUMBER

ROWS_PROCESSED NUMBER

FETCHES NUMBER

EXECUTIONS NUMBER

END_OF_FETCH_COUNT NUMBER

OPTIMIZER_COST NUMBER

OPTIMIZER_ENV RAW (2000)
PRIORITY NUMBER

COMMAND_TYPE NUMBER

FIRST_LOAD_TIME VARCHAR2 (19)
STAT_PERIOD NUMBER

ACTIVE_STAT_PERIOD NUMBER

OTHER CLOB (0)
PLAN_HASH_VALUE NUMBER

SQL_PLAN TYPESQL_PLAN_TABLE_TYPE

BIND_LIST TYPESQL_BINDS

CON_DBID NUMBER

Methods
Name Parameters Result
SQLSET_ROW SELF(SQLSET_ROW)
SQL_ID(VARCHAR2)
FORCE_MATCHING_SIGNATURE(NUMBER)
SQL_TEXT(CLOB)
OBJECT_LIST(SQL_OBJECTS)
BIND_DATA(RAW)
PARSING_SCHEMA_NAME(VARCHAR2)
MODULE(VARCHAR2)
ACTION(VARCHAR2)
ELAPSED_TIME(NUMBER)
CPU_TIME(NUMBER)
BUFFER_GETS(NUMBER)
DISK_READS(NUMBER)
DIRECT_WRITES(NUMBER)
ROWS_PROCESSED(NUMBER)
FETCHES(NUMBER)
EXECUTIONS(NUMBER)
END_OF_FETCH_COUNT(NUMBER)
OPTIMIZER_COST(NUMBER)
OPTIMIZER_ENV(RAW)
PRIORITY(NUMBER)
COMMAND_TYPE(NUMBER)
FIRST_LOAD_TIME(VARCHAR2)
STAT_PERIOD(NUMBER)
ACTIVE_STAT_PERIOD(NUMBER)
OTHER(CLOB)
PLAN_HASH_VALUE(NUMBER)
SQL_PLAN(SQL_PLAN_TABLE_TYPE)
BIND_LIST(SQL_BINDS)
CON_DBID(NUMBER)
 SQLSET_ROW

Dependencies

[top of page]

SYS.SQLSET_ROW references the following:

SchemaSYS
TYPESQL_BINDS
TYPESQL_OBJECTS
TYPESQL_PLAN_TABLE_TYPE
PL/SQL PackageSTANDARD - show dependent code
SYS.SQLSET_ROW is referenced by following:

SchemaPUBLIC
SynonymSQLSET_ROW
SchemaSYS
Package BodyDBMS_SMB - show dependent code
Package BodyDBMS_SPM - show dependent code
Package BodyDBMS_SPM_INTERNAL - show dependent code
PL/SQL PackageDBMS_SPM_INTERNAL - show dependent code
Package BodyDBMS_SQLDIAG - show dependent code
PL/SQL PackageDBMS_SQLDIAG - show dependent code
Package BodyDBMS_SQLDIAG_INTERNAL - show dependent code
PL/SQL PackageDBMS_SQLDIAG_INTERNAL - show dependent code
Package BodyDBMS_SQLPA - show dependent code
Package BodyDBMS_SQLTCB_INTERNAL - show dependent code
PL/SQL PackageDBMS_SQLTCB_INTERNAL - show dependent code
Package BodyDBMS_SQLTUNE - show dependent code
Package BodyDBMS_SQLTUNE_INTERNAL - show dependent code
PL/SQL PackageDBMS_SQLTUNE_INTERNAL - show dependent code
Package BodyDBMS_XPLAN - show dependent code
Package BodyPRVT_SQLADV_INFRA - show dependent code
Package BodyPRVT_WORKLOAD - show dependent code
TYPESQLSET
TYPE BODYSQLSET_ROW