Tuesday, June 28, 2011

When is DISM enabled in Solaris

  • 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

1 comment:

  1. 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
    MaxMunus 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


    ReplyDelete