| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Wait Events - performance stats
As I understand "free buffer waits" occur when Oracle reads data blocks from
disk into db buffer cache in memory and can not find clean blocks in the
cache to use (ie the cache contains "dirty" blocks - blocks that have been
modified but have not been written to disk). On the other hand "buffer busy
waits" occur when a process can not access a block because it is being used
by another process. So they are not the same thing.
Long
-----Original Message-----
From: cemail_at_sprintmail.com [mailto:cemail_at_sprintmail.com]
Sent: Thursday, 20 July 2000 10:37 AM
To: Multiple recipients of list ORACLE-L
Subject: Wait Events - performance stats
On the old utlbstat/utlestat reports there used to be a column for buffer busy waits under Wait Events. I just ran a report on 8.0.5 and the buffer busy waits column wasn't listed but there was a column for free buffer waits. Is it the same thing?
Also, under "SQL*Net message from client", the average time is 17.37 and "SQL*Net more data from client" is 4.12. Are those numbers high or normal? What would can be done about this?
-- Author: INET: cemail_at_sprintmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing ListsReceived on Thu Jul 20 2000 - 01:45:15 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
 |
 |