HPE Community
Operating System - HP-UX
1832880 Members
2292 Online
110048 Solutions
New Discussion

Re: what is the available RAM space status for tuning Oracle

 
praveen..
Super Advisor

‎01-25-2006 05:20 AM

‎01-25-2006 05:20 AM

what is the available RAM space status for tuning Oracle

hi,
what is the available RAM space status for tuning Oracle

Please suggest
0 Kudos
Reply
2 REPLIES 2
James R. Ferguson
Acclaimed Contributor

‎01-25-2006 05:30 AM

‎01-25-2006 05:30 AM

Re: what is the available RAM space status for tuning Oracle

Hi:

Oracle is a memory hungry beast. There is no one specific value for the memory it needs. That is dependent upon your specific environment and application.

I would enable pseudoswap ('swapmem_on' in the kernel); use VxFS (JFS) mount options that bypass the Unix buffer cache and provide generous settings for Oracle's SGA and monitor performance.

Regards!

...JRF...
0 Kudos
Reply
Geoff Wild
Honored Contributor

‎01-25-2006 06:08 AM

‎01-25-2006 06:08 AM

Re: what is the available RAM space status for tuning Oracle

Use tools like top and glance to see current memory utilization.

I also attached a c program that you can compile called memdetail.

# memdetail
Memory Stat total used avail %used
physical 14240.0 13676.6 563.4 96%
active virtual 15805.5 6022.2 9783.2 38%
active real 10880.7 3868.7 7012.0 36%
memory swap 11139.4 1756.8 9382.7 16%
device swap 26528.0 15182.0 11346.0 57%

Rgds...Geoff
Proverbs 3:5,6 Trust in the Lord with all your heart and lean not on your own understanding; in all your ways acknowledge him, and he will make all your paths straight.
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.