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 wait events


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


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

Monitoring the Database

8.2.2 About Monitoring Wait EventsWait events are statistics that are incremented by a server process to indicate that it had to wait … for an event to complete before being able to continue processing. A session could wait for a … service such as a disk write, or it could wait for a lock or latch. When a session is waiting for

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

Measuring Database Performance

Using Idle Wait EventsOracle Database uses some wait events to indicate whether the Oracle server process is idle … . Typically, these events are of no value when investigating performance problems, and should be ignored when examining wait events.

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

Instance Tuning Using Performance Views

Wait Events Statisticsdescription of the V$ views and the Oracle wait events Investigate wait events and related timing data … 10 wait events for each current session and the associated wait time. V$SESSION_EVENT lists the … cumulative history of events waited for on each

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

Measuring Database Performance

Wait Events StatisticsWait events are statistics that are incremented by a server process or thread to indicate that it … contention, and I/O contention. To enable easier high-level analysis of wait events, Oracle Database groups … following list includes common examples of wait events in some of the wait

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

Instance Tuning Using Performance Views

Idle Wait EventsThese events belong to Idle wait class and indicate that the server process is waiting because it … Table 10-2. Table 10-2 Idle Wait Events Wait Name Background Process Idle Event User Process Idle Event … database resources. The majority of the idle events should be ignored when tuning,

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

Measuring Database Performance

Using Wait Events without Timed Statisticsavailable. Therefore, it is only possible to order wait events by the number of times each event was … waited for. Although the events with the largest number of waits might indicate a potential bottleneck … fewer waits might be a bigger bottleneck if the wait time accounts for a significant proportion of the

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

Instance Tuning Using Performance Views

Table of Wait Events and Potential CausesTable 10-1 links wait events to possible causes and gives an overview of the Oracle data that could … be most useful to review next. Table 10-1 Wait Events and Potential Causes Wait Event General Area … \" at: http://support.oracle.com/ See Also: \" Wait Events Statistics

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

Measuring Database Performance

Using Wait Events with Timed Statisticsevents, in addition to available wait counts. This data is useful for comparing the total wait time … worth investigating. For information about wait events, see \" Wait Events Statistics \". Note: Timed … Setting TIMED_STATISTICS to TRUE at the instance level directs

Database Reference, 12c Release 1 (12.1)

Oracle Wait Events

C Oracle Wait EventsThis appendix contains the following topics: Classes of Wait Events Descriptions of Common Wait … Event Parameters Descriptions of Wait Events Information about wait events is displayed in three … \" Many of these wait events are tied

Database Reference, 12c Release 1 (12.1)

Descriptions of Wait Events

C.3 Descriptions of Wait EventsThis section provides detailed descriptions for those wait events of greatest interest. Where … a complete listing of wait events, in alphabetical order, you can issue the following SQL statement: SQL> SELECT name FROM V$EVENT_NAME ORDER BY name;

Database Reference, 12c Release 1 (12.1)

Classes of Wait Events

C.1 Classes of Wait Eventsexample, 'wait for EMON to spawn') Queue Contains events that signify delays in obtaining additional … data in a pipelined environment. The time spent on these wait events indicates inefficiency or other … Every wait event belongs to a class of wait event. The following list describes

Real Application Clusters Administration and Deployment Guide, 12c Release 1 (12.1)

Contention-Related Wait Events

Contention-Related Wait EventsThe main wait events for contention-related waits are: gc current block busy gc cr block busy gc … block busy and gc cr block busy wait events indicate that the local instance that is making the … to a log file. In comparison to block busy wait events, a gc buffer busy event indicates

Real Application Clusters Administration and Deployment Guide, 12c Release 1 (12.1)

Block-Related Wait Events

Block-Related Wait EventsThe main wait events for block-related waits are: gc current block 2-way gc current block 3-way gc … cr block 2-way gc cr block 3-way The block-related wait event statistics indicate that a block was

Real Application Clusters Administration and Deployment Guide, 12c Release 1 (12.1)

Load-Related Wait Events

Load-Related Wait EventsThe main wait events for load-related waits are: gc current block congested gc cr block congested … The load-related wait events indicate that a delay in processing has occurred in the GCS, which is … -balancing, off loading processing to different times or a new cluster node.For the events mentioned,

Real Application Clusters Administration and Deployment Guide, 12c Release 1 (12.1)

Oracle RAC Wait Events

Oracle RAC Wait Eventsreceive a message to read from disk. The wait events for the global cache convey precise information … grant 2-way In summary, the wait events for Oracle RAC convey information valuable for performance … Analyzing and interpreting what causes sessions to wait is an important method to determine where

Real Application Clusters Administration and Deployment Guide, 12c Release 1 (12.1)

Message-Related Wait Events

Message-Related Wait EventsThe main wait events for message-related waits are: gc current grant 2-way gc cr grant 2-way The … message-related wait event statistics indicate that no block was received because it was not cached in … from disk or modify it. If the time consumed by these events is high, then it may be assumed that

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

Instance Tuning Using Performance Views

This table links wait events to potential causes and gives an overview of the Oracle data that could…database bottleneck. Note that wait I/O should be considered as idle CPU. If there is high CPU

Real Application Clusters Administration and Deployment Guide, 12c Release 1 (12.1)

Analyzing Response Times Based on Wait Events

Analyzing Response Times Based on Wait EventsMost global cache wait events that show a high total time as reported in the AWR and Statspack … time consumers without actually indicating a problem. This section describes frequent wait events that … the more detailed reports produced by AWR and Statspack. Wait events for Oracle RAC

Data Guard Concepts and Administration, 12c Release 1 (12.1)

Redo Transport Services

7.6.4 Redo Transport Services Wait Eventsthere are no more gaps. 7.6.4 Redo Transport Services Wait Events Table 7-2 lists several of the … Oracle wait events used to track redo transport wait time on a redo source database. These wait events … /goto/maa Table 7-2 Redo Transport Wait Events

Real Application Clusters Administration and Deployment Guide, 12c Release 1 (12.1)

Monitoring Oracle RAC Statistics and Wait Events

Monitoring Oracle RAC Statistics and Wait EventsThis section explains wait events and statistics specific to Oracle RAC and how to interpret them … : Oracle RAC Statistics and Events in AWR and Statspack Reports Oracle RAC Wait Events Monitoring … Analyzing Response Times Based on Wait Events See Also: Oracle Database