All oracle queries and tablespaces, and their relationships, oracle Space

All oracle queries and tablespaces, and their relationships, oracle Space

Select * from dba_users; view all users in the database, provided that you have the dba permission account, such as sys, system
Select * from all_users; view all users you can manage
Select * from user_users; view current user information

 

 

Query the user's tablespace:

Select username, default_tablespace from dba_users; query the tablespace where all users in the database are located

Select username, default_tablespace from user_users; tablespace of the current user in the production line

 

Query the names of all tablespaces:

Select tablespace_name from dba_tablespaces;

How Does oracle query the names of all tablespaces?

It's easy to query the dba_tablespaces data dictionary:
Select tablespace_name from dba_tablespaces;

How Does Oracle query table space?

The system data dictionary DBA_TABLESPACES records details about the tablespace:

Select * from sys. dba_tablespaces;

Fields and meanings in DBA_TABLESPACES:

TABLESPACE_NAME
Tablespace name
BLOCK_SIZE
Tablespace block size
INITIAL_EXTENT
Default initial extent size
NEXT_EXTENT
Default incremental extent size
MIN_EXTENTS
Default minimum number of extents
MAX_EXTENTS
Default maximum number of extents
PCT_INCREASE
Default percent increase for extent size
MIN_EXTLEN
Minimum extent size for the tablespace
STATUS
"Tablespace status:" ONLINE "," OFFLINE "or" READ
CONTENTS
Tablespace contents: "PERMANENT" or "TEMPORARY" or "UNDO"
LOGGING
Default logging attribute
FORCE_LOGGING
Tablespace force logging mode
EXTENT_MANAGEMENT
Extent management tracking: "DICTIONARY" or "LOCAL"
ALLOCATION_TYPE
Type of extent allocation in effect for this tablespace
PLUGGED_IN
--
SEGMENT_SPACE_MANAGEMENT
Segment space management tracking: "AUTO" or "MANUAL"