Re: SGA limit on Solaris x86
From: Mr. Chow Wing Siu <wschow_at_Comp.HKBU.Edu.HK>
Date: 7 Oct 2008 11:02:34 GMT
Message-ID: <gcffka$kuu$1@net44p.hkbu.edu.hk>
Date: 7 Oct 2008 11:02:34 GMT
Message-ID: <gcffka$kuu$1@net44p.hkbu.edu.hk>
Dear all,
SQL> show parameter sga;
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 4G sga_target big integer 4G
Is it the problem? What is sga_target and sga_max_size? How to increase?
-- Johnson ChowReceived on Tue Oct 07 2008 - 06:02:34 CDT