Re: Oracle slowed down

From: Bob Jones <email_at_me.not>
Date: Sat, 22 Apr 2006 16:14:38 GMT
Message-ID: <ODs2g.50959$_S7.10361@newssvr14.news.prodigy.com>

"Brian Peasland" <oracle_dba_at_nospam.peasland.net> wrote in message news:Iy4po5.At9_at_igsrsparc2.er.usgs.gov...
>>> Because you look at the waits.
>>> Any waits. Maybe you need to tune the buffer cache, maybe
>>> you need to kick the sysadmin's ass.
>>
>> What waits?
>
> buffer busy waits
> free buffer waits
>
> If either of those waits are high on the list, then your buffer cache may
> be too small.
>

It could also mean many other things. Received on Sat Apr 22 2006 - 11:14:38 CDT