Oracle faq one thousand [601 to 700]

Source: Internet
Author: User

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.

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.