Dear All,

One of my database server is with memory utilization 100%. I want to find out what is the memory usage of each of the oracle components in that server. Is there any script(s) out there that can help me find out the memory usage of the following components:

1. database instance (background process + sga)
2. database server processes (eg. user connections)
3. ASM instance
4. clusterware
5. EM Agent.

Regards,

-- Chris