Results for data dictionary


1 to 60 of 23766 results. Prev  Next
Results per page:  20 | 40 |  60 


Database Administrator's Guide, 11g Release 1 (11.1)

Database Data Dictionary Views

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 1 (11.1)

Tables Data Dictionary Views

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

Database Administrator's Guide, 11g Release 1 (11.1)

Scheduler Reference

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 28-3 contains views associated with the Scheduler. The *_SCHEDULER_JOBS, *_SCHEDULER_SCHEDULES,

Database Administrator's Guide, 11g Release 1 (11.1)

Datafiles Data Dictionary Views

Datafiles Data Dictionary ViewsThe following data dictionary views provide useful information about the datafiles of a database

Database Administrator's Guide, 11g Release 1 (11.1)

Tablespace Data Dictionary Views

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

Database Administrator's Guide, 11g Release 1 (11.1)

Indexes Data Dictionary Views

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 1 (11.1)

Clusters Data Dictionary Views

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 1 (11.1)

Monitoring Performance

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 1 (11.1)

Control Files Data Dictionary Views

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 1 (11.1)

Redo Log Data Dictionary Views

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 1 (11.1)

Undo Space Data Dictionary Views

Undo Space Data Dictionary Views\"Datafiles Data Dictionary Views\" for information on getting information about those views. The … to the time interval marked by ( BEGIN_TIME, END_TIME ). Each column represents the data collected

Database Administrator's Guide, 11g Release 1 (11.1)

Memory Management Reference

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 1 (11.1)

Oracle Database Resource Manager Reference

Resource Manager Data Dictionary ViewsData Dictionary Views View Description DBA_RSRC_CONSUMER_GROUP_PRIVS USER_RSRC_CONSUMER_GROUP_PRIVS

Database Administrator's Guide, 11g Release 1 (11.1)

Displaying Information About Schema Objects

Schema Objects Data Dictionary Viewscomplete description of data dictionary views The following are examples of using some of these views

Database Administrator's Guide, 11g Release 1 (11.1)

Hash Clusters Data Dictionary Views

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 1 (11.1)

Configuring Oracle Database for Shared Server

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 1 (11.1)

Process and Session Data Dictionary Views

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 1 (11.1)

Purging Pending Rows from the Data Dictionary

Purging Pending Rows from the Data DictionaryBefore RECO recovers an in-doubt transaction, the transaction appears in DBA_2PC_PENDING.STATE as COLLECTING, COMMITTED, or PREPARED. If you force an in-doubt transaction using COMMIT FORCE or ROLLBACK FORCE, then the states FORCED COMMIT or FORCED ROLLBACK may appear. Automatic recovery normally deletes entries in these states. The only exception is when recovery discovers a forced transaction that

Database Administrator's Guide, 11g Release 1 (11.1)

Views, Synonyms, and Sequences Data Dictionary Views

Views, Synonyms, and Sequences Data Dictionary ViewsThe following views display information about views, synonyms, and sequences: View Description DBA_VIEWS ALL_VIEWS USER_VIEWS DBA view describes all views in the database. ALL view is restricted to views accessible to the current user. USER view is restricted to views owned by the current user. DBA_SYNONYMS ALL_SYNONYMS USER_SYNONYMS These views describe synonyms. DBA_SEQUENCES ALL_SEQUENCES USER_SEQUENCES

Database Administrator's Guide, 11g Release 1 (11.1)

Displaying Information About Space Usage for Schema Objects

Schema Objects Space Usage Data Dictionary Viewscontain examples of using some of these views. See Also: Oracle Database Reference for a complete description of data dictionary views

Database Administrator's Guide, 11g Release 1 (11.1)

Monitoring Errors and Alerts

Server-Generated Alerts Data Dictionary ViewsThe following data dictionary views provide information about server-generated alerts. View … : Oracle Database Reference for information on static data dictionary views and dynamic performance views

Database Administrator's Guide, 11g Release 1 (11.1)

Manually Committing an In-Doubt Transaction: Example

Step 4: Querying Data Dictionary Views on All NodesAt this point, you can contact the administrator at the located nodes and ask each person to repeat Steps 2 and 3 using the global transaction ID. Note: If you can directly connect to these nodes with another network, you can repeat Steps 2 and 3 yourself. For example, the following results are returned when Steps 2 and 3 are performed at sales and hq.

Database Administrator's Guide, 11g Release 1 (11.1)

Configuring Database Resident Connection Pooling

Data Dictionary Views for Database Resident Connection PoolingTable 4-3 lists the data dictionary views that provide information about database resident … performance of database resident connection pooling. Table 4-3 Data Dictionary Views for Database

Database Administrator's Guide, 11g Release 1 (11.1)

