Others
These other views and tables are used by individual users:
- DBA_UNDO_EXTENTS
Lists the commit time of each extent in the UNDO tablespace. New with Oracle9i.
- CHAINED_ROWS
Populated by the ANALYZE TABLE command to show all chained rows in a table. Created using the utlchain.sql script.
- EXCEPTIONS
Contains a list of all rows that have a constraint violation. Populated when attempting to create or enable a constraint. Created using the utlexcpt.sql script.
- *_JOIN_IND_COLUMNS
Describes the columns used in the join that the bitmapped index is associated with. New with Oracle9i.
- PLAN_TABLE
Used by the EXPLAIN_PLAN process to show the execution plan for a SQL statement. Created using the utlxplan.sql script.
- *_PROCEDURES
Lists information about procedures defined within the database, such as whether they are aggregate functions, pipelined table functions, or parallel-enabled functions. New with Oracle9i.
- *_PROXIES
Lists information about all proxy connections in the system. There is no ALL_ PROXIES view. New with Oracle9i.
- *_RESUMABLE
Lists all RESUMABLE statements. When the database runs out of space, these statements allow the DBA to suspend an operation, add more space, and then resume the operation. There is no ALL_RESUMABLE view. New with Oracle9i.
- *_STORED_SETTINGS
Provides information about persistent parameter settings for stored PL/SQL units. New with Oracle9i.