Home » RDBMS Server » Server Administration » Memory Question
Memory Question [message #320690] Thu, 15 May 2008 22:11 Go to next message
hexmanju
Messages: 71
Registered: September 2005
Location: MUMBAI
Member
Hi

In Oracle Database when we specify the SGA size thru(SGA_MAX_SIZE) or SGA_TARGET(10g)equal to 8GB and say we have

Long time doubt ?

Thanksphysical memory of 4GB does it throw out of memory error.Say if i have allocated Virtual memory in addition to physical memory of 8GB more,will it be making use of that for the memory deficiency
MM
Re: Memory Question [message #320814 is a reply to message #320690] Fri, 16 May 2008 05:51 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Do you fancy rewriting the question so the lines are in the right order?
Re: Memory Question [message #321097 is a reply to message #320814] Mon, 19 May 2008 01:27 Go to previous message
hexmanju
Messages: 71
Registered: September 2005
Location: MUMBAI
Member
Hi

Long time doubt ?

In Oracle Database when we specify the SGA size thru(SGA_MAX_SIZE) or SGA_TARGET(10g)equal to 8GB and say we have
physical memory of 4GB does it throw out of memory error.Say if i have allocated Virtual memory in addition to physical memory of 8GB more,will it be making use of that for the memory deficiency

How does Oracle Handle memory utilisation?

Thanks
MM
Previous Topic: How do I effectively monitor and notify OS diskspace utilized by Oracle tablespaces?
Next Topic: Parameter changed at spfile
Goto Forum:
  


Current Time: Sun Dec 04 06:30:15 CST 2016

Total time taken to generate the page: 0.06015 seconds