/nlzanen1/External/MEY/NL)
Sent by: Subject: RE: Free Buffer Waits
[EMAIL PROTECTED
PROTECTED]
fmc.af.mil cc: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
Sent by: Subject: RE: Free
Buffer Waits
To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
sos.com cc: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
Sent by: Subject: RE: Free Buffer Waits
of list ORACLE-L [EMAIL PROTECTED]
sos.com cc: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
Sent by: Subject: RE: Free Buffer
Waits
It's in centiseconds (100th sec) in all versions
up to 9i. In 9i, some have changed to (1th sec) IIRC.
So, if you're not in 9i, each of your waits is one second
(100.8971 * 0.01) and it waited a total of around 22000 secs
(between 7 and 8 hours). Bad.
As for the reasons, they can be many
free buffer waits waits indicate that your DBWR can't keep up with its
workload. Often caused by inefficient SQL competing with DBWR for an I/O
device.
Cary Millsap
Hotsos Enterprises, Ltd.
[EMAIL PROTECTED]
http://www.hotsos.com
-Original Message-
Zanen
Sent: Thursday, June 13, 2002
Sounds like the write latency on your storage is high or you have an abusive. 'free buffer waits' is the db writer failing to flush it's cache fast enough to disk.
George
On Thursday, March 7, 2002, at 06:39 PM, Manytrees wrote:
Hello all,
Does anybody know what parameters I should be
The puzzle has been solved, a developer was deleted
4 million rows from a 8 million rows table one row at a time!
Joel.
- Original Message -
From:
Manytrees
To: Multiple recipients of list ORACLE-L
Sent: Thursday, March 07, 2002 6:39
PM
Subject: free buffer
:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Monday, December 17, 2001 4:30 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: free buffer waits DISK I/O
Can't answer your question but sounds like you might benefit from reading
Gaja Krishna Vaidyanatha's
Pablo,
Free buffer waits is normally due to DBWR not being able to write out
modified blocks to disk fast enough.
By changing the disk layout you have eliminated disk contention and hot
spots and have enabled DBWR to write out the dirty buffers to disk faster
thus making enough free buffers
Rahul,
Again Free Buffer wait does not directly
correspond to the database buffer cache.
This can happen even if you have umpteen
free buffers in the buffer cache.
This generally happens during FTS of a
large table , which is what happening in
your case. If you have primary key defined
for
11 matches
Mail list logo