SQL>SELECT * FROM dba_temp_free_space;
TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
LMTEMP 250609664 101048576 149561088
Which two statements correctly interpret the output?(Choose two.)
A. FREE_SPACE indicates only the space that is currently unallocated.
B. ALLOCATED_SPACE indicates only the space currently allocated and in use.
C. FREE_SPACE indicates only the space that is currently allocated and available for reuse.
D. ALLOCATED_SPACE indicates both the space currently allocated and used,and the space that is available for reuse.
E. FREE_SPACE indicates both the space that is currently allocated and available for reuse,and the space that is currently unallocated.
答案：（D、E）
解析：
DBA_TEMP_FREE_SPACE,在表空间层次上显示临时空间的使用信息.
ALLOCATED_SPACE, 总的分配的空间(bytes),包括当前已经分配的且被使用的, 当前已经分配的且可重用的.
FREE_SPACE,总的可用的空闲空间,包括已经分配的且可被重用的,当前未分配的.