- You can find out if ISM or DISM is enabled, by executing the following :
- pmap -xs ora_<SID>_lgwr | grep -i ism
- The algorithm for finding out if DISM will be enabled is as under:
- Is memory_target or memory_max_target is set
- Yes: enable DISM
- No : Is the size of sga_max_size > size for all SGA components
- Yes : Enable DISM
- No : enable ISM
- If you want to disable DISM, ensure that sga_max_size is set to a value less than the size of all SGA components
- You can find the size of all SGA components as under:
- select sum(value)/(1024*1024*1024) as totalMB from v$sga;
- Info on sga_target and sga_max_size:
- sga_target enables automatic SGA mangement. You do not need to set individual SGA buffers if you set sga_target. It can be dynamically increased to sga_max_size.
- sga_max_size is the max size of the SGA. It is a static parameter. By default, Oracle sets sga_max_size to sga_target if sga_max_size is not set. Additonal info : http://forums.oracle.com/forums/thread.jspa?threadID=535400
Tuesday, June 28, 2011
When is DISM enabled in Solaris
Subscribe to:
Post Comments (Atom)
I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Oracle Solaris, kindly contact us http://www.maxmunus.com/contact
ReplyDeleteMaxMunus Offer World Class Virtual Instructor led training on Oracle Solaris. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
For Demo Contact us:
Name : Arunkumar U
Email : arun@maxmunus.com
Skype id: training_maxmunus
Contact No.-+91-9738507310
Company Website –http://www.maxmunus.com