Oracle Common fool question 1000 Q (Ten)

oracle| problem
Oracle Common fool question 1000 Q (Ten)



Author: ccbzzp



9I managed data Dictionary DBA view.

485. dba_2pc_neighbors

Contains connection information for the introduction or outflow of pending transactions.

486. Dba_all_tables

Displays a description of all the tables in the database.

487. Dba_application_roles

All roles that have the validation policy defined by the function.

488. dba_associations

Displays user-defined statistics.

489. dba_audit_exists

Lists audit trails generated by audit not exists and audit exists.

490. Dba_audit_object

Audit trail records for all objects in the system.

491. Dba_audit_session

Lists all audit trail information about connect and disconnect.

492. dba_audit_statement

Lists audit trail information about the Grant,revoke,audit,noaudit,alter system statement.

493. Dba_audit_trail

Lists all audit trail entries.

494. Dba_blockers

Lists all sessions that are waiting for a lock to be held by a session, but not themselves waiting for a lock.

495. dba_base_table_mviews

Describes all materialized views in a database.

496. Dba_catalog

Lists all database labels, views, synonyms, and sequences.

497. Dba_clu_columns

Lists the mappings for table columns to clustered columns.

498. dba_cluster_hash_expressions

Lists all clustered hash functions.

499. Dba_clusters

Contains a description of all the aggregates in the database.

Dba_col_comments.

Annotations for columns for all tables and views.

501. Dba_col_privs

Lists all the privileges granted to the column in the database.

502. Dba_coll_types

Displays all named collection types in the database.

503. Dba_cons_columns

Information that is included in the constraint definition for an accessible column.

504. dba_constraints

The definition of constraints on all tables.

505. Dba_context

Information for all context name spaces.

506. Dba_data_files

Information about the database file.

507. Dba_db_links

All database links in the database.

508. Dba_ddl_locks

All DDL locks held by the database.

509. dba_dependencies

Lists the dependencies between objects.

510. dba_dim_attributes

Represents the relationship between a dimension and a feature-dependent column.

511. Dba_dim_join_key

Represents a connection between two dimensions.

Dba_dim_level_key.

Represents a dimension-level column.

513. Dba_dim_levels

Represents a dimension level.

514. dba_dimensions

Represents a Dimension object.

515. dba_directories

Provides information about all objects in a database.

516. Dba_dml_locks

Lists all DML locks in the database and the pending requests to a DML lock.

517. dba_errors

Lists the current errors for all objects stored in the database.

518. Dba_exp_files

Contains information about the exported file.

519. dba_exp_objects

Lists the objects that are exported incrementally.

520. Dba_exp_version

Contains the version number of the last exported session.

521. dba_extents

Lists the information that makes up all the segments in the database.

522. Dba_external_tables

Describes all the external tables in the database.

523. Dba_free_space

Lists the free partitions in all table spaces.

524. dba_free_space_coalesced

Contains statistical data for the merged space in the tablespace.

525. Dba_histograms

is synonymous with dba_tab_histograms.

526. Dba_ind_columns

Contains a description of the columns that make up the index in all tables and aggregates.

527. dba_ind_expressions

An expression that contains a functional index in all tables and aggregates.

528. Dba_ind_partitions

For each index partition, it describes partition-level partition information, partitioning storage parameters, and various partition statistics for analyze decisions.

529. dba_ind_subpartitions

Each index partition that is owned by the current user, describing partition-level information, partitioning storage parameters, and various analyze decisions



District statistic data.

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

Lists all the operators supported by the index type.

Dba_indextypes.

All of the index types.

534. Dba_internal_triggers

All internal triggers in the database.

535. Dba_jobs

All the jobs in the database.

536. dba_jobs_runing

All currently running jobs in the database.

537. Dba_join_ind_columns

Describes all the join conditions in the database.

538. Dba_kgllock

Lists all the locks and pins on the Kgl object.

539. dba_libraries

Lists all the libraries in the database.

540. Dba_lob_partitions

A job that is accessible to a user that is contained in a table.

541. dba_lob_subpartitions

Displays the partition-level attributes in the LOB data child partitions.

542. Dba_lobs

The lob that is contained in all tables.

543. dba_lock_internal

A line of information that contains each lock or simple lock held, and one row of each pending request.

544. dba_locks

Lists the locks or simple locks held in the database, and each pending request information.

545. Dba_log_group_columns

Describes the information for all columns in the database specified in the log group.

546. Dba_method_params

A description of the method parameters of the type in the database.

547. Dba_method_results

A description of the method results for all types in the database.

548. dba_mview_aggregates

The grouping function that appears in the select list of the clustered materialized view.

549. dba_mview_analysis

Represents a potential support for query rewriting.

Dba_mview_log_filter_cols.

Lists all the columns that are recorded in the materialized view log.

551. Dba_mview_refresh_times

Describes the refresh time for all materialized views in the database.

552. Dba_mviews

Describes all materialized views in a database.

553. Dba_nested_tables

A description of nested tables in all tables.

554. dba_obj_audit_opts

Lists auditing options for all objects for a user.

555. dba_object_size

Lists the sizes of the various objects in bytes.

556. Dba_object_tables

Displays a description of all the object tables in the database.

557. dba_objects

Lists all the objects in the database.

558. Dba_opancillary

Lists additional information for action connectors.

559. dba_oparguments

Lists the parameter information for the action connector.

560. Dba_orphan_key_table

Reports the key values in indexes that have bad blocks under the base table.

561. dba_outline_hints

Lists the prompts that make up the outline.

562. Dba_outlines

Lists information about the profile.

