wait events and v$session_event
- From: <ryan.gaffuri@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 11 May 2004 10:32:48 -0400
I have one batch process running and there are alot of waits. I thought waits
were caused by concurrency?
If this is unreadable, please ignore. Hard to format with web email. Basically,
I have large waits for DB_FILE_SCATTERED_READ, DB_FILE_SEQUENTIAL_READ, and for
RAC Cache Fusion due to the load balancing.
SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED
AVERAGE_WAIT MAX_WAIT TIME_WAITED_MICRO
---------- ------------------------------ ----------- --------------
----------- ------------ ---------- -----------------
22 rdbms ipc reply 1 0
0 0 0 165
22 log file sync 1 0
0 0 0 996
22 db file sequential read 491250 0
23237 0 172 232371459
22 db file scattered read 159243 0
29892 0 37 298924960
22 global cache open x 10 0
0 0 0 3380
22 global cache s to x 11273 0
648 0 42 6477337
22 global cache cr request 1453244 16
233740 0 98 2337401155
22 row cache lock 210 0
14 0 0 135414
22 library cache lock 15 0
1 0 0 5311
22 SQL*Net message to client 21 0
0 0 0 27
22 SQL*Net message from client 21 0
1 0 0 9023
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
