DBA Data[Home] [Help]

VIEW: SYS.V_$TEMP_EXTENT_POOL

Source

View Text - Preformatted

select "TABLESPACE_NAME","FILE_ID","EXTENTS_CACHED","EXTENTS_USED","BLOCKS_CACHED","BLOCKS_USED","BYTES_CACHED","BYTES_USED","RELATIVE_FNO","CON_ID" from v$temp_extent_pool
View Text - HTML Formatted

SELECT "TABLESPACE_NAME"
, "FILE_ID"
, "EXTENTS_CACHED"
, "EXTENTS_USED"
, "BLOCKS_CACHED"
, "BLOCKS_USED"
, "BYTES_CACHED"
, "BYTES_USED"
, "RELATIVE_FNO"
, "CON_ID"
FROM V$TEMP_EXTENT_POOL