How to determine SGA (shared_pool) fragmented

[Bill Hassell]

There's two types of SGA fragmentation: internal (caused by Oacle), and kernel (caused by multiple 32bit applications using the same memory map). If the issue is that stop/restart of a 32bit Oracle instance errors with not enough memory, it is a kernel condition and you'll need ipcs and shminfo.
For ipcs, use ipcs -bmop
For shminfo, get a copy from ftp://contrib:9unsupp8@hprc.external.hp.com/sysadmin/programs/shminfo/ and read the docs that come with the package. shminfo will show all the other items that are scattered through the 32bit shared memory map. 64bit Oracle will have no practical limits (or fragmentation issues) but for 32bit apps, Memory Windows is the only workaround.