Home » RDBMS Server » Server Administration » SGA memory filled (oracle9i windows 2000)
SGA memory filled [message #551004] Sat, 14 April 2012 10:35 Go to next message
mrdb
Messages: 62
Registered: December 2009
Location: dubai
Member

Hi,

We are runing oracle9i database in windows 2000 server few months before i resized the SGA to sga_max_size =800M and pga-aggregate_target to 400M, actually we have 4gb RAM out of the we are allocated 1200Mb for SGA and PGA. My question is if the allocated memory got filled in SGA or PGA whether the system will show any error, because when I am quering from sql> show parameter ; the sga free memory is reducing daily what will happen when it reaches its max_size
Re: SGA memory filled [message #551008 is a reply to message #551004] Sat, 14 April 2012 12:23 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
PGA is just a target, total used can be more or less this value.
SGA is a maximum value, it is normal that SGA free size tends to 0, even the opposite should show that you allocate too much and some space are wasted.
When SGA is full, Oracle swaps out some less used parts if it needs to load new parts, just like OS memory that swaps/pages in and out following the demand.

Regards
Michel

[Updated on: Sat, 14 April 2012 12:24]

Report message to a moderator

Previous Topic: Schema Comparing tool
Next Topic: Many lock on Oracle Database using Oracle Forms
Goto Forum:
  


Current Time: Thu Mar 28 13:21:08 CDT 2024