Oracle faq one thousand [501 to 600]

501. DBA_COL_PRIVS
Lists all the privileges granted to columns in the database.
502. DBA_COLL_TYPES
Displays all named set types in the database.
503. DBA_CONS_COLUMNS
Information of accessible columns contained in the constraint definition.
504. DBA_CONSTRAINTS
All table constraints.
505. DBA_CONTEXT
Information of all context namespaces.
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
Lists dependencies between objects.
510. DBA_DIM_ATTRIBUTES
Represents the relationship between dimension-level and feature-dependent columns.
511. DBA_DIM_JOIN_KEY
Represents the connection between two dimensions.
512 DBA_DIM_LEVEL_KEY
Represents a dimension column.
513. DBA_DIM_LEVELS
Represents a dimension.
514. DBA_DIMENSIONS
Represents a dimension object.
515. DBA_DIRECTORIES
Provides information about all objects in the database.
516. DBA_DML_LOCKS
Lists All DML locks in the database and pending requests to a DML lock.
517. DBA_ERRORS
The current error that lists all stored objects in the database.
518. DBA_EXP_FILES
Contains information about the exported file.
519. DBA_EXP_OBJECTS
Lists the objects exported in incremental mode.
520. DBA_EXP_VERSION
Contains the version number of the last exported session.
521. DBA_EXTENTS
Lists information about all segments in a database.
522. DBA_EXTERNAL_TABLES
Describes all external tables in the database.
523. DBA_FREE_SPACE
Lists free partitions in all tablespaces.
524. DBA_FREE_SPACE_COALESCED
Contains the statistical data of the merged space in the tablespace.
525. DBA_HISTOGRAMS
Synonym for DBA_TAB_HISTOGRAMS.
526. DBA_IND_COLUMNS
Description of the columns that are indexed in all tables and clusters.
527. DBA_IND_EXPRESSIONS
Expressions that are included in all tables and function indexes in the cluster.
528. DBA_IND_PARTITIONS
For each index partition, describe the partition information at the partition level, the storage parameters of the partition and the statistics of various partitions determined by ANALYZE.
529. DBA_IND_SUBPARTITIONS
For each index partition owned by the current user, describe partition-level partition information, storage parameters of the partition, and various partition statistics determined by ANALYZE.
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 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_RUNING
All currently running jobs in the database.
537. DBA_JOIN_IND_COLUMNS
Describes all the connection conditions in the database.
538. DBA_KGLLOCK
Lists all the locks and PINS on the KGL object.
539. DBA_LIBRARIES
List all databases in the database.
540. DBA_LOB_PARTITIONS
Jobs that can be accessed by users in the table.
541. DBA_LOB_SUBPARTITIONS
Display the shard-level attribute in the LOB data subpartition.
542. DBA_LOBS
LOB contained in all tables.
543. DBA_LOCK_INTERNAL
Contains the information of each row held by the lock or simple lock, and the information of one row of each pending request.
544. DBA_LOCKS
Lists the locks or simple locks held in the database, and information about each pending request.
545. DBA_LOG_GROUP_COLUMNS
Describes the information of all columns in the database specified in the log group.
546. DBA_METHOD_PARAMS
Description of method parameters of the database type.
547. DBA_METHOD_RESULTS
Description of the results of all types of methods in the database.
548. DBA_MVIEW_AGGREGATES
The grouping function that appears in the SELECT list of the clustered instantiation view.
549. DBA_MVIEW_ANALYSIS
This indicates that query rewriting is supported.
550. DBA_MVIEW_LOG_FILTER_COLS
Lists All columns of all records in the materialized view log.
551. DBA_MVIEW_REFRESH_TIMES
The refresh time of all materialized views in the database.
552. DBA_MVIEWS
Describes all materialized views in the database.
553. DBA_NESTED_TABLES
Description of nested tables in all tables.
554. DBA_OBJ_AUDIT_OPTS
Lists Audit options for all objects of a user.
555. DBA_OBJECT_SIZE
Lists the sizes of various objects in bytes.
556. DBA_OBJECT_TABLES
Displays the descriptions of all object tables in the database.
557. DBA_OBJECTS
Lists all objects in a database.
558. DBA_OPANCILLARY
Lists additional information about the operation connector.
559. DBA_OPARGUMENTS
Lists the parameter information of the Operation connector.
560. DBA_ORPHAN_KEY_TABLE
Report the key values of indexes with bad blocks in the base table.
561. DBA_OUTLINE_HINTS
List the prompts that make up the summary.
562. DBA_OUTLINES
Lists the summary information.
563. DBA_PART_COL_STATISTICS
Column statistics and histogram information of all partition tables.
564. DBA_PART_HISTOGRAMS
Histogram data of the histograms on all table partitions.
565. DBA_PART_INDEXES
Object-level partition information of all partition indexes.
566. DBA_PART_KEY_COLUMNS
Partition key columns of all partition objects.
567. DBA_PART_LOBS
Describes the table-level information of the LOB partition.
568. DBA_PART_TABLES
Lists the object-level partition information of all partition tables.
569. DBA_PARTIAL_DROP_TABS
Description of the table to be deleted.
570. DBA_PENDING_TRANSACTIONS
Provide information about unfinished transactions.
571. DBA_POLICIES
Lists all the security policies in the database.
572. DBA_PRIV_AUDIT_OPTS
Privileges of the system and the current system audited by the user.
573. DBA_PROCEDURES
All functions and procedures and their related attributes.
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
Describes all tables with source columns.
577. DBA_QUEUE_SCHEDULES
Describes the current information dissemination plan.
578. DBA_QUEUE_TABLES
Describes the name and type of the queue in the list of all teams created in the database.
579. DBA_QUEUES
Describes the operation features of each queue in the database.
580. DBA_RCHILD
Lists all sub-groups in any 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 columns of all tables in the database.
584. DBA_REGISTERED_MVIEW_GROUPS
Lists the materialized views of all reorganization at the location.
585. DBA_REGISTERED_MVIEWS
All registered materialized views in the database.
586. DBA_REGISTERED_SNAPSHOT_GROUPS
List all snapshot registration groups for the site.
587. DBA_REGISTERED_SNAPSHOTS
Retrieves remote snapshots of a local table.
588. DBA_REPAIR_TABLE
Any damages discovered through the DBA_REPAIR.CHECK_OBJECT process.
589. DBA_RESUMABLE
Lists recoverable statements executed in the system.
590. DBA_RGROUP
Lists All refresh groups.
591. DBA_ROLE_PRIVS
Lists the roles granted to a user role.
592. DBA_ROLES
All roles in the database.
593. DBA_ROLLBACK_SEGS
Description of the rollback segment.
594. DBA_RSRC_CONSUMER_GROUP_PRIVS
Lists All authorized resource administrator 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 to the resource administrator system.
597. DBA_RSRC_PLAN_DIRECTIVES
Indicates all resource plans in the database.
598. DBA_RSRC_PLANS
All resource plans in the database.
599. DBA_SEGMENTS
Storage Information allocated to all database segments.
600. DBA_SEQUENCES
Description of all sequences in the database.