Oracle common problem 1000 questions complete works (six)

xiaoxiao2021-03-06  149

501. DBA_COL_PRIVS

List all privileges granted in the database.

502. DBA_COLL_TYPES

Displays all named collection types in the database.

503. DBA_CONS_COLUMNS

Includes information of the accessible column in the constraint definition.

504. DBA_CONSTRAINTS

All forms constraints are defined.

505. DBA_CONTEXT

All context namespace information.

506. DBA_DATA_FILES

Database file information.

507. DBA_DB_LINKS

All database links in the database.

508. DBA_DDL_LOCKS

All DDL locks held by the database.

509. DBA_Dependencies

List the dependence between objects.

510. DBA_DIM_ATTRIBUTES

The relationship between the columns between dimensions and functions dependent.

511. DBA_DIM_JOIN_KEY

Represents connections between two dimensions.

512. DBA_DIM_LEVEL_KEY

Represents a column of a dimension.

513. DBA_DIM_LEVELS

Represents a dimension.

514. DBA_DIMENSIONS

Representative object.

515. DBA_DIRECTORIES

Provide information on all objects of the database.

516. DBA_DML_LOCKS

List all DML locks in the database, and the request for a DML lock.

517. DBA_ERRORS

List the current error of all stored objects in the database.

518. DBA_EXP_FILES

Contains information for exporting files.

519. DBA_EXP_OBJECTS

List the objects exported in an incremental manner.

520. DBA_EXP_VERSION

Contains the version number of the final export session.

521. DBA_EXTENTS

List the information of all segments in the database.

522. DBA_EXTERNAL_TABLES

Describe all the external tables in the database.

523. DBA_FREE_SPACE

List the idle partitions in all tablespaces.

524. DBA_FREE_SPACE_COALESCED

Contains statistics on the merged space in the table space.

525. DBA_HISTOGRAMS

Synonym of DBA_TAB_HISTOGRAMS.

526. DBA_IND_COLUMNS

A description of the columns included in all tables and aggregates.

527. DBA_IND_EXPRESSIONSSSIONS

Contains an expression of a function type index in all tables and aggregates.

528. DBA_IND_PARTITIONS

Divided partition statistics for each index. Describe the partition level information, the storage parameters of the partition, and various types determined by Analyze

529. DBA_IND_SUBPARTITIONS

The partition-level meter data is described for each index partition for the various partitions determined by the Analyze of the current user. Subregard information, partition storage parameters and

530. DBA_INDEXES

Description of all indexes in the database.

531. dba_indextype_comments

All user-defined index types in the database.

532. DBA_INDEXTYPE_OPERATORS

List all the operators supported by the index type.

533. DBA_INDEXTYPES

All index types.

534. DBA_Internal_Triggers

All internal triggers in the database.

535. DBA_JOBS

All jobs in the database.

536. DBA_JOBS_RUNG

All currently running jobs in the database.

537. DBA_JOIN_IND_COLUMNS

Describe all connection conditions in the database.

538. DBA_KGLLOCK

List all locks and Pins on the KGL object.

539. DBA_LIBRARIES

List all the libraries in the database.

540. DBA_LOB_PARTITIONS

The JOB that can be accessed in the table.

541. DBA_LOB_SUBPARTITIONS

Displays partition-level properties in the LOB data subordinate partition.

542. DBA_LOBS

Contains LOBs in all tables.

543. DBA_LOCK_INTERNAL contains a row of information that holds the lock or simple lock, and the one-line information of each unrequited request.

544. DBA_LOCKS

List the locks or simple locks held in the database, and each unrequited request information.

545. DBA_LOG_GROUP_COLUMNS

Describe information on all columns in the database specified in the log group.

546. DBA_METHOD_PARAMS

Description of the method parameters of the type of the database.

547. DBA_METHOD_RESULTS

Description of all types of method results in the database.

548. DBA_MVIEW_AGGREGATES

Group functions that appear in the SELECT list that aggregates the SELECT list.

549. DBA_MVIEW_ANALYSIS

Representatives potentially support query rewriting.

550. DBA_MVIEW_LOG_FILTER_COLS

