Re: ora817 sga problem

From: Morff <morff1_at_wp.pl>
Date: Tue, 13 Dec 2005 23:01:18 +0100
Message-ID: <op.s1qssgvgq0kutt@nt_januszk.domain_not_set.invalid>

Dnia 13-12-2005 o 22:32:12 Michel Cadot <micadot{at}altern{dot}org> napisa³:

> My question was "why do *you* think this query means?"

I thought that this query helps me understand why flush helps .. it's not.

> Flushing the shared pool without knowing what this also means
> is not a good idea.

I think there is too many cursors in memory (cursor_space_for_time = TRUE ,session_cached_cursors = 320,open_cursors = 640) or some garbage ..

The point is : it was 130-140 concurrent sessions - then was no error , there is 30-40 sessions - it is an error from time to time ..

Maybe I need Harry Potter to cast a spell :)

-- 
Pozdrawiam
Morff
----------------------
AQQ 141151
Powered by Opera/M2

Received on Tue Dec 13 2005 - 16:01:18 CST