Friday, August 15, 2008

DBA_TEMP_FREE_SPACE

  Thank you for visiting Spatial DBA - Oracle and ArcSDE.

I have stopped updating the blog.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.

====================================================================


Oracle 11gR1
DBA_TEMP_FREE_SPACE displays temporary space usage information at tablespace level.

Column
Datatype
NULL
Description
TABLESPACE_NAME
VARCHAR2(30)
NOT NULL
Name of the tablespace
TABLESPACE_SIZE
NUMBER
Total size of the tablespace, in bytes
ALLOCATED_SPACE
NUMBER
Total allocated space, in bytes, including space that is currently allocated and used and space that is currently allocated and available for reuse
FREE_SPACE
NUMBER
Total free space available, in bytes, including space that is currently allocated and available for reuse and space that is currently unallocated

Oracle data dictionary views

No comments:

Post a Comment