Oracle faq one thousand [601 to 700]

601. DBA_SNAPSHOT_LOG_FILTER_COLS
Lists all the filter columns recorded in the snapshot log.
602. DBA_SNAPSHOT_LOGS
All snapshot logs in the database.
603. DBA_SNAPSHOT_REFRESH_TIMES
Lists the number of times a snapshot is refreshed.
604. DBA_SNAPSHOTS
All snapshots in the database.
605. DBA_SOURCE
Source of all stored objects in the database.
606. DBA_SOURCE_TABLES
Allows the publisher to view all existing source tables.
607. DBA_SQLJ_TYPE_ATTRS
All attributes of the SQLJ object in the database.
608. DBA_SQLJ_TYPE_METHODS
All types of methods in the database.
609. DBA_SQLJ_TYPES
The SQLJ object type information in the database.
610. DBA_STMT_AUDIT_OPTS
Describes the current system audit options that pass the system and are audited by users.
611. DBA_STORED_SETTINGS
Lists permanent parameter settings for PL/SQL units with execution privileges.
612. DBA_SUBPART_COL_STATISTICS
Lists the column statistics and histogram information of table subpartitions.
613. DBA_SUBPART_HISTOGRAMS
List the actual data of the histogram in the table subpartition.
614. DBA_SUBPART_KEY_COLUMNS
Allows publishers to view all the release columns they have subscribed.
615. DBA_SUBPART_TABLES
Allows publishers to view all the released tables they have subscribed.
616. DBA_SUBSCRIPTIONS
Allows publishers to view all reservations.
617. DBA_SYNONYMS
All synonyms in the database.
618. DBA_SYS_PRIVS
System privileges granted to users and roles.
619. DBA_TAB_COL_STATISTICS
Contains column statistics and histogram information in the DBA_TAB_COLUMNS view.
620. DBA_TAB_COLUMNS
Information about all tables, views, and clustered description columns.
621. DBA_TAB_COMMENTS
Annotations for all columns and tables in the database.
622. DBA_TAB_HISTOGRAMS
The histogram of all columns in the table.
623. DBA_TAB_MODIFICATIONS
Displays all the tables in the database that have been modified since the previous statistics.
624. DBA_TAB_PARTITIONS
Partition information of a table, storage parameters of partitions, and statistics of various partitions determined by ANALYZE.
625. DBA_TAB_PRIVS
Lists the system privileges granted to a user's role.
626. DBA_TAB_SUBPARTITIONS
A subpartition of a table describes its partition-level partition information, the storage parameters of the partitions, and the statistics of various partitions determined by ANALYZE.

