GV$FILESPACE_USAGE

SELECT
inst_id,                 -- INST_ID NUMBER
KTTEFINFOTSN,            -- TABLESPACE_ID NUMBER
KTTEFINFOFNO,            -- RFNO NUMBER
KTTEFINFOUSP,            -- ALLOCATED_SPACE NUMBER
KTTEFINFOSIZE,           -- FILE_SIZE NUMBER
KTTEFINFOMSIZE,          -- FILE_MAXSIZE NUMBER
KTTEFINFOSCNB,           -- CHANGESCN_BASE NUMBER
KTTEFINFOSCNW,           -- CHANGESCN_WRAP NUMBER
KTTEFINFOFLAG            -- FLAG NUMBER
FROM
X$KTTEFINFO
home |  up  |  mailbox