• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oradism Oracle

Oradism Oracle

September 15, 2014 by techgoeasy Leave a Comment

DISM usage is Oracle

Oracle database uses shared memory segment to facitilate many things in the database. Shared memory segment consist of SGA which has buffer cache ,shared pool etcThe shared memory segments is managed either using ISM or DISM in Solaris and Linux

ISM stands for Intimate Shared Memory
DISM stands for Dynamic Intimate Shared Memory

The ISM is a shared memory segment that consists of large locked memory pages. The ISM number of locked pages remains constant or unchanged. Dynamic ISM (DISM) is pageable ISM shared memory, where the number of locked pages is variable or changeable. Therefore, the DISM supports releasing or adding more physical memory to the system during dynamic reconfiguration. The size of the DISM can span available physical memory plus disk swap

Dynamic Intimate Shared Memory (DISM) allows a database to dynamically extend or reduce the size of the shared data segment. This feature eliminates the misconfiguration problem and denial-of-service security vulnerability of Intimate Shared Memory (ISM).

DISM is turned on by default for Oracle
Database 11.2.0.1 on Oracle Solaris, which makes it important for Database
Administrators (DBAs) to understand its capabilities and behavior. as it relates
to the memory_target parameters

Some important points to note
1)Oracle recommends that DISM be turned off by default on SPARC-based servers.

2) Oracle recommends that DISM should always be turned off on
x86-based systems running Oracle Solaris 10.
DISM is set if memory_target or memory_max_target are set or sga_max_size is set and is greater then sum of all the SGA memory components
How to see if the Database is using DISM
We can find it out using pmap command
1) First search the pid for the Oracle smon process
ps -aef | grep ora | grep smon
oracle 1111 1 0 08:34:13 ? 0:45 ora_smon_TEST
2) Now find out ISM or DISM using the below command
pmap –xs 1111 | egrep ‘ism|osm’
It will show like this in case it is using DISM
000000756880000000 38010880 38010880 – 38010880 100M rwxsR [ dism shmid=0xb ]
0000000C90000000   131072 131072   –   131072   4M rwxsR [ dism shmid=0xb ]
0000000C98000000       16     16   –       16   8K rwxsR [ dism shmid=0xb ]
It will show like this in case it is using ISM
0000000380000000 38010880 38010880 – 38010880 1000M rwxsR [ ism shmid=0xb ]
0000000C90000000 131072 131072 – 131072 4M rwxsR [ dism shmid=0xb ]
0000000C98000000 16 16 – 16 8K rwxsR [ ism shmid=0xb ]

Filed Under: Oracle, Oracle Database Tagged With: dism, DISM usage is Oracle, ism

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to use sed replace string in file
  • Password Version in oracle
  • How to login as user without changing the password in Oracle database(alter user identified by values)
  • How to check encrypted tablespace in the Database
  • How To Export -Import TDE Master Encryption Key

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us