627. DBA_TABLES
Description of tables related to the database.
628. DBA_TABLESPACES
Description of all tablespaces.
629. DBA_TEMP_FILES
Temporary database file information.
630. DBA_TRANSFORMATIONS
All message passing information in the database.
631. DBA_TRIGGER_COLS
Usage of all trigger columns.
632. DBA_TRIGGERS
All triggers in the database.
633. DBA_TS_QUOTAS
The quota of tablespaces for all users.
634. DBA_TYPE_ATTRS
Database Type attributes.
635. DBA_TYPE_METHODS
Describes all types of methods in the database.
636. DBA_TYPES
All abstract data types in the database.
637. DBA_UNDO_EXTENTS
The submission time for each range of the tablespace to be undo.
638. DBA_UNUSED_COL_TABS
Description of all unused columns.
639. DBA_UPDATABLE_COLUMNS
Description of the columns that can be updated by the database administrator in a connection view.
640. DBA_USERS
All user information of the database.
641. DBA_USTATS
Current user information.
642. DBA_VARRAYS
The text of the view that you can access.
643. DBA_VIEWS
The text of all views in the database.
644. DBA_WAITERS
Lists All sessions that are waiting for a lock and the sessions that are blocking them from obtaining the lock.
9I data dictionary USER View
645. USER_ALL_TABLES
Description of the table available to the user.
646. USER_ARGUMENTS
Lists the parameters in an object accessible to users.
647. USER_ASSOCIATIONS
User-Defined statistics on the objects owned by the current user.
648. USER_AUDIT_OBJECT
Statement Audit Trail records of objects.
649. USER_AUDIT_SESSION
All audit trail records of user connection or disconnection.
650. USER_AUDIT_STATEMENT
Lists the AUDIT trail entries of GRANT, REVOKE, AUDIT, NOAUDIT, and alter system statements issued by the user.
651. USER_AUDIT_TRAIL
User-related audit trail entries.
652. USER_BASE_TABLE_MVIEWS
All materialized views of current user logs that use materialized views.
653. USER_CATALOG
User-owned tables, views, synonyms, and sequences.
654. USER_CLU_COLUMNS
Ing between columns in the User table and clustering columns.
655. USER_CLUSTER_HASH_EXPRESSIONS
All clustering and hash functions that can be accessed by users.
656. USER_CLUSTERS
Description of user-owned aggregation.
657. USER_COL_COMMENTS
List comments on columns of a user table or view.
658. USER_COL_PRIVS
Lists the permissions on a column. The user is the owner, the grantee, or the grantee.
659. USER_COL_PRIVS_MADE
Lists All permissions on columns of objects owned by users.
660. USER_COL_PRIVS_RECD
Lists the permissions on a column. The user is the authorized user.
661. USER_COLL_TYPES
The type of the user's name set.
662. USER_CONS_COLUMNS
Column information in the user-owned constraint definition.
663. USER_CONSTRAINTS
The constraint definition on the user table.
664. USER_DB_LINKS
Database chain information.
665. USER_DEPENDENCIES
Dependencies between user objects.
666. USER_DIM_ATTRIBUTES
The relationship between the dimension level and functional dependency in current user mode.
667. USER_DIM_CHILD_OF
Level 1 to n-dimensional relationships of the current user.
668. USER_DIM_HIERARCHIES
The dimension level owned by the current user.
669. USER_DIM_JOIN_KEY
Connections between dimensions owned by the current user.
670. USER_DIM_LEVEL_KEY
A dimension column owned by the current user.
671. USER_DIM_LEVELS
A dimension column owned by the current user.
672. USER_DIMENSIONS
Dimension object in current user mode.
673. USER_ERRORS
Current error on all storage objects of the user.
674. USER_EXTENTS
The range of user object segments.
675. USER_EXTERNAL_TABLES
All external objects owned by the current user.
676. USER_FREE_SPACE
You can access the free range in the tablespace.
678. USER_HISTOGRAMS
This view is a synonym for USER_HISTOGRAMS.
679. USER_IND_COLUMNS
User index and table column.
680. USER_IND_EXPRESSIONS
The expression of the function-based index on the table owned by the current user.
681. USER_IND_SUBPARTITIONS
Attributes of each word partition owned by the current user, partition-level partition information, storage parameters of sub-partitions, and statistics of various partitions determined by ANALYZE.
682. USER_INDEXES
Description of the index owned by the current user.
683. USER_INDEXTYPE_COMMENTS
All comments of the index types defined by the current user.
684. USER_INDEXTYPE_OPERATORS
All operations of the index type owned by the current user.
685. USER_INDEXTYPES
All index types owned by the current user.
686. USER_INTERNAL_TRIGGERS
Internal triggers for all tables owned by the current user.
687. USER_JOBS
All jobs owned by the user.
688. USER_JOIN_IND_COLUMNS
All the connection conditions of the database owned by the current user.
689. USER_LIBRARIES
Lists All databases owned by users.
690. USER_LOB_PARTITIONS
The shard-level attribute in the LOB data subpartition owned by the current user.
691. USER_LOBS
Displays the LOB contained in the User table.
692. USER_LOG_GROUP_COLUMNS
The column specified in the log owned by the current user.
693. USER_LOG_GROUPS
The log Group Definition of all tables owned by the current user in the database.
694. USER_METHOD_PARAMS
Method parameters of the user type owned by the current user.
695. USER_MVIEW_AGGREGATES
Grouping functions owned by the current user in the SELECT list of the clustered instantiation view.
696. USER_MVIEW_ANALYSIS
All materialized views owned by the current user are used to potentially support query rewriting and additional information that can be used for application analysis.
697 USER_MVIEW_DETAIL_RELATIONS
Represents the detailed naming relationship.
698. USER_MVIEW_JOINS
Describes the connection between two columns in a WHERE clause of an instantiated view.
699. USER_MVIEW_KEYS
Materialized view is based on the column or expression of the current user mode in the SELECT list.
700. USER_MVIEW_REFRESH_TIMES
Refresh time of all materialized views owned by the current user in the database.