Home » SQL & PL/SQL » SQL & PL/SQL » How to calcuate SGA (In Oracle 10g (10.2.0.4) + Windows & Linux)
How to calcuate SGA [message #390671] Mon, 09 March 2009 04:16 Go to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Hello,

In my operating system memory size 2G (Ram Size); I need to configure database automatic shared management.

How to configure/calculate SGA_MAX_SIZE and PGA for 2G Memory??

Please advice me.

Babu
Re: How to calcuate SGA [message #390694 is a reply to message #390671] Mon, 09 March 2009 05:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try anything then correct using AWR/Statspack.

Regards
Michel
Re: How to calcuate SGA [message #390703 is a reply to message #390694] Mon, 09 March 2009 05:53 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Hello Mr Mic,

Thanks,

Actually what I'm expecting; initially if I install oracle database; how much I need to give SGA values (SGA_TARGET ,SGA_MAX_SIZE and PGA)

May be in feature if any performance issue comes I can able to analyze using statspack/AWR; but I want to know initial configuration.

Babu
Re: How to calcuate SGA [message #390708 is a reply to message #390703] Mon, 09 March 2009 06:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no rule to set initial values, only your experience of Oracle, the application, its data, its workload, concurrent workload, OS, and so on.
This is why I said, try anything and fix after that.

Regards
Michel
Re: How to calcuate SGA [message #390713 is a reply to message #390708] Mon, 09 March 2009 07:05 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Exactly...

Now a days this is what I'm doing.

Thanks for your clarification.

Babu

Previous Topic: clob data
Next Topic: 'JSP'
Goto Forum:
  


Current Time: Wed Dec 07 12:55:24 CST 2016

Total time taken to generate the page: 0.10285 seconds