- 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
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
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.
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.
Subscribe to:
Posts (Atom)