Oracle-L: Re: free buffer waits

From: Joel Laforest <joel+z-lazy_at_pythian.com>
Date: Fri, 08 Mar 2002 13:38:23 -0800
Message-ID: <F001.004239E9.20020308133823@fatcity.com>

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 waits

Hello all,

Does anybody know what parameters I should be tuning/change to try & reduce the number of busy buffer waits. I have a system which at times has over 15+session waiting on "free buffer waits".

The explanation that I have been able to find so far is that session are waiting on buffer to free up :)

Have a good night all,

Joel.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Joel Laforest
INET: joel+z-lazy_at_pythian.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_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). Received on Fri Mar 08 2002 - 15:38:23 CST