Showing posts with label DISM. Show all posts
Showing posts with label DISM. Show all posts

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

Monday, May 9, 2011

WARNING: oradism not setup correctly in alert log

If you see the following warning in alert file :

WARNING: -------------------------------
WARNING: oradism not set up correctly.
Dynamic ISM can not be locked. Please
setup oradism, or unset sga_max_size.
[diagnostic 0, 16, 64882]
----------------------------------------

the solution is as under:

1- cd $ORACLE_HOME/bin

2- chmod 4550 oradism
3- chmod g+s oradism
4- chown root:dba oradism
5- Bounce the database

Refer to Metalink note 374367.1 for additional info.