Home » RDBMS Server » Performance Tuning » Solaris V880 W/32 G ram Oracle 10.1.2 - parameters?
Solaris V880 W/32 G ram Oracle 10.1.2 - parameters? [message #132692] Mon, 15 August 2005 13:46 Go to next message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
Can someone tell me good parameters for a Solaris V880 with 32 gigs ram? Solaris, I was told, can only share 4 gig. How about:
*.db_block_size=8192
*.db_recovery_file_dest_size=2147483648
*.db_recycle_cache_size=2147483648
*.pga_aggregate_target=858993459 # 20 % of sga (4 Gigs)
*.processes=159
*.sga_max_size=4294967296 # 4 gigs, wish I could use more...
*.sga_target=4294967296


Clearly I have a poor understanding of how these parameter affect SGA and other memory structures. Our server has 32 gigs, but I think, unless someone tells me differently, we can only use 4 gig for the sga.
Thanks for any help!
Re: Solaris V880 W/32 G ram Oracle 10.1.2 - parameters? [message #132695 is a reply to message #132692] Mon, 15 August 2005 14:26 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Strongly suggest that you read the memory architecture chapter of the concepts guide, as well as the chapter on configuring a new server in the 10g performance tuning guide.

And I have no idea about the max shared memory allocatable on Solaris, but I would be shocked if it were only 4gig, especially when factoring in kernal parameters. Check the solaris platform/installation guide and release notes from oracle's website, as well as the sun documentation on oracle from the sun website. Even windows can use more than 4gig.

And of course we really need more information on what your database is intended to do before we can have an idea on how to suggest actual amounts. But assuming you really need that much horsepower, then consider making your pga target much larger.
Previous Topic: Oracle 8.1.6 Solaris 7 - redo log group switch
Next Topic: Urgent reply needed
Goto Forum:
  


Current Time: Mon Nov 28 05:26:37 CST 2022