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 V$DISPATCHER_RATE


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


Database Reference, 12c Release 1 (12.1)

V$DISPATCHER_RATE

7.156 V$DISPATCHER_RATEV$DISPATCHER_RATE displays rate statistics for a number of activities performed by the dispatcher

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

Managing Processes

5.3.6 Shared Server Data Dictionary Views$DISPATCHER_CONFIG Provides configuration information about the dispatchers. V$DISPATCHER_RATE Provides rate … monitor performance. View Description V$DISPATCHER Provides information on the dispatcher processes … , including name, network address, status, various usage statistics, and index number. V … statistics

Database Performance Tuning Guide, 12c Release 1 (12.1)

Configuring a Database for Performance

Identifying and Reducing Contention Using the Dispatcher-Specific Viewsabout dispatcher processes V$DISPATCHER_RATE: dispatcher processing statistics The V$DISPATCHER_RATE … dispatcher performance, query the V$DISPATCHER_RATE view and compare the current values with the maximums … maximums, then you might need to add more dispatchers. A general rule is

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

Managing Processes

5.3.5 Disabling Shared Server$QUEUE V$DISPATCHER V$DISPATCHER_RATE If these views indicate that the load on the dispatcher … MAX_DISPATCHERS parameter. Monitor the following views to determine the load on the dispatcher processes: V … dispatchers and so forth--query the V$DISPATCHER_CONFIG dynamic performance view. To see which

Database Reference, 12c Release 1 (12.1)

Database Reference - Contents

Contents7.156 V$DISPATCHER_RATE 7.157 V$DNFS_CHANNELS 7.158 V$DNFS_FILES 7.159 V$DNFS_SERVERS 7.160 V … USER_ZONEMAP_MEASURES 6.624 USER_ZONEMAPS Part III Dynamic Performance Views 7 Dynamic Performance (V … $) Views: V$ACCESS to V$HVMASTER_INFO

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

Configuring a Shared Server Architecture

Monitoring DispatchersUse the following views to check configurations and monitor dispatchers: V$QUEUE: Contains … who have SELECT ANY TABLE system privilege, such as SYSTEM. V$DISPATCHER: Provides information about … index number. V$DISPATCHER_CONFIG: Provides configuration information about the dispatchers. V … $DISPATCHER_RATE:

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

Distributed Database Management

Part V Distributed Database ManagementYou can manage a distributed database environment.

Database SQL Tuning Guide, 12c Release 1 (12.1)

Optimizer Statistics

Part V Optimizer StatisticsThe optimizer relies on statistics to create execution plans. This part contains the following chapters: Optimizer Statistics Concepts Histograms Managing Optimizer Statistics: Basic Topics Managing Optimizer Statistics: Advanced Topics

Database Backup and Recovery User's Guide, 12c Release 1 (12.1)

Tuning RMAN Performance

Identifying Bottlenecks with V$BACKUP_SYNC_IO and V$BACKUP_ASYNC_IOYou can use the V$BACKUP_SYNC_IO and V$BACKUP_ASYNC_IO views to determine the source of backup or … restore bottlenecks and to see detailed progress of backup jobs. V$BACKUP_SYNC_IO contains rows when … the I/O is synchronous to the process (or thread on some platforms) performing the backup. V … SQL*Plus and

Database Performance Tuning Guide, 12c Release 1 (12.1)

Tuning the Database Buffer Cache

Using the V$DB_CACHE_ADVICE ViewThe V$DB_CACHE_ADVICE view shows the simulated miss rates for a range of potential buffer cache … is not used if the number of buffers in a buffer pool is small to begin with. To use the V … workload on the database instance. Allow the workload to stabilize before querying the V … $DB_CACHE_ADVICE view. Query the V$DB_CACHE_ADVICE

Database Reference, 12c Release 1 (12.1)

V$QMON_COORDINATOR_STATS

8.132 V$QMON_COORDINATOR_STATSV$QMON_COORDINATOR_STATS displays statistics of the non-sharded queue master process. There is one

Database Reference, 12c Release 1 (12.1)

V$DATABASE

7.135 V$DATABASEV$DATABASE displays information about the database from the control file. Column Datatype … ARCHIVELOG_CHANGE# NUMBER Highest NEXT_CHANGE# (from the V$ARCHIVED_LOG view) for an archive log … command LAST_OPEN_INCARNATION# NUMBER Record number of the incarnation in V$DATABASE_INCARNATION that … media recovery and is always less

Database Reference, 12c Release 1 (12.1)

V$DATABASE

VARCHAR23 Indicates the status of the force full database caching feature in the database. Possible…This column is available starting with Oracle Database 12 c Release 1 (12.1.0.2). See Also: \" DBA_SUPPLEMENTAL_LOGGING \" for more information about supplemental logging in a PDB

Database Reference, 12c Release 1 (12.1)

V$REQDIST

8.148 V$REQDISTV$REQDIST lists statistics for the histogram of shared server dispatcher request times, divided

Database Reference, 12c Release 1 (12.1)

V$DB_TRANSPORTABLE_PLATFORM

7.147 V$DB_TRANSPORTABLE_PLATFORMV$DB_TRANSPORTABLE_PLATFORM displays all platforms to which the database can be transported using … same endian platform. Therefore, V$DB_TRANSPORTABLE_PLATFORM displays fewer rows than V … root n: Where n is the applicable container ID for the rows containing data See Also: \" V$TRANSPORTABLE_PLATFORM \"

Database Reference, 12c Release 1 (12.1)

V$LOG_HISTORY

8.41 V$LOG_HISTORYV$LOG_HISTORY displays log history information from the control file. Column Datatype Description

Database Reference, 12c Release 1 (12.1)

V$INMEMORY_AREA

8.5 V$INMEMORY_AREAV$INMEMORY_AREA contains information on the space allocation inside the In-Memory area. The In … in the V$INMEMORY_AREA view. The relative size of the two pools is determined by internal … for the rows containing data See Also: \" INMEMORY_CLAUSE_DEFAULT \" \" V$IM_COLUMN_LEVEL \" \" V … $IM_SEGMENTS \" \" V$IM_USER_SEGMENTS

Database Reference, 12c Release 1 (12.1)

V$SQLFN_ARG_METADATA

9.70 V$SQLFN_ARG_METADATAV$SQLFN_ARG_METADATA contains metadata about function arguments. There is one row for each argument … of every function found in V$SQLFN_METADATA. There are no rows for functions that do not have any … column can be used to join with the V$SQLFN_METADATA view. ARGNUM NUMBER Argument number DATATYPE … that pertain to only the root

Database Reference, 12c Release 1 (12.1)

V$IOSTAT_FUNCTION

8.16 V$IOSTAT_FUNCTIONV$IOSTAT_FUNCTION displays disk I/O statistics for database functions (such as the LGWR and DBWR

Database Reference, 12c Release 1 (12.1)

V$ASM_ALIAS

7.44 V$ASM_ALIASIn an Oracle Automatic Storage Management (Oracle ASM) instance, V$ASM_ALIAS displays one row for … number of the alias (foreign key to the V$ASM_DISKGROUP view) FILE_NUMBER NUMBER Oracle ASM file … number of the alias (foreign key to the V$ASM_FILE view) FILE_INCARNATION NUMBER Oracle ASM file