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

VIEW: SYS.GV_$MEMORY_TARGET_ADVICE

Object Details
Object Name: GV_$MEMORY_TARGET_ADVICE
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INST_ID NUMBER

MEMORY_SIZE NUMBER

MEMORY_SIZE_FACTOR NUMBER

ESTD_DB_TIME NUMBER

ESTD_DB_TIME_FACTOR NUMBER

VERSION NUMBER

CON_ID NUMBER

Query Text

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


SELECT INST_ID
,      MEMORY_SIZE
,      MEMORY_SIZE_FACTOR
,      ESTD_DB_TIME
,      ESTD_DB_TIME_FACTOR
,      VERSION
,      CON_ID
FROM SYS.GV_$MEMORY_TARGET_ADVICE;

Dependencies

[top of page]

SYS.GV_$MEMORY_TARGET_ADVICE references the following:

SYS.GV_$MEMORY_TARGET_ADVICE is referenced by following:

SchemaPUBLIC
SynonymGV$MEMORY_TARGET_ADVICE