What are the optimal values for SHMMAX SHMMNI SHMALL ?
SHMMAX : Either SGA size of any individual database or half size of the system memory, whichever is the higher.
SHMMNI: Normally default value 4096 should be sufficient.
SHMALL: The sum of all the SGAs on the system, divided by the page size. The page size can be gotton by :
$ getconf PAGE_SIZE 4096
No comments:
Post a Comment