DBA Data[Home] [Help]

VIEW: SYS.V_$PDBS

Source

View Text - Preformatted

select "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 v$pdbs
View Text - HTML Formatted

SELECT "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 V$PDBS