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

TABLE: SYSTEM.MVIEW$_ADV_JOURNAL

Object Details
Object Name: MVIEW$_ADV_JOURNAL
Object Type: TABLE
Owner: SYSTEM
Subobject Name:
Status: VALID

Summary advisor journal table for debugging and information

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: MVIEW$_ADV_JOURNAL_PK
  1. ColumnRUNID#
  2. ColumnSEQ#
Indexes
Index Type Uniqueness Tablespace Column
MVIEW$_ADV_JOURNAL_PK NORMAL UNIQUE TablespaceSYSTEM ColumnRUNID#
ColumnSEQ#
Foreign Keys
Table
Foreign Table Foreign Key Column
MVIEW$_ADV_JOURNAL MVIEW$_ADV_JOURNAL_FK TableMVIEW$_ADV_LOG MVIEW$_ADV_JOURNAL RUNID#
Columns
Name Datatype Length Mandatory Comments
RUNID# NUMBER
Yes
SEQ# NUMBER
Yes
TIMESTAMP DATE
Yes
FLAGS NUMBER
Yes
NUM NUMBER

TEXT LONG (0)
TEXTLEN NUMBER

Query Text

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


SELECT RUNID#
,      SEQ#
,      TIMESTAMP
,      FLAGS
,      NUM
,      TEXT
,      TEXTLEN
FROM SYSTEM.MVIEW$_ADV_JOURNAL;

Dependencies

[top of page]

SYSTEM.MVIEW$_ADV_JOURNAL does not reference any database object

SYSTEM.MVIEW$_ADV_JOURNAL is referenced by following:

SchemaSYS
Package BodyPRVT_WORKLOAD - show dependent code