How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
Overview of the Data Dictionary → An 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
Contents of the Data Dictionary → The 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
18.10.7 Editions Data Dictionary Views → There are several data dictionary views that aid with managing editions. The following table lists
21.7 Indexes Data Dictionary Views → You can query a set of data dictionary views for information about indexes. The following views
Storage of the Data Dictionary → is 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
20.14 Tables Data Dictionary Views → You 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,
30.6.2 Scheduler Data Dictionary Views → jobs by Oracle Data Guard database role. *_SCHEDULER_JOB_RUN_DETAILS These views show all completed
2.12 Database Data Dictionary Views → You can query data dictionary views for information about your database content and structure. You
22.6 Clusters Data Dictionary Views → You can query a set of data dictionary views for information about clusters. The following views
13.14.1 Tablespace Data Dictionary Views → The 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
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
27.13.3 Resource Manager Data Dictionary Views → You 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
10.8 Control Files Data Dictionary Views → You can query a set of data dictionary views for information about control files. The following
5.9 Process and Session Data Dictionary Views → You can query data dictionary views for information about processes and sessions. View Description
8.2.3 Performance Monitoring Data Dictionary Views → You can query a set of data dictionary views to monitor an Oracle Database instance. These views
Data Dictionary Architecture in a CDB → Administrator'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
18.11.2 Schema Objects Data Dictionary Views → object. 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 data … dictionary views can be used to list the base object of a synonym. For example, the following query lists
2.8.3 Database Service Data Dictionary Views → You can query data dictionary views to find information about database services. You can find
5.3.6 Shared Server Data Dictionary Views → You can query data dictionary views for information about your shared server configuration and to