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
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
10.3.9 Idle Wait Events → These 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
10.3 Wait Events Statistics → description 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
Table 10-2 Idle Wait Events → Wait 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
db file single write → This 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
duplicate cluster key → … The retry should then find a valid cluster key. Wait Time: 0.01 seconds Parameter Description dba
flashback buf free by RVWR → This 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
gc recovery quiesce → Instance recovery is waiting for a global cache operation to complete. Wait Time: The total elapsed
global cache busy → The session waits to convert a buffer from Shared Current to Exclusive Current status. Wait Time: 1
log file single write → … Wait Time: Time it takes for the physical I/O (write) to complete Parameter Description log# This is
parallel recovery change buffer free → the recovery slaves. Wait Time: 100ms Parameters: None See Also: Oracle Database High Availability … Best Practices for more information about this wait event
process startup → Wait 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
PX signal server → an error has occurred. Wait Time: 0.5 seconds Parameter Description serial The serial number of the
recovery read → to 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
rolling migration: cluster quiesce → This 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.
sbtmapbuf → fast and never block. Wait Time: Less than one millisecond Parameters: None
SGA: MMAN sleep for component shrink → MMAN 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
SQL*Net message from dblink → link 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
SQL*Net more data from dblink → The foreground process is expecting more data from a data base link. Wait Time: The total time it
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