You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for data dictionary


1 to 20 of 31069 results. Previous page Prev  Next next page
Results per page:  20 | 40 |  60 


Database Concepts, 12c Release 1 (12.1)

Data Dictionary and Dynamic Performance Views

Overview of the Data DictionaryAn important part of an Oracle database is its data dictionary, which is a read-only set of tables … that provides administrative metadata about the database. A data dictionary contains information … , and auditing information related to users The data dictionary is a central part of

Database Concepts, 12c Release 1 (12.1)

Data Dictionary and Dynamic Performance Views

Contents of the Data DictionaryThe data dictionary consists of base tables and views. These objects are defined as follows: Base … the names and description of all objects in the data dictionary. Some views are accessible to all … database users, whereas others are intended for administrators only. Typically, data dictionary

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Schema Objects

18.10.7 Editions Data Dictionary ViewsThere are several data dictionary views that aid with managing editions. The following table lists

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Indexes

21.7 Indexes Data Dictionary ViewsYou can query a set of data dictionary views for information about indexes. The following views

Database Concepts, 12c Release 1 (12.1)

Data Dictionary and Dynamic Performance Views

Storage of the Data Dictionaryis a small table in the data dictionary that Oracle Database and user-written programs can … the Data Dictionary The data dictionary base tables are the first objects created in any Oracle … database. All data dictionary tables and views for a database

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Tables

20.14 Tables Data Dictionary ViewsYou can query a set of data dictionary views for information about tables. The following views … USER_EXTERNAL_LOCATIONS These views list the data sources for external tables. DBA_TAB_HISTOGRAMS … a system failure. Example: Displaying Column Information Column information, such as name, data type … , length, precision,

Database Administrator's Guide, 12c Release 1 (12.1)

Administering Oracle Scheduler

30.6.2 Scheduler Data Dictionary Viewsjobs by Oracle Data Guard database role. *_SCHEDULER_JOB_RUN_DETAILS These views show all completed

Database Administrator's Guide, 12c Release 1 (12.1)

Creating and Configuring an Oracle Database

2.12 Database Data Dictionary ViewsYou can query data dictionary views for information about your database content and structure. You

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Clusters

22.6 Clusters Data Dictionary ViewsYou can query a set of data dictionary views for information about clusters. The following views

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Tablespaces

13.14.1 Tablespace Data Dictionary ViewsThe following data dictionary and dynamic performance views provide useful information about the … , USER_EXTENTS Information about data extents within all (or user accessible) tablespaces. DBA_FREE_SPACE … Information about all data files, including tablespace number of owning tablespace. V$TEMPFILE Information

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Data Files and Temp Files

14.10 Data Files Data Dictionary Views… f _sym_hyper_000183600407_00E_1 6 8 14.10 Data Files Data Dictionary Views A set of data dictionary … Its Corresponding Devices An example displays a topological graph of a data file. The following query … displays a topological graph of the /oracle/dbs/t_db1.f data

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Resources with Oracle Database Resource Manager

27.13.3 Resource Manager Data Dictionary ViewsYou can query a set of data dictionary views for information relating to database resource … Manager Data Dictionary Views View Description DBA_RSRC_CONSUMER_GROUP_PRIVS

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Control Files

10.8 Control Files Data Dictionary ViewsYou can query a set of data dictionary views for information about control files. The following

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Processes

5.9 Process and Session Data Dictionary ViewsYou can query data dictionary views for information about processes and sessions. View Description

Database Administrator's Guide, 12c Release 1 (12.1)

Monitoring the Database

8.2.3 Performance Monitoring Data Dictionary ViewsYou can query a set of data dictionary views to monitor an Oracle Database instance. These views

Database Concepts, 12c Release 1 (12.1)

Overview of the Multitenant Architecture

Data Dictionary Architecture in a CDBAdministrator's Guide to learn how to access objects in other PDBs using database links Data Dictionary … Architecture in a CDB From the user and application perspective, the data dictionary in each container in a … different number of rows. This dictionary separation enables Oracle Database to manage

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Schema Objects

18.11.2 Schema Objects Data Dictionary Viewsobject. The ALL_DEPENDENCIES, USER_DEPENDENCIES, and DBA_DEPENDENCIES data dictionary views can be used … to reveal the dependencies for a view. The ALL _SYNONYMS, USER_SYNONYMS, and DBA_SYNONYMS datadictionary views can be used to list the base object of a synonym. For example, the following query lists

Database Administrator's Guide, 12c Release 1 (12.1)

Creating and Configuring an Oracle Database

2.8.3 Database Service Data Dictionary ViewsYou can query data dictionary views to find information about database services. You can find

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Processes

5.3.6 Shared Server Data Dictionary ViewsYou can query data dictionary views for information about your shared server configuration and to

Database Administrator's Guide, 12c Release 1 (12.1)

Managing the Redo Log

11.10 Redo Log Data Dictionary ViewsYou can query a set of data dictionary views for information about the redo log. The following