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
8.2.2 About Monitoring Wait Events → Wait 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
Using Idle Wait Events → Oracle 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.
Wait Events Statistics → description 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
Wait Events Statistics → Wait 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
Idle Wait Events → These 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,
Using Wait Events without Timed Statistics → available. 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
Table of Wait Events and Potential Causes → Table 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
Using Wait Events with Timed Statistics → events, 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
C Oracle Wait Events → This 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
C.3 Descriptions of Wait Events → This 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;
C.1 Classes of Wait Events → example, '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
Contention-Related Wait Events → The 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
Block-Related Wait Events → The 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
Load-Related Wait Events → The 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,
Oracle RAC Wait Events → receive 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
Message-Related Wait Events → The 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
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
Analyzing Response Times Based on Wait Events → Most 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
7.6.4 Redo Transport Services Wait Events → there 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
Monitoring Oracle RAC Statistics and Wait Events → This 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