Page 460
Table 19.2. continued
Object Purpose | Prefix | Object Name | Displays |
OBJ STRUCT | USER , DBA | _CLU_COLUMNS | Which columns in tables owned by a user are part of a cluster. |
OBJ STRUCT | USER, DBA | _CLUSTERS | Clusters that have been created. If the cluster has been analyzed , this table includes information used by the cost-based optimizer. |
OBJ STRUCT | ALL, USER, DBA | _CONS_COLUMNS | Column-level constraint information on tables, including information about which columns make up the primary key, foreign key, and unique key constraints. |
OBJ STRUCT | ALL, USER, DBA | _CONSTRAINTS | Primary key, foreign key, unique key, check, and non-null constraints on tables. |
OBJ STRUCT | USER, DBA | _CROSS_REFS | Cross references for user views and synonyms. |
OBJ STRUCT | ALL, USER, DBA | _DEPENDENCIES | Information on dependencies between database objects, such as tables, views, and procedures. |
OBJ STRUCT | USER, DBA | _EXTENTS | Extents taken up by the segments. Shows the size and location of each extent. |
OBJ STRUCT | ALL, USER, DBA | _IND_COLUMNS | Columns that make up the indexes on tables and the order in which the columns are included in the index. |
OBJ STRUCT | ALL, USER, DBA | _INDEXES | Indexes that have been set up, including the current storage parameters in effect for the indexes. If the index has been analyzed, the information used by the cost-based optimizer also is available in this view. |
Page 461
Object Purpose | Prefix | Object Name | Displays |
OBJ STRUCT | ALL, USER, DBA | _OBJECTS | Objects ”tables, views, synonyms, and procedures. Refer to this table first when you are not sure whether an object is a table, view, synonym, or procedure. It shows when the object structure was modified last. |
OBJ STRUCT | USER, DBA | _SEGMENTS | Storage allocated for all the database segments, including the tablespace in which the storage is allocated and the number of extents taken up. |
OBJ STRUCT | ALL, USER, DBA | _SEQUENCES | Sequences used to generate unique numbers using NEXTVAL and CURRVAL. Includes the last sequence number written to disk. |
OBJ STRUCT | USER, DBA | _SNAPSHOT_LOGS | Snapshot logs used to refresh snapshots. Includes information about the table used to provide the snapshot log and the database trigger on the master table used to write to the log table. |
OBJ STRUCT | ALL, USER, DBA | _SNAPSHOTS | Snapshots that currently are accessible to the user. Includes information about the master object on which the snapshot has been set up, when the snapshot was refreshed last, the date of the next refresh, and the database trigger used to refresh the snapshot. |
OBJ STRUCT | ALL, USER, DBA | _SOURCE | Source for procedures, functions, and packages. |
OBJ STRUCT | ALL, USER, DBA | _SYNONYMS | Synonyms for tables, views, procedures, and so on. |
OBJ STRUCT | ALL, USER, DBA | _TAB_COLUMNS | Column descriptions of tables, views, and clusters. If the table or cluster has been analyzed, information used by the cost-based optimizer is included in this data dictionary view. |
continues
Page 462
Table 19.2. continued
Object Purpose | Prefix | Object Name | Displays |
OBJ STRUCT | ALL, USER, DBA | _TABLES | Tables ”including the current storage parameters. If the table has been analyzed, it includes information used by the cost-based optimizer and information about the number of chained rows. The row IDs of rows that have been chained can be obtained if the LIST CHAINED ROWS parameter is provided as part of the ANALYZE command. |
OBJ STRUCT | ALL, USER, DBA | _TRIGGER_COLS | Columns used in triggers. |
OBJ STRUCT | ALL, USER, DBA | _TRIGGERS | Database triggers that have been created on tables, including what event the trigger fires on and the source code for the trigger. |
OBJ STRUCT | ALL, USER, DBA | _VIEWS | View definitions, including the underlying SQL statement for the view. |
PREV | SYSFILES | Operating system files used by the database (an Oracle5 view). | |
PREV | SYSSEGOBJ | Information about the different segments on the database (an Oracle5 view). | |
PREV | TAB | Table information (an Oracle5 view). | |
PREV | TABQUOTAS | Information about the amount of storage users can use (an Oracle5 view). | |
PREV | V$DBFILE | Redundant. Use v$datafile instead. | |
PREV | V$LOGHIST | Redundant. Use v$log_history instead. | |
SEC | ALL, USER, DBA | _COL_PRIVS | Which column-level privileges have been granted or received if access to tables has been taken down to the column level. |
Page 463
Object Purpose | Prefix | Object Name | Displays |
SEC | ALL, USER | _COL_PRIVS_MADE | Which column-level privileges have been granted if security has been taken down to the column level. |
SEC | ALL, USER | _COL_PRIVS_RECD | Which column-level privileges have been received by the cur-rent user if security has been taken down to the column level. |
SEC | DBA | _PROFILES | Profiles created on the database when Oracle profiles are used to limit resource use. |
SEC | USER, DBA | _ROLE_PRIVS | Roles granted to the user. Indicates whether the role is a default, whether the user is allowed to administer the role, and whether the role requires operating system privileges to be enabled. |
SEC | DBA | _ROLES | Names of roles and whether a password is required to enable them. |
SEC | USER, DBA | _SYS_PRIVS | System privileges that have been given directly to the user. |
SEC | ALL, USER, DBA | _TAB_PRIVS | Grants received or given on objects for which the user made the grant, received the grant, or is the owner of the object (a superset view). |
SEC | ALL, USER | _TAB_PRIVS_MADE | Grants made on objects owned by the current user (a subset of TAB_PRIVS). |
SEC | ALL, USER | _TAB_PRIVS_RECD | Grants on objects for which the user has received the grant (a subset of TAB_PRIVS). |
SEC | RESOURCE_COST | The cost of each resource. Used to apply weighting factors for resources that can be limited for users with Oracle profiles. The user can change the weighting factors for each resource by using the ALTER SYSTEM SET RESOURCES COST statement. |
continues
Page 464
Table 19.2. continued
Object Purpose | Prefix | Object Name | Displays |
SEC | ROLE_ROLE_PRIVS | Roles granted to roles. It indicates whether the role has been granted with the ADMINISTRATOR option. | |
SEC | ROLE_SYS_PRIVS | System privileges granted to roles. Indicates whether the role can grant the system privilege to other roles or users. | |
SEC | ROLE_TAB_PRIVS | Table privileges granted to roles. Indicates whether the role can grant the table-level privilege to other roles or users. | |
SEC | SESSION_PRIVS | System-level privileges available in the session. | |
SEC | SESSION_ROLES | Roles enabled in the session. | |
SEC | V$ENABLEDPRIVS | Privileges in effect for the session. | |
TUN | DBA | _ANALYZE_OBJECTS | Tables, indexes, and clusters that have been analyzed by using the ANALYZE SQL statement. |
TUN | USER | _RESOURCE_LIMITS | Resource limits ”such as CPU time and logical and physical I/O ”that have been set up using Oracle profiles. |
TUN | CHAINED_ROWS | The default table name used to report the row IDs of rows where a chaining problem has been detected by using the ANALYZE TABLE LIST CHAINED ROWS statement. Created by the utlchain.sql Oracle-supplied script. | |
TUN | EXCEPTIONS | Further information about why an exception could not be enabled. Created by the utlexcpt.sql Oracle-supplied script. | |
TUN | INDEX_HISTOGRAM | How many times key values have been repeated (when used with the VALIDATE INDEX command). Instead, use the ANALYZE INDEX command and query the user_indexes table. |