유용한 dictionary

TABLE_NAME                     COMMENTS

------------------------------ ---------------------------------------------

DBA_USERS                               Information about all users of the database

DBA_TABLESPACES               Description of all tablespaces

DBA_DATA_FILES                  Information about database data files

DBA_FREE_SPACE                  Free extents in all tablespaces

DBA_OBJECTS                         All objects in the database

DBA_SEGMENTS                     Storage allocated for all database segments

DBA_ROLLBACK_SEGS         Description of rollback segments

DBA_EXTENTS                        Extents comprising all segments in the database

DBA_TABLES                           Description of all relational tables in the database

DBA_INDEXES                         Description for all indexes in the database

DBA_VIEWS                             Description of all views in the database

DBA_TRIGGERS                      All triggers in the database

DBA_SOURCE                         Source of all stored objects in the database

q     sample Query

SQL> select username,default_tablespace,temporary_tablespace from dba_users;

SQL> select tablespace_name,bytes,file_name from dba_data_files;

SQL> select tablespace_name,count(*),sum(bytes) from dba_free_space

           group by tablespace_name;