DBA_TABLESPACES
This is a dynamic performance view equivalent to the SYS.TS$
table containing information on all tablespaces; the only difference is that DBA_TABLESPACES
doesn't list dropped tablespaces.
Fields
The most relevant view fields are as follows:
TABLESPACE_NAME
: The name of the tablespaceBLOCK_SIZE
: The database block size used in the tablespaceSTATUS
: This can beONLINE
,OFFLINE
, orREAD ONLY
CONTENTS
: This can beUNDO
,PERMANENT
, orTEMPORARY
LOGGING
: This can beLOGGING
orNOLOGGING
EXTENT_MANAGEMENT
: This can beDICTIONARY
for dictionary managed orLOCAL
for locally managed tablespacesALLOCATION_TYPE
: This can beSYSTEM
,USER
, orUNIFORM
Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.