563. Dba_part_col_statistics

Column statistics and histogram information for all partitioned tables.

564. Dba_part_histograms

Histogram data for histograms on all table partitions.

565. dba_part_indexes

Object-level partition information for all partitioned indexes.

566. Dba_part_key_columns

The partitioning key column for all partitioned objects.

567. Dba_part_lobs

Describes table-level information for partitioned lobs.

568. Dba_part_tables

Lists the object-level partition information for all partitioned tables.

569. Dba_partial_drop_tabs

Describes a partially deleted table.

570. Dba_pending_transactions

Provides information about unfinished transactions.

571. dba_policies

Lists all the security policies in the database.

572. dba_priv_audit_opts

Current system privileges that are audited by the system and by the user.

573. Dba_procedures

All functions and processes and their associated properties.

574. Dba_profiles

Displays all startup files and restrictions.

575. dba_proxies

Displays information about all agent connections in the system.

576. Dba_published_columns

Describes all tables that have source columns.

577. Dba_queue_schedules

Describes the scenarios in which information is currently propagated.

578. Dba_queue_tables

Describes the names and types of queues in all queue tables established in the database.

579. dba_queues

Describes the operational characteristics of each queue in a database.

580. Dba_rchild

Lists any of the subgroups in the refresh group.

581. Dba_refresh

Lists all refresh groups.

582. Dba_refresh_children

Lists all objects in the refresh group.

583. Dba_refs

The ref and REF attributes in the object Type column of all tables in the database.

584. dba_registered_mview_groups

Lists all the materialized views of the reorganization at the site.

585. Dba_registered_mviews

All materialized views registered in the database.

586. dba_registered_snapshot_groups

Lists all snapshot enrollment groups for the site.

587. dba_registered_snapshots

Retrieves information about a remote snapshot of a local table.

588. dba_repair_table

Through the Dba_repair. Any damage found by the check_object process.

589. dba_resumable

Lists the recoverable statements that are executed in the system.

590. Dba_rgroup

Lists all refresh groups.

591. Dba_role_privs

Lists the roles that are granted to the user role.

592. Dba_roles

All roles that exist in the database.

593. Dba_rollback_segs

Contains a description of the rollback segment.

594. Dba_rsrc_consumer_group_privs

Lists all authorized resource Manager consumption groups, users, and roles.

595. dba_rsrc_consumer_groups

All resource consumption groups in the database.

596. Dba_rsrc_manager_system_privs

Lists all users and roles that have been granted privileges belonging to the Resource manager system.

597. dba_rsrc_plan_directives

The instructions for all resource plans that exist in the database.

598. Dba_rsrc_plans

All resource plans that exist in the database.

599. dba_segments

The storage information that is assigned to all database segments.

Dba_sequences.

A description of all the sequences in the database.

601. Dba_snapshot_log_filter_cols

Lists all the filtered columns that are recorded on the snapshot log.

602. Dba_snapshot_logs

All snapshot logs in the database.

603. Dba_snapshot_refresh_times

Lists the number of snapshot refreshes.

604. Dba_snapshots

All snapshots in the database.

605. Dba_source

The source of all the stored objects in the database.

606. Dba_source_tables

Allows publishers to view all existing source tables.

607. Dba_sqlj_type_attrs

All properties in the database about the Sqlj object.

608. Dba_sqlj_type_methods

All types of methods in the database.

609. Dba_sqlj_types

All information about the Sqlj object type in the database.

610. dba_stmt_audit_opts

Describes the current system audit options that are audited by the system and by the user.

611. Dba_stored_settings

Lists the persistent parameter setting information for the storage Pl/sql unit with executive privileges.

612. Dba_subpart_col_statistics

Lists the column statistics and histogram information for the table's child partitions.

613. Dba_subpart_histograms

Lists the actual data for a straight square graph in the table sub partition.

614. Dba_subpart_key_columns

Allows publishers to view all published columns that they have scheduled.

615. Dba_subpart_tables

Allow publishers to view all published tables they have scheduled.

616. Dba_subscriptions

Allow publishers to view all bookings.

617. dba_synonyms

All synonyms in the database.

618. Dba_sys_privs

System privileges granted to users and roles.

619. Dba_tab_col_statistics

Column statistics and histogram information contained in the Dba_tab_columns view.

620. Dba_tab_columns

Information for all tables, views, and clustered descriptive columns.

621. dba_tab_comments

Annotations for all columns and tables in the database.

622. Dba_tab_histograms

Histograms of columns in all tables.

623. dba_tab_modifications

Displays all tables in the database that have been modified since they were last counted.

624. Dba_tab_partitions

A partition of a table that describes its partition-level partition information, the storage parameters of the partition, and the various partition statistics determined by analyze.

625. Dba_tab_privs

Lists the system privileges for the role granted to the user.

626. dba_tab_subpartitions

For a child partition of a table, describe its partition-level partition information, the storage parameters of the partition, and the various partition statistics determined by analyze.

627. Dba_tables

A description of all the 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 message delivery information in the database.

631. Dba_trigger_cols

The use of all trigger columns.

632. Dba_triggers

All triggers in the database.

633. Dba_ts_quotas

The amount of table space for all users.

634. Dba_type_attrs

The properties of the database type.

635. Dba_type_methods

Describes methods for all types in the database.

636. Dba_types

All of the abstract data types in the database.

637. dba_undo_extents

The submission time for each range in the undo tablespace.

638. Dba_unused_col_tabs

A description of all unused columns.

639. Dba_updatable_columns

A description of the column 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 view that the user 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 lists the sessions that are preventing them from acquiring the lock.



Cond...