Useful Data Dictionary Views
Database Storage | |
---|---|
Data Dictionary View | Used to Obtain Information About |
DBA_TABLESPACES | Tablespaces |
DBA_ROLLBACK_SEGS | Rollback segments |
DBA_EXTENTS | Extents that comprise a segment |
DBA_FREE_SPACE | Free extents in a database segment |
DBA_TS_QUOTAS | Tablespace quotas for the various users |
DBA_SEGMENTS | Database segments |
DBA_DATA_FILES | Database files |
Database objects | |
---|---|
Data Dictionary View | Used to Obtain Information About |
DBA_TRIGGERS | Database triggers |
DBA_OBJECT_SIZE | Size of various PL/SQL objects |
DBA_OBJECTS | Database objects such as tables and views |
DBA_SOURCE | Source of all database objects |
DBA_ERRORS | Errors in the database objects |
DBA_DEPENDENCIES | Dependencies between the various database objects |
Database Security | |
---|---|
Data Dictionary View | Used to Obtain Information ... |
Get e-Commerce Applications Using Oracle8i and Java from Scratch 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.