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


Database Administrator's Guide

Monitoring Database Operations

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

Instance Tuning Using Performance Views

10.3.9 Idle Wait EventsThese events belong to Idle wait class and indicate that the server process is waiting because it … database resources. The majority of the idle events should be ignored when tuning, because they do not … indicate the nature of the performance bottleneck. Some idle events can be useful in indicating what … the

Database Performance Tuning Guide

Instance Tuning Using Performance Views

10.3 Wait Events Statisticsdescription of the V$ views and the Oracle wait events Investigate wait events and related timing data when … 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

Instance Tuning Using Performance Views

Table 10-2 Idle Wait EventsWait Name Background Process Idle Event User Process Idle Event Parallel Query Idle Event Shared … ... pmon timer X.... PX Idle Wait.. X.. PX Deq Credit: need buffer.. X.. rdbms ipc message X … .... shared server idle wait... X. smon timer X.... SQL*Net message from client. X... See Also … : Oracle Database Reference for explanations

Database Reference

Descriptions of Wait Events

db file single writeThis event is used to wait for the writing of the file headers. Wait Time: The wait time is the … Also: Oracle Database Performance Tuning Guide for information about how this wait event can help identify I/O problems

Database Reference

Descriptions of Wait Events

duplicate cluster key… The retry should then find a valid cluster key. Wait Time: 0.01 seconds Parameter Description dba

Database Reference

Descriptions of Wait Events

flashback buf free by RVWRThis wait event only occurs when Flashback Database is turned on. A session waits for recovery … RVWR can free up the buffers, the session may need to wait. If this event becomes a top wait event … Database Backup and Recovery User's Guide for tuning considerations. Wait Time: 1 second Parameters … : None See

Database Reference

Descriptions of Wait Events

gc recovery quiesceInstance recovery is waiting for a global cache operation to complete. Wait Time: The total elapsed

Database Reference

Descriptions of Wait Events

global cache busyThe session waits to convert a buffer from Shared Current to Exclusive Current status. Wait Time: 1

Database Reference

Descriptions of Wait Events

log file single writeWait Time: Time it takes for the physical I/O (write) to complete Parameter Description log# This is

Database Reference

Descriptions of Wait Events

parallel recovery change buffer freethe recovery slaves. Wait Time: 100ms Parameters: None See Also: Oracle Database High Availability … Best Practices for more information about this wait event

Database Reference

Descriptions of Wait Events

process startupWait for a shared server, Dispatcher, or other background process to start. Wait Time: Wait up to 1 … second for a background process to start. If timed out, then re-wait until 5 minutes have passed

Database Reference

Descriptions of Wait Events

PX signal serveran error has occurred. Wait Time: 0.5 seconds Parameter Description serial The serial number of the

Database Reference

Descriptions of Wait Events

recovery readto complete. Wait Time: Time it takes to complete the physical I/O (read) Parameters: None See Also … : Oracle Database High Availability Best Practices for more information about this wait event

Database Reference

Descriptions of Wait Events

rolling migration: cluster quiesceThis is the wait event that instances wait on when cluster is about to start a rolling migration … before allowing rolling migration. Wait Time: 1 second Parameter Description location Its value will be … 1 if the wait is for completion of the privileged operations so that a rolling upgrade/downgrade … can start.

Database Reference

Descriptions of Wait Events

sbtmapbuffast and never block. Wait Time: Less than one millisecond Parameters: None

Database Reference

Descriptions of Wait Events

SGA: MMAN sleep for component shrinkMMAN to wait and post itself for satisfying an auto-tuned memory request while trying to fully free … a component's quiesced granules. In Release 10.1, the name of this event was 'wait for SGA … component shrink'. Wait Time: 10 msec Parameter Description P1 component_id (corresponding to the memory

Database Reference

Descriptions of Wait Events

SQL*Net message from dblinklink from another server process. Wait Time: The time it took for a message to arrive from another … process) from another foreground process over a database link. See Also: Oracle Database Performance Tuning Guide for more information about this wait event

Database Reference

Descriptions of Wait Events

SQL*Net more data from dblinkThe foreground process is expecting more data from a data base link. Wait Time: The total time it

Database Reference

Descriptions of Wait Events

TCP Socket (KGAS)that this wait event tracks does not indicate a problem, and even a long wait time is not a reason … communicates with a remote host must wait until the data it will read has arrived. In addition, on … life in waits tracked by the TCP Socket (KGAS) wait event. Wait Time: The total elapsed time for the