DBA Data[Home] [Help]

VIEW: SYS.V_$FILESPACE_USAGE

Source

View Text - Preformatted

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

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