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