Memory usage for Oracle components
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
5. EM Agent.
Which O/S... is it Linux?
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
The OS is AIX. If you have suggestions on Linux, I would like to know too because I have some database servers that are running on Linux.
Thanks a lot,
Click Here to Expand Forum to Full Width