eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: SYSTEM.MVIEW$_ADV_AJG

Object Details

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

Anchor-join graph representation

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: MVIEW$_ADV_AJG_PK

AJGID#

Indexes

Index	Type	Uniqueness	Tablespace	Column
MVIEW$_ADV_AJG_PK	NORMAL	UNIQUE	SYSTEM	AJGID#

Foreign Keys

Table		Foreign Table	Foreign Key Column
MVIEW$_ADV_AJG		MVIEW$_ADV_LOG	MVIEW$_ADV_AJG RUNID#
MVIEW$_ADV_FJG		MVIEW$_ADV_AJG	MVIEW$_ADV_FJG AJGID#

Columns

Name	Datatype	Length	Mandatory
AJGID#	NUMBER		Yes
RUNID#	NUMBER		Yes
AJGDESLEN	NUMBER		Yes
AJGDES	LONG RAW	(0)	Yes
HASHVALUE	NUMBER		Yes
FREQUENCY	NUMBER

Query Text

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


SELECT AJGID#
,      RUNID#
,      AJGDESLEN
,      AJGDES
,      HASHVALUE
,      FREQUENCY
FROM SYSTEM.MVIEW$_ADV_AJG;

Dependencies

[top of page]

SYSTEM.MVIEW$_ADV_AJG does not reference any database object

SYSTEM.MVIEW$_ADV_AJG is referenced by following:

SYS: PRVT_WORKLOAD - show dependent code