List all the columns recorded in the materialized view log.

551. DBA_MVIEW_REFRESH_TIMES

Describe the refresh time of all materialized views in the database.

552. DBA_MVIEWS

Describe all materialized views in the database.

553. DBA_NESTED_TABLES

Description of the nested table in all tables.

554. DBA_OBJ_AUDIT_OPTS

List the audit options for all users of the user.

555. DBA_Object_size

List the size indicated by various objects bytes.

556. DBA_Object_Tables

Displays a description of all object tables in the database.

557. DBA_OBJECTS

List all objects in the database.

558. DBA_OPAncillary

List the additional information of the operating connection.

559. DBA_OPARGUMENTS

List the parameter information of the operation of the connection.

560. dba_orphan_key_table

Reports the key values ​​in the index of the base table.

561. DBA_OUTLINE_HINTS

List the prompt that makes up a summary.

562. DBA_outlines

List the information about the summary.

563. DBA_PART_COL_STATISTICS

Column statistics and histogram information of all partition tables.

564. DBA_PART_HISTOGRAMS

All histogram data of all histograms on all table partitions.

565. DBA_PART_INDEXES

Object-level partition information for all partition indexes.

566. DBA_PART_KEY_COLUMNS

Partition key column of all partition objects.

567. DBA_PART_LOBS

Describe the table-level information of the partition LOB.

568. DBA_PART_TABLES

List the object-level partition information of all partition tables.

569. DBA_PARTIAL_DROP_TABS

Describe some deleted tables.

570. DBA_PENDING_TRANSACTIONS

Provide information about the unfinished transaction.

571. DBA_POLICIES

List all security policies in the database.

572. DBA_PRIV_AUDIT_OPTS

The current system privileges via the system and the user audit.

573. DBA_PROCEDURES

All functions and processes and their related properties.

574. DBA_PROFILES

Display all startup files and restrictions.

575. DBA_PROXIES

Displays information about all proxy connections in the system.

576. DBA_PUBLISHED_COLUMNS

Describe all the tables where there is a source.

577. DBA_QUEUE_SCHEDULES

Describe the current propagation information.

578. DBA_QUEUE_TABLES

Describe the names and types of the queues in all queues established in the database.

579. DBA_QUEUES

Describe the operational characteristics of each queue in the database.

580. DBA_RCHILD

List all subgroups in any refresh group.

581. DBA_REFRESH

List all refresh groups.

582. DBA_REFRESH_CHILDREN

List all objects in the refresh group.

583. DBA_REFS

The REF column and the REF attribute in the object type column of all tables in the database.

584. DBA_REGISTERED_MVIEW_GROUPS

List the materialized view of all restructuring in this location. 585. DBA_REGISTERED_MVIEWS

All registered material views in the database.

586. DBA_REGISTERED_SNAPSHOT_GROUPS

List all snapshot registration groups in the site.

587. DBA_REGISTERED_SNAPSHOTS

Retrieve the information of the remote snapshot of the local table.

588. DBA_REPAIR_TABLE

Any damage found by the DBA_REPAIR.CHECK_OBJECT process.

589. DBA_RESUMABLE

List the recoverable statements executed in the system.

590. DBA_RGROUP

List all refresh groups.

591. DBA_ROLE_PRIVS

List the roles granted to the user role.

592. DBA_ROLES

All roles exist in the database.

593. DBA_ROLLBACK_SEGS

Contains a description of the rollback segment.

594. DBA_RSRC_CONSUMER_GROUP_PRIVS

List all authorized resource administrators, users, and roles.

595. DBA_RSRC_CONSUMER_GROUPS

All resource consumer groups in the database.

596. DBA_RSRC_MANAGER_SYSTEM_PRIVS

List all users and roles that have been granted to the resource administrator system privilege.

597. DBA_RSRC_PLAN_DIRECTIVES

An indication of all resource plans existing in the database.

598. DBA_RSRC_PLANS

All resource plans existing in the database.

599. DBA_SEGMENTS

Allocated to all database segments.

600. DBA_SEQUENCES

Description of all sequences in the database.

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

New Post(0)