DBA Data[Home] [Help]

VIEW: SYS.GV_$FILESPACE_USAGE

Source

View Text - Preformatted

select "INST_ID","TABLESPACE_ID","RFNO","ALLOCATED_SPACE","FILE_SIZE","FILE_MAXSIZE","CHANGESCN_BASE","CHANGESCN_WRAP","FLAG","CON_ID" from gv$filespace_usage
View Text - HTML Formatted

SELECT "INST_ID"
, "TABLESPACE_ID"
, "RFNO"
, "ALLOCATED_SPACE"
, "FILE_SIZE"
, "FILE_MAXSIZE"
, "CHANGESCN_BASE"
, "CHANGESCN_WRAP"
, "FLAG"
, "CON_ID"
FROM GV$FILESPACE_USAGE