Oracle Common Questions 1000 Questions (7)

xiaoxiao2021-03-06  149

601. DBA_SNAPSHOT_LOG_FILTER_COLS

List all the filters recorded on the snapshot log.

602. DBA_SNAPSHOT_LOGS

All snapshot logs in the database.

603. DBA_SNAPSHOT_REFRESH_TIMES

List the number of snapshots.

604. DBA_SNAPSHOTS

All snapshots in the database.

605. DBA_Source

Source of all storage objects in the database.

606. dba_source_tables

Allow the issuer to view all existing source tables.

607. DBA_SQLJ_TYPE_ATTRS

All properties for the SQLJ object in the database.

608. DBA_SQLJ_TYPE_METHODS

All types of methods in the database.

609. DBA_SQLJ_TYPES

All of the databases on SQLJ object type information.

610. DBA_STMT_AUDIT_OPTS

Describe the current system audit options through the system and by the user audit.

611. DBA_Stored_Settings

List the permanent parameter setting information of the storage PL / SQL unit with privilege.

612. DBA_SUBPART_COL_STATISTICS

List the column statistics and histogram information of the form partition.

613. DBA_SUBPART_HISTOGRAMS

List the actual data of the straight figure in the form partition.

614. DBA_SUBPART_KEY_COLUMNS

Allow the issuer to view the columns of all the issued issues they are ready.

615. DBA_SUBPART_TABLES

Allow the issuer to view all the issues they are ready.

616. DBA_SUBSCRIPTIONS

Allow the issuer to view all scheduled.

617. DBA_SYNONYMS

All synonyms in the database.

618. DBA_SYS_PRIVS

System privileges granted to users and roles.

619. DBA_TAB_COL_STATISTICS

The column statistics and histogram information included in the DBA_TAB_COLUMNS view.

620. DBA_TAB_COLUMNS

All tables, views and aggregated descriptions of information.

621. DBA_TAB_COMMENTS

Note from all columns and tables in the database.

622. DBA_TAB_HISTOGRAMS

The histograms of all listings are listed.

623. DBA_TAB_MODIFICATIONS

Displays the modified table after all the last statistics in the database.

624. DBA_TAB_PARTITIONS

The partition of the table, description area statistics. Its partition level partition information, partition storage parameters and various points determined by Analyze

625. DBA_TAB_PRIVS

List system privileges granted to the user's role.

626. DBA_TAB_SUBPARTITIONS

Statistics on the subsequent zone of the table and the score area. This partition-level partition information, partition storage parameters, and various types determined by Analyze

627. DBA_TABLES

Description of all relational tables in the database.

628. DBA_TABLESPACES

Description of all table spaces.

629. DBA_TEMP_FILES

Database temporary file information.

630. DBA_TRANSFORMATIONS

All messaging information in the database is delivered.

631. DBA_TRIGGER_COLS

Usage of all triggers columns.

632. DBA_TRIGGERS

All triggers in the database.

633. DBA_TS_QUOTAS

All users' tablespace limit.

634. DBA_TYPE_ATTRS

The properties of the database type.

635. DBA_TYPE_METHODS

Describe all types of methods in the database.

636. DBA_TYPES

All abstract data types in the database.

637. DBA_UNDO_EXTENTS

Submission time of each range of the withdrawal table space.

638. DBA_UNUSED_COL_TABS

Description of all unused columns.

639. DBA_UPDATABLE_COLUMNS

For a description of the columns that can be updated by the database administrator in a connection view.

640. DBA_USERS

Database All user information. 641. DBA_USTATS

Current user information.

642. DBA_VARRAYS

The text of the user can access the text.

643. DBA_VIEWS

The text of all views in the database.

644. DBA_Waiters

List all sessions that are waiting for a lock, and lists the sessions that are blocking them from getting the lock.

9i Management Data Dictionary USER View

645. User_all_tables

A description of the table available to the user.

646. User_arguments

