First page Back Continue Last page Graphics

Continuation of Notes


Notes:

Commonly used data dictionary views, continued from the previous page:
DBA_INDEXES contains one row for every index.
DBA_TABLESPACES contains one row for every tablespace.
DBA_DATA_FILES contains one row for every data file.
DBA_OBJECTS contains one row for every object that has been created, including tables, views, indexes, procedures, functions, etc.
DBA_SEGMENTS contains information relating to the initial, next, percent increase, number of extents, and the number of blocks and bytes for the segment.
DBA_EXTENTS contains information relating to each extent within a segment, specifically data file that contains the extent, the starting block number and length of the extent in blocks and bytes.
DBA_FREE_SPACE contains information relating to the free space within the database, specifically, the data file, starting block number and size in blocks and bytes of every area of contiguous free space within the database.
DBA_VIEWS contains a row for every view created in the database and includes the view text (definition).
DBA_SYNONYMS contains a row for every synonym and contains the synonym name and the owner and table the synonym points to.
DBA_SYS_PRIVS contains a row for every system privilege granted (e.g. GRANT CREATE TABLE) to a user or role.
DBA_TAB_PRIVS contains a row for every grant on every table. It contains grantor, grantee and the privilege granted, among other things.
DBA_TRIGGERS contains one row for every trigger defined. It contains the type, event, and body (code) among other things.