OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Memory Question

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Memory Question [message #320690]

Thu, 15 May 2008 22:11

hexmanju
Messages: 78
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

Report message to a moderator

Re: Memory Question [message #320814 is a reply to message #320690]

Fri, 16 May 2008 05:51

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?

Report message to a moderator

Re: Memory Question [message #321097 is a reply to message #320814]

Mon, 19 May 2008 01:27

hexmanju
Messages: 78
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 02:27:35 CST 2024