Creating a Database with the CREATE DATABASE Statement

Step 11: Run Scripts to Build Data Dictionary ViewsRun the scripts necessary to build data dictionary views, synonyms, and PL/SQL packages, and to … data dictionary tables, the dynamic performance views, and public synonyms for many of the views

Database Administrator's Guide, 11g Release 1 (11.1)

Tablespace Data Dictionary Views

Example 3: Displaying Statistics for Free Space (Extents) of Each TablespaceTo produce statistics about free extents and coalescing activity for each tablespace in the database, enter the following query: SELECT TABLESPACE_NAME \"TABLESPACE\", FILE_ID, COUNT(*) \"PIECES\", MAX(blocks) \"MAXIMUM\", MIN(blocks) \"MINIMUM\", AVG(blocks) \"AVERAGE\", SUM(blocks) \"TOTAL\" FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME, FILE_ID; TABLESPACE FILE_ID PIECES MAXIMUM MINIMUM AVERAGE

Database Administrator's Guide, 11g Release 1 (11.1)

Tablespace Data Dictionary Views

Example 2: Listing the Datafiles and Associated Tablespaces of a DatabaseTo list the names, sizes, and associated tablespaces of a database, enter the following query on the DBA_DATA_FILES view: SELECT FILE_NAME, BLOCKS, TABLESPACE_NAME FROM DBA_DATA_FILES; FILE_NAME BLOCKS TABLESPACE_NAME ------------ ---------- ------------------- /U02/ORACLE/IDDB3/DBF/RBS01.DBF 1536 RBS /U02/ORACLE/IDDB3/DBF/SYSTEM01.DBF 6586 SYSTEM /U02/ORACLE/IDDB3/DBF/TEMP01.DBF 6400 TEMP /U02/ORACLE/IDDB3/DBF/TESTTBS01.DBF

Database Administrator's Guide, 11g Release 1 (11.1)

Tablespace Data Dictionary Views

Example 1: Listing Tablespaces and Default Storage ParametersTo list the names and default storage parameters of all tablespaces in a database, use the following query on the DBA_TABLESPACES view: SELECT TABLESPACE_NAME \"TABLESPACE\", INITIAL_EXTENT \"INITIAL_EXT\", NEXT_EXTENT \"NEXT_EXT\", MIN_EXTENTS \"MIN_EXT\", MAX_EXTENTS \"MAX_EXT\", PCT_INCREASE FROM DBA_TABLESPACES; TABLESPACE INITIAL_EXT NEXT_EXT MIN_EXT MAX_EXT PCT_INCREASE ---------- -----------

Database Reference, 11g Release 1 (11.1)

Static Data Dictionary Views

Static Data Dictionary ViewsPart II Static Data Dictionary Views This part describes data dictionary tables and views. These … contains the following chapters: Chapter 2, \"Static Data Dictionary Views: ALL_ALL_TABLES to … ALL_OUTLINES\" Chapter 3, \"Static Data Dictionary Views:

Database Concepts, 11g Release 1 (11.1)

The Data Dictionary

7 The Data Dictionarydatabase, known collectively as the data dictionary. This chapter contains the following topics … : Introduction to the Data Dictionary How the Data Dictionary Is Used Dynamic Performance Tables Database Object Metadata

Database Reference, 11g Release 1 (11.1)

Creating the Data Dictionary

Creating the Data Dictionarycreates the data dictionary. Thereafter, whenever the database is in operation, Oracle updates the datadictionary in response to every DDL statement. The data dictionary base tables are the first objects … data dictionary base tables store information

Database Concepts, 11g Release 1 (11.1)

The Data Dictionary

Introduction to the Data DictionaryOne of the most important parts of an Oracle database is its data dictionary, which is a read-only … set of tables that provides information about the database. A data dictionary contains: The … data dictionary is structured in tables and views, just like other database data.

Database Reference, 11g Release 1 (11.1)

Creating Additional Data Dictionary Structures

Creating Additional Data Dictionary Structuresoperating system Table B-2 Creating Additional Data Dictionary Structures

Database Reference, 11g Release 1 (11.1)

About Static Data Dictionary Views

About Static Data Dictionary ViewsData dictionary tables are not directly accessible, but you can access information in them through … data dictionary views. To list the data dictionary views available to you, query the view DICTIONARY … . Many data dictionary tables

Database Concepts, 11g Release 1 (11.1)

The Data Dictionary

Structure of the Data DictionaryThe data dictionary consists of the following: Base Tables: The underlying tables that store … the base tables of the data dictionary. These views decode the base table data into useful … . Users rarely access them directly because they are normalized, and most of the data is stored

Database Reference, 11g Release 1 (11.1)

Static Data Dictionary View Descriptions

