-
Reduce Free unused space in SGA
Pls i have free unused space of 238MB in SGA. How do I reduce it. Also am getting Ora-04030 when retrieving data via a third party application. How can i resolve this problem
-
how do you know you have '238MB' free space in the SGA. The SGA is made up of many components which do different things
-
using this stt.
select * from v$sgastat
where name = 'free memory';
-
well you seem to be blowing OS process memory. HOw much memory is on your box, how big is the SGA? how big are your pga settings
-
I have 4gb ram
sga = 1.46gb
Sort area size = 58.59mb
pga = 124.671kb or 127664
pga max = 124.671 or 127664
am running oracle 816
Last edited by cca; 09-28-2005 at 04:56 AM.
-
wow your sort area size is too big, thats 58M per process not for the whole instance.
Knock that down to a few MB at most
-
ok.
what about the pga
pga = 124.671kb or 127664
pga max = 124.671 or 127664
-
what is workarea_size_policy
-
its not set i.e not defined in the ini file
-
if not set then forget about your PGA settings, you are NOT using it
your sort is too big for an OLTP system
if you always have free memory then may be your sga is oversized?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|