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

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 04:28:15 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.