[Home] [Help] [Dependency Information]

TABLE: SYSTEM.MVIEW$_ADV_LOG

Object Details

Log all calls to summary advisory functions

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: MVIEW$_ADV_LOG_PK

1. RUNID#

Indexes

Index	Type	Uniqueness	Tablespace	Column
MVIEW$_ADV_LOG_PK	NORMAL	UNIQUE	SYSTEM	RUNID#

Foreign Keys

Table		Foreign Table	Foreign Key Column
MVIEW$_ADV_AJG		MVIEW$_ADV_LOG	MVIEW$_ADV_AJG RUNID#
MVIEW$_ADV_CLIQUE		MVIEW$_ADV_LOG	MVIEW$_ADV_CLIQUE RUNID#
MVIEW$_ADV_ELIGIBLE		MVIEW$_ADV_LOG	MVIEW$_ADV_ELIGIBLE RUNID#
MVIEW$_ADV_EXCEPTIONS		MVIEW$_ADV_LOG	MVIEW$_ADV_EXCEPTIONS RUNID#
MVIEW$_ADV_FILTERINSTANCE		MVIEW$_ADV_LOG	MVIEW$_ADV_FILTERINSTANCE RUNID#
MVIEW$_ADV_INFO		MVIEW$_ADV_LOG	MVIEW$_ADV_INFO RUNID#
MVIEW$_ADV_JOURNAL		MVIEW$_ADV_LOG	MVIEW$_ADV_JOURNAL RUNID#
MVIEW$_ADV_LEVEL		MVIEW$_ADV_LOG	MVIEW$_ADV_LEVEL RUNID#
MVIEW$_ADV_OUTPUT		MVIEW$_ADV_LOG	MVIEW$_ADV_OUTPUT RUNID#
MVIEW$_ADV_ROLLUP		MVIEW$_ADV_LOG	MVIEW$_ADV_ROLLUP RUNID#

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT RUNID#
,      FILTERID#
,      RUN_BEGIN
,      RUN_END
,      RUN_TYPE
,      UNAME
,      STATUS
,      MESSAGE
,      COMPLETED
,      TOTAL
,      ERROR_CODE
FROM SYSTEM.MVIEW$_ADV_LOG;

Dependencies

[top of page]

SYSTEM.MVIEW$_ADV_LOG does not reference any database object

SYSTEM.MVIEW$_ADV_LOG is referenced by following:

SYS

PRVT_WORKLOAD - show dependent code

SYSTEM

MVIEW_EVALUATIONS

MVIEW_EXCEPTIONS

MVIEW_FILTER

MVIEW_LOG

MVIEW_RECOMMENDATIONS

MVIEW_WORKLOAD