The Answer to Free Memory, Swap, Oracle and Everything

Posted in: Technical Track

Update 2007.12.19: This presentation is now available online here, including a comprehensive whitepaper.

I have submitted an abstract for my new presentation about linux/unix memory and Oracle to the Rocky Mountain Oracle Users Group for the Training Days in Denver on February 14-15, 2007. I pilot tested it at the Ottawa Oracle User Group in June. The feedback was good and since then I have kept developing the presentation. Soon to be submitted for HotSos 2007.

It reads:

  • Do I have enough memory?
  • Why is my free memory so low?
  • Am I swapping to disk?
  • Can I increase my SGA (db cache) size?
  • Can I add another instance to this server?
  • Are my system resources used optimally?

These are all questions that often haunt DBAs. This presentation is The Answer. It covers in detail the different types of memory, how to monitor memory and how to optimally use it with Oracle in mind. It explains how to effectively use tools such as “top”, “vmstat” and “/proc/meminfo”.

Multiple examples throughout the presentation demonstrate how certain actions on the database side cause different memory areas to be allocated and used on the OS side. The attendees will leave with good understanding of how memory is used on a Linux OS and should be able to apply this knowledge to optimally configure their servers.

Interested in working with Christo? Schedule a tech call.

About the Author

An Oracle ACE with a deep understanding of databases, application memory, and input/output interactions, Christo is an expert at optimizing the performance of the most complex infrastructures. Methodical and efficiency-oriented, he equates the role of an ATCG Principal Consultant in many ways to that of a data analyst: both require a rigorous sifting-through of information to identify solutions to often large and complex problems. A dynamic speaker, Christo has delivered presentations at the IOUG, the UKOUG, the Rocky Mountain Oracle Users Group, Oracle Open World, and other industry conferences.

3 Comments. Leave new

I’m looking forward to seeing that, if I get the chance ;-)

Christo Kutrovsky
October 5, 2006 10:25 am

I am glad it caught your attention :-)


Is there any where i can view this, please? I always seem to come late to these sorts of issues :-)


Leave a Reply

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