hpuxrac wrote:
> Mladen Gogala wrote:
>> On Wed, 14 Jun 2006 00:07:40 -0700, Spendius wrote:
>>
>>> Argh... Forgot to say I'm dealing with an 8i DB, for which
>>> SQL> select name from v$latch where latch#=66;
>>> NAME
>>> ---------------------
>>> cache buffers chains
>> You need more cache buffer chains.
>
> Conceivably possible but more likely it's bad SQL or some kind of
> strange optimizer derived access pattern.
>
> What's the point in taking a wild stab in the dark?
No stabs in the dark here. Common wisdom tells me that if he's
waiting for buffer chains, it's prudent to create more of them.
That, actually, is all that I can judge about.
--
Mladen Gogala
http://www.mgogala.com
Received on Wed Jun 14 2006 - 15:08:44 CDT
