Home » RDBMS Server » Server Administration » newbie: total memory for an instance? (win2003, 10g 10.2.0.3)
newbie: total memory for an instance? [message #280678] Wed, 14 November 2007 08:40 Go to next message
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?
Re: newbie: total memory for an instance? [message #280684 is a reply to message #280678] Wed, 14 November 2007 09:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: newbie: total memory for an instance? [message #280691 is a reply to message #280684] Wed, 14 November 2007 09:23 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Hi!

Is there anyway to found out the total memory usage of one instance?
Re: newbie: total memory for an instance? [message #280718 is a reply to message #280691] Wed, 14 November 2007 10:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: newbie: total memory for an instance? [message #280877 is a reply to message #280718] Thu, 15 November 2007 01:29 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Well, that was a good idea, thanks!

Regards
H
Re: newbie: total memory for an instance? [message #280933 is a reply to message #280678] Thu, 15 November 2007 04:05 Go to previous messageGo to next message
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
Re: newbie: total memory for an instance? [message #280937 is a reply to message #280933] Thu, 15 November 2007 04:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: newbie: total memory for an instance? [message #280951 is a reply to message #280937] Thu, 15 November 2007 04:26 Go to previous messageGo to next message
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

Re: newbie: total memory for an instance? [message #280968 is a reply to message #280951] Thu, 15 November 2007 05:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: newbie: total memory for an instance? [message #281024 is a reply to message #280968] Thu, 15 November 2007 07:25 Go to previous messageGo to next message
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??
Re: newbie: total memory for an instance? [message #281027 is a reply to message #281024] Thu, 15 November 2007 07:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Remove all *size parameters but sga_max_size.

Be sure that your application use bind variables.

Regards
Michel
Re: newbie: total memory for an instance? [message #281050 is a reply to message #281027] Thu, 15 November 2007 09:33 Go to previous message
hristo
Messages: 258
Registered: May 2007
Senior Member
Thanks for your help!

Regards
H
Previous Topic: how to know the default next_extent, pct_increace on tables?
Next Topic: Space Management
Goto Forum:
  


Current Time: Wed Dec 07 22:10:12 CST 2016

Total time taken to generate the page: 0.06782 seconds