| Solaris V880 W/32 G ram Oracle 10.1.2 - parameters? [message #132692] |
Mon, 15 August 2005 13:46  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
