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 33023 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tables

Tables Data Dictionary ViewsALL_EXTERNAL_LOCATIONS USER_EXTERNAL_LOCATIONS These views list the data sources for external tables … , such as name, data type, length, precision, scale, and default data values can be listed using one

Database Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle Scheduler

Scheduler Data Dictionary ViewsYou can check Scheduler information by using many views. An example is the following, which shows information for completed instances of my_job1: SELECT JOB_NAME, STATUS, ERROR# FROM DBA_SCHEDULER_JOB_RUN_DETAILS WHERE JOB_NAME = 'MY_JOB1'; JOB_NAME STATUS ERROR# -------- -------------- ------ MY_JOB1 FAILURE 20000 Table 30-5 contains views associated with the Scheduler. The *_SCHEDULER_JOBS, *_SCHEDULER_SCHEDULES,

Database Administrator's Guide, 11g Release 2 (11.2)

Creating and Configuring an Oracle Database

Database Data Dictionary ViewsIn addition to the views listed previously in \"Viewing Parameter Settings\", you can view information about your database content and structure using the following views: View Description DATABASE_PROPERTIES Displays permanent database properties GLOBAL_NAME Displays the global database name V$DATABASE Contains database information from the control file

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Clusters

Clusters Data Dictionary ViewsThe following views display information about clusters: View Description DBA_CLUSTERS ALL_CLUSTERS USER_CLUSTERS DBA view describes all clusters in the database. ALL view describes all clusters accessible to the user. USER view is restricted to clusters owned by the user. Some columns in these views contain statistics that are generated by the DBMS_STATS package or ANALYZE statement. DBA_CLU_COLUMNS

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Tablespaces

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, 11g Release 2 (11.2)

Managing Schema Objects

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

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Indexes

Indexes Data Dictionary ViewsThe following views display information about indexes: View Description DBA_INDEXES ALL_INDEXES USER_INDEXES DBA view describes indexes on all tables in the database. ALL view describes indexes on all tables accessible to the user. USER view is restricted to indexes owned by the user. Some columns in these views contain statistics that are generated by the DBMS_STATS package or ANALYZE statement.

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Data Files and Temp Files

Data Files Data Dictionary ViewsThe following data dictionary views provide useful information about the data files of a database … : View Description DBA_DATA_FILES Provides descriptive information about each data file, including the … segments in the database. Contains the file ID of the data file containing the extent. USER view

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Control Files

Control Files Data Dictionary ViewsThe following views display information about control files: View Description V$DATABASE Displays database information from the control file V$CONTROLFILE Lists the names of control files V$CONTROLFILE_RECORD_SECTION Displays information about control file record sections V$PARAMETER Displays the names of control files as specified in the CONTROL_FILES initialization parameter This example lists the

Database Administrator's Guide, 11g Release 2 (11.2)

Creating and Configuring an Oracle Database

Database Service Data Dictionary ViewsYou can find service information in the following service-specific views: DBA_SERVICES ALL_SERVICES or V$SERVICES V$ACTIVE_SERVICES V$SERVICE_STATS V$SERVICE_EVENT V$SERVICE_WAIT_CLASSES V$SERV_MOD_ACT_STATS V$SERVICE_METRICS V$SERVICE_METRICS_HISTORY The following additional views also contain some information about services: V$SESSION V$ACTIVE_SESSION_HISTORY DBA_RSRC_GROUP_MAPPINGS DBA_SCHEDULER_JOB_CLASSES

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Hash Clusters

Hash Clusters Data Dictionary ViewsThe following views display information about hash clusters: View Description DBA_CLUSTERS ALL_CLUSTERS USER_CLUSTER S DBA view describes all clusters (including hash clusters) in the database. ALL view describes all clusters accessible to the user. USER view is restricted to clusters owned by the user. Some columns in these views contain statistics that are generated by the DBMS_STATS package or

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Schema Objects

Schema Objects Data Dictionary Viewscomplete description of data dictionary views The following are examples of using some of these views … , and DBA_SYNONYMS data dictionary views can be used to list the base object of a synonym. For example … on its underlying base object. The ALL _DEPENDENCIES, USER_DEPENDENCIES, and DBA_DEPENDENCIES data

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Undo

Undo Space Data Dictionary ViewsFiles Data Dictionary Views\" for information on getting information about those views. The following … information from the views available for viewing tablespace and data file information. See \"Data … marked by ( BEGIN_TIME, END_TIME ). Each column represents the data collected for the particular

Database Administrator's Guide, 11g Release 2 (11.2)

Monitoring Database Operations

Performance Monitoring Data Dictionary ViewsThis section lists some of the data dictionary views that you can use to monitor an Oracle Database

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Memory

Memory Management Data Dictionary ViewsThe following dynamic performance views provide information on memory management: View Description V$SGA Displays summary information about the system global area (SGA). V$SGAINFO Displays size information about the SGA, including the sizes of different SGA components, the granule size, and free memory. V$SGASTAT Displays detailed information about how memory is allocated within the shared pool, large

Database Administrator's Guide, 11g Release 2 (11.2)

Managing the Redo Log

Redo Log Data Dictionary ViewsThe following views provide information on redo logs. View Description V$LOG Displays the redo log file information from the control file V$LOGFILE Identifies redo log groups and members and member status V$LOG_HISTORY Contains log history information The following query returns the control file information about the redo log for a database. SELECT * FROM V$LOG; GROUP# THREAD# SEQ BYTES MEMBERS ARC

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Processes

Shared Server Data Dictionary ViewsThe following views are useful for obtaining information about your shared server configuration and for monitoring performance. View Description V$DISPATCHER Provides information on the dispatcher processes, including name, network address, status, various usage statistics, and index number. V$DISPATCHER_CONFIG Provides configuration information about the dispatchers. V$DISPATCHER_RATE Provides rate

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Resources with Oracle Database Resource Manager

Resource Manager Data Dictionary ViewsTable 27-7 lists views that are associated with the Resource Manager.

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Processes

Process and Session Data Dictionary ViewsThe following are the data dictionary views that can help you manage processes and sessions. View

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Space for Schema Objects

Schema Objects Space Usage Data Dictionary Viewsdescription of data dictionary views Example 1: Displaying Segment Information The following query … database is stored in the DBA_EXTENTS data dictionary view. For example, the following query … any segment) in a database is stored in the DBA_FREE_SPACE data dictionary view. For example,