Static Data Dictionary View DescriptionsThe remainder of this chapter describes the static data dictionary views in alphabetical order … . Press the \"Next\" button to go to the first static data dictionary view.

Database Performance Tuning Guide, 11g Release 1 (11.1)

The Query Optimizer

11.2.3 Query Optimizer Statistics in the Data DictionaryThe statistics used by the query optimizer are stored in the data dictionary. You can collect exact … or estimated statistics about physical storage characteristics and data distribution in these … must have statistics that are representative of the data. For table columns that contain values … with large variations

Database Administrator's Guide, 11g Release 1 (11.1)

Purging Pending Rows from the Data Dictionary

Executing the PURGE_LOST_DB_ENTRY ProcedureTo manually remove an entry from the data dictionary, use the following syntax (where trans_id is

Database Administrator's Guide, 11g Release 1 (11.1)

Purging Pending Rows from the Data Dictionary

Determining When to Use DBMS_TRANSACTIONThe following tables indicates what the various states indicate about the distributed transaction what the administrator's action should be: STATE Column State of Global Transaction State of Local Transaction Normal Action Alternative Action Collecting Rolled back Rolled back None PURGE_LOST_DB_ENTRY (only if autorecovery cannot resolve transaction) Committed Committed Committed None PURGE_LOST_DB_ENTRY

Database Concepts, 11g Release 1 (11.1)

The Data Dictionary

How the Data Dictionary Is UsedThe data dictionary has three primary uses: Oracle Database accesses the data dictionary to find … dictionary every time that a data definition language (DDL) statement is issued. Any Oracle Database … user can use the data dictionary as a read-only

Database Concepts, 11g Release 1 (11.1)

The Data Dictionary

SYS, Owner of the Data DictionaryThe Oracle Database user SYS owns all base tables and user-accessible views of the data dictionarydata in data dictionary tables can permanently and detrimentally affect the operation of a database. … contained in the SYS schema, because such activity can compromise data integrity.

Database Concepts, 11g Release 1 (11.1)

The Data Dictionary

How Oracle Database Uses the Data DictionaryData in the base tables of the data dictionary is necessary for Oracle Database to function … . Therefore, only Oracle Database should write or change data dictionary information. Oracle Database … provides scripts to modify the data dictionary tables when a database

Database Concepts, 11g Release 1 (11.1)

The Data Dictionary

How to Use the Data DictionaryThe views of the data dictionary serve as a reference for all database users. Access the data … are intended for database administrators only. The data dictionary is always available when the … database is open. It resides in the SYSTEM tablespace, which is always online. The data dictionary

Database Concepts, 11g Release 1 (11.1)

Introduction to Oracle Database

Overview of the Oracle Database Data DictionaryEach Oracle database has a data dictionary, which is a set of tables and views that serve as a … reference about the database. For example, a data dictionary stores information about both the logical … and physical structure of the database. A data dictionary also stores the valid users

Database Reference, 11g Release 1 (11.1)

DICTIONARY

DICTIONARYcontains descriptions of data dictionary tables and views. Column Datatype NULL Description

OLAP User's Guide, 11g Release 1 (11.1)

Administering Oracle OLAP

Static Data Dictionary ViewsAmong the static views of the database data dictionary are several that provide information about … analytic workspaces. Table 7-2 provides brief descriptions of them. All data dictionary views have … corresponding DBA and USER views. Table 7-2 Static Data Dictionary Views for OLAP View

OLAP User's Guide, 11g Release 1 (11.1)

Querying Dimensional Objects

Querying the Data Dictionaryobjects are not known -- then your application can retrieve this information from the data dictionary … . Among the static views of the database data dictionary are those that provide information about … dimensional objects. All OLAP metadata is stored in the data dictionary. A few of

Database Reference, 11g Release 1 (11.1)

Static Data Dictionary Views: DBA_HIST_LATCH to DBA_STORED_SETTINGS

5 Static Data Dictionary Views: DBA_HIST_LATCH to DBA_STORED_SETTINGSThis chapter contains the static data dictionary views DBA_HIST_LATCH through DBA_STORED_SETTINGS … . Press the \"Next\" button to go to the first static data dictionary view.

Database Reference, 11g Release 1 (11.1)

Static Data Dictionary Views: DBA_2PC_NEIGHBORS to DBA_HIST_JAVA_POOL_ADVICE

4 Static Data Dictionary Views: DBA_2PC_NEIGHBORS to DBA_HIST_JAVA_POOL_ADVICEGo to main content 558/1981 4 Static Data Dictionary Views: DBA_2PC_NEIGHBORS to … DBA_HIST_JAVA_POOL_ADVICE This chapter contains the static data dictionary views DBA_2PC_NEIGHBORS through … DBA_HIST_JAVA_POOL_ADVICE. Press the \"Next\" button to go to the first static data dictionary

Database Security Guide, 11g Release 1 (11.1)

Configuring Authentication

Table 3-3 Data Dictionary Views That Describe User AuthenticationView Description DBA_ROLES Displays the kind of authentication used for a database role to log in to the database, such as NONE or GLOBAL (query the AUTHENTICATION_TYPE column) DBA_USERS Among other user information, displays the following: The kind of authentication the user used to log in to the database, such as PASSWORD or EXTERNAL ( AUTHENTICATION_TYPE column) The release in which the user created

Database Reference, 11g Release 1 (11.1)

Static Data Dictionary Views: DBA_STREAMS_ADD_COLUMN to USER_XML_VIEWS

6 Static Data Dictionary Views: DBA_STREAMS_ADD_COLUMN to USER_XML_VIEWSThis chapter contains the static data dictionary views DBA_STREAMS_ADD_COLUMN through … USER_XML_VIEWS. Press the \"Next\" button to go to the first static data dictionary view.

Database Reference, 11g Release 1 (11.1)

Static Data Dictionary Views: ALL_ALL_TABLES to ALL_OUTLINES

2 Static Data Dictionary Views: ALL_ALL_TABLES to ALL_OUTLINESThis chapter describes the first set (in alphabetical order) of static data dictionary views.The … remaining static data dictionary views appear in alphabetical order in Chapter 3 through Chapter 6 … . This chapter contains the following topics: About Static Data Dictionary Views Static

Database Reference, 11g Release 1 (11.1)

Static Data Dictionary Views: ALL_PART_COL_STATISTICS to DATABASE_PROPERTIES

3 Static Data Dictionary Views: ALL_PART_COL_STATISTICS to DATABASE_PROPERTIESThis chapter contains the static data dictionary views ALL_NESTED_TABLE_COLS through … DATABASE_PROPERTIES. Press the \"Next\" button to go to the first static data dictionary view.

Data Mining Administrator's Guide, 11g Release 1 (11.1)

Data Mining Administrator's Guide - Contents

ContentsMining Administration No DMSYS Schema Mining Models in the Oracle Data Dictionary Enhanced Security … Information from the Data Dictionary Obtaining Information about Mining Models Obtaining Information about … Documentation Where to Find Database Tuning Documentation Conventions What's New in Oracle Data

Database Concepts, 11g Release 1 (11.1)

The Data Dictionary

Database Object MetadataThe DBMS_METADATA package provides interfaces for extracting complete definitions of database objects. The definitions can be expressed either as XML or as SQL DDL. Two styles of interface are provided: A flexible, sophisticated interface for programmatic control A simplified interface for ad hoc querying See Also: Oracle Database PL/SQL Packages and Types Reference for more information about DBMS_METADATA

Database Concepts, 11g Release 1 (11.1)

The Data Dictionary

Dynamic Performance TablesThroughout its operation, Oracle Database maintains a set of virtual tables that record current database activity. These tables are called dynamic performance tables. Dynamic performance tables are not true tables, and they should not be accessed by most users. However, database administrators can query and create views on the tables and grant access to those views to other users. These views are

Database Reference, 11g Release 1 (11.1)

Creating the Data Dictionary

Script Name Needed For Descriptioncatalog.sql All databases Creates the data dictionary and public synonyms for many of its views … with, PL/SQL catclust.sql Real Application Clusters Creates Real Application Clusters data dictionary

Database Concepts, 11g Release 1 (11.1)

Glossary

data dictionarydatabase. A data dictionary stores such information as: The logical and physical structure of the … for a schema object and how much of it is in use A data dictionary is created when a database is

Data Mining Application Developer's Guide, 11g Release 1 (11.1)

Data Mining Application Developer's Guide - Contents

ContentsMining Data Dictionary Views Data Mining SQL Functions Data Mining Java API The JDM Standard Oracle … Prior Probabilities Specifying Class Weights Model Settings in the Data Dictionary Creating a Model … Documentation Accessibility Related Documentation Conventions What's New in Oracle

Streams Concepts and Administration, 11g Release 1 (11.1)

Oracle Streams Information Capture

The Oracle Streams Data DictionaryPropagations and apply process es use an Oracle Streams data dictionary to keep track of the … database objects from a particular source database. An Oracle Streams data dictionary is populated … dictionary for the source database. In the case of local capture, this Oracle Streams data

Streams Concepts and Administration, 11g Release 1 (11.1)

Introduction to Oracle Streams

Oracle Streams Data Dictionary ViewsEvery database in an Oracle Streams environment has Oracle Streams data dictionary views. These … environment Oracle Database Reference for more information about these data dictionary views


Was this page helpful?