DBA Data[Home] [Help]

VIEW: SYS.GV_$CONTAINERS

Source

View Text - Preformatted

select "INST_ID","CON_ID","DBID","CON_UID","GUID","NAME","OPEN_MODE","RESTRICTED","OPEN_TIME","CREATE_SCN","TOTAL_SIZE","BLOCK_SIZE","RECOVERY_STATUS","SNAPSHOT_PARENT_CON_ID" from gv$containers
View Text - HTML Formatted

SELECT "INST_ID"
, "CON_ID"
, "DBID"
, "CON_UID"
, "GUID"
, "NAME"
, "OPEN_MODE"
, "RESTRICTED"
, "OPEN_TIME"
, "CREATE_SCN"
, "TOTAL_SIZE"
, "BLOCK_SIZE"
, "RECOVERY_STATUS"
, "SNAPSHOT_PARENT_CON_ID"
FROM GV$CONTAINERS