How to diagnose inaproppriate Oracle SGA component size?

From: Marcin Szarek <me_at_some.where.com>
Date: Thu, 24 Aug 2006 17:14:18 +0200
Message-ID: <pan.2006.08.24.15.14.18.202236@some.where.com>

Hi,

Could you tell me (or point me to some information source) what could be the sympthoms of too small component size in SGA? For example - what are the effects of too small shared pool or buffer cache?

Thanks in advance for any replies!

Regards,

-        MARCIN SZAREK <me_at_some.where.com>           -

-- There are only 10 types of people in this world; --

those who understand binary, and those who don't --

Received on Thu Aug 24 2006 - 10:14:18 CDT