Message-Id: <10563.112497@fatcity.com> From: "Nguyen, Long" Date: Thu, 20 Jul 2000 16:45:15 +1000 Subject: 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@sprintmail.com [mailto:cemail@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? ----- Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Author: INET: cemail@sprintmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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).