Home » RDBMS Server » Server Administration » SGA Size
SGA Size [message #209450] Thu, 14 December 2006 23:03 Go to next message
goudelly
Messages: 52
Registered: August 2006
Location: India
Member

Dear All,

I have AIX server and i was installed the Oracle 10gR2. The systems is having 4GB RAM and OS Paging is 12GB. My query is.. How much size should i allot to SGA and as wll as PGA size. My DB_BLOCK size 8K.

Thanks,

Mohan Reddy



Re: SGA Size [message #209454 is a reply to message #209450] Thu, 14 December 2006 23:49 Go to previous messageGo to next message
seema.taunk
Messages: 96
Registered: October 2006
Member
Hi,

Check this link
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2005-08-19.0090015270
Re: SGA Size [message #209670 is a reply to message #209450] Sat, 16 December 2006 09:55 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi Mohan

take a look

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:30011178429375


regards
Taj
Previous Topic: ORA-12224: TNS: no listener
Next Topic: shrinking or tuning index and RBS segments
Goto Forum:
  


Current Time: Sun Dec 04 18:41:21 CST 2016

Total time taken to generate the page: 0.11976 seconds