OraFAQ Forum: Server Administration » newbie: total memory for an instance?

Home » RDBMS Server » Server Administration » newbie: total memory for an instance? (win2003, 10g 10.2.0.3)

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

newbie: total memory for an instance? [message #280678]

Wed, 14 November 2007 08:40

hristo
Messages: 258
Registered: May 2007

Senior Member

Hi!

If I have an instance with a SGA_target of 350MB (and sga_max_size also 350) and an pga_aggregate_target of 100MB will the total memory allocation of this instance be 450, or?

Report message to a moderator

Re: newbie: total memory for an instance? [message #280684 is a reply to message #280678]

Wed, 14 November 2007 09:06

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No.
It is SGA + sum of memories used by the processes associated to the instance (server/shadow processes, listeners?)

Regards
Michel

Report message to a moderator

Re: newbie: total memory for an instance? [message #280691 is a reply to message #280684]

Wed, 14 November 2007 09:23

hristo
Messages: 258
Registered: May 2007

Senior Member

Hi!

Is there anyway to found out the total memory usage of one instance?

Report message to a moderator

Re: newbie: total memory for an instance? [message #280718 is a reply to message #280691]

Wed, 14 November 2007 10:30

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

As you are in Windows, just start task manager and look at the memory value for oracle.exe process.

Regards
Michel

Report message to a moderator

Re: newbie: total memory for an instance? [message #280877 is a reply to message #280718]

Thu, 15 November 2007 01:29

hristo
Messages: 258
Registered: May 2007

Senior Member

Well, that was a good idea, thanks!

Regards
H

Report message to a moderator

Re: newbie: total memory for an instance? [message #280933 is a reply to message #280678]

Thu, 15 November 2007 04:05

thorin666
Messages: 144
Registered: March 2007

Senior Member

try

show parameters sga_max_size

i think you don't want to know other structure like shared pool, db cache, etc

Report message to a moderator

Re: newbie: total memory for an instance? [message #280937 is a reply to message #280933]

Thu, 15 November 2007 04:08

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What about PGA?

By the way, max size may be not fully used.
So what you posted is useless.

Regards
Michel

Report message to a moderator

Re: newbie: total memory for an instance? [message #280951 is a reply to message #280937]

Thu, 15 November 2007 04:26

thorin666
Messages: 144
Registered: March 2007

Senior Member

Michel Cadot wrote on Thu, 15 November 2007 04:08

What about PGA?

By the way, max size may be not fully used.
So what you posted is useless.

Regards
Michel

you are right if you get the max_sga_size you get the max_size possible but maybe there is not the real size. Sorry. But if he is not using windows, task manager is useless too Razz

I think he want to know the real memory that oracle spend.
in that case, he must to search for the size of each structure like
shared_pool, large pool, db_cache_size, java_pool.
But i dont remember how to determine the pga_size

Report message to a moderator

Re: newbie: total memory for an instance? [message #280968 is a reply to message #280951]

Thu, 15 November 2007 05:03

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

But if he is not using windows, task manager is useless too

But he IS on Windows, he said it.

On Windows, it is easy to determine the overall size as Oracle instance is in a single process.
On Unix, it is much more difficult, if not impossible.

Regards
Michel

Report message to a moderator

Re: newbie: total memory for an instance? [message #281024 is a reply to message #280968]

Thu, 15 November 2007 07:25

hristo
Messages: 258
Registered: May 2007

Senior Member

hi!

Im trying to tunedown the memory of an empty DB (RAC using Grid). Win 2003, DB 10.2.0.3 Grid Control.
This DB is only created, so there are no data in it. I have set this up:

pga_aggregate_target = 194M (a little high, maybe)
sga_target = 400M
java_pool_size = 8M
large_pool_size = 8M
sga_max_size = 400M
shared_pool_size = 85M
sort_area_size = 2M

But I only get this:

ORA-04030: out of process memory when trying to allocate 32 bytes (sqlarea,tmp) when trying to start it up.

There are around 7gb free RAM on the server. so, that could not be the issue. We have two other identical DBs that can run with lower settings.

Any good ideas for a newbie??

Report message to a moderator