List the parameters in the object you can access by the user.

647. USER_ASSOCIATIONS

User-defined statistics of the current user owned by the user.

648. User_audit_object

About the statement audit tracking record.

649. User_audit_Session

About all audit trail records for users or disconnects.

650. User_audit_statement

List the GR objects issued by the user. ANT, REVOKE, AUDIT, NoAudit, ALTER SYSTEM statement audit trace bar

651. User_audit_trail

Audit trace entry related to the user.

652. User_base_table_mviews

The current user owns all the materialized view of the usual view log.

653. User_catalog

The user has a table, view, synonym, and sequence.

654. USER_CLU_COLUMNS

The list of user tables is listed to the mapping of the aggregation columns.

655. User_cluster_hash_expressions

All aggregates and hash functions for users can access.

656. User_Clusters

Description of the aggregation owned by the user.

657. User_col_comments

List the comments on the column of the user table or view.

658. USER_COL_PRIVS

List the authorization on the column, the user is owner, grantient, or being granted.

659. User_col_privs_made

List all the licenses on the columns of the user's objects.

660. User_col_privs_recd

List the authorization on the column, the user is awarded.

661. User_coll_types

The user's naming collection type.

662. User_cons_columns

The column information in the user's constraint definition.

663. User_Constraints

Constraint definitions on the user table.

664. User_db_links

Database chain information.

665. User_Dependencies

The dependence between the user's object.

666. User_dim_attributes

The relationship between the current user mode is level and functional dependencies.

667. User_dim_child_of

The current user has a hierarchical relationship of 1 to N-dimensional water.

668. User_dim_hierarchies

The hierarchy of the current user has a dimension.

669. User_dim_join_Key

The current connection between the user has a dimension.

670. User_dim_level_key

The current user has a grade of a grade.

671. USER_DIM_LEVELS

A Ni Column with current users has.

672. User_dimensions

Current user mode under the object.

673. User_ERRORS

Current error on all users of all storage objects.

674. User_extents

The range of segments belonging to the user object.

675. User_External_Tables

All external objects of the current user have.

676. User_free_space

The user can access the idle range in the table space.

678. User_histograms

This view is synonymous with user_histograph.

679. User_ind_columns

User index and columns on the table.

680. User_ind_expressions

The current user has an expression based on a function based on a function.

681. User_ind_subpartitions

Various partition statistics determined by each of the native partitions of the current user owns. Sex, partition level partition information, storage parameters of the subsector, 682. User_indexes

An instructions for the current user owns the index.

683. User_indextype_comments

All comments for the user-defined index type owned by the user.

684. User_indextype_operators

All operations of the current user have index types.

685. User_indextypes

All index types owned by the current user.

686. User_internal_triggers

The internal trigger on all tables owned by the user.

687. User_JOBS

All homework owned by users.

688. user_join_ind_columns

All connection conditions in the current user have in the database.

689. USER_LIBRARIES

List all the users owned by the user.

690. User_lob_partitions

The partition level attribute in the current user has the LOB data subordinate partition.

691. User_lobs

Displays the LOB contained in the user table.

692. User_log_group_columns

The current user owns the column specified in the log.

693. User_log_groups

The log group defined by all tables owned by the current user in the database.

694. User_method_params

Method parameters of the user type owned by the user.

695. User_mview_aggregates

The current user has a group function that appears in the SELECT list of the instantiation view.

696. User_mview_analysis

All materialized views of the current user have additional information. Used to potentially support query rewriting and have available applications

697. User_mview_detail_relevants

Represents the naming detail relationship.

698. User_mview_join

Describe the connection between the two columns in the WHERE clause of an instantiated view.

699. User_mview_keys

The materialization view is based on the column or expression in the SELECT list based on the current user mode.

700. User_mview_refresh_times

Refresh time of all materialized views owned by the current user in the database.

转载请注明原文地址:https://www.9cbs.com/read-127666.html

New Post(0)