Call (800) 766-1884 for Oracle support & training
Free Oracle Tips


Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance
 

Free Oracle Tips


 

HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

 

RAM and Swap Disk Tips

Donald Burleson

RAM and Swap Disk


Whatever the operating platform, the processing demands of the Oracle database must not exceed the real RAM memory of the server. All large servers share RAM resources through a Virtual Memory (VM) scheme. Oracle servers (Windows, UNIX, and OS-390) manage excessive RAM demands with a special swap disk, and virtual memory exploits the fact that not every executing task is constantly referencing its RAM memory region.

Since some RAM regions are accessed intermittently, vendors have developed paging algorithms that shift these memory pages to the swap disk when they are not in use.

The swap disk is a special disk area that provides for RAM sharing, primarily by storing page frames of inactive disk programs. The least-frequently-used (LRU) RAM pages are offloaded so that new applications can simultaneously share the same memory. After inactive RAM frames are paged-out to the disk, the operating system can utilize the freed memory for other active tasks.

If the inactive program later resumes execution, the RAM frames are paged-in from the swap disk.

This reloading of RAM pages from one memory area to another is called swapping. Swapping is very time-consuming and degrades performance of the application.

The swap disk allows simultaneous RAM usage greater than the real amount of RAM, but performance will be seriously compromised if the swap disk is used for active programs. The impaired performance is due to the much slower read times from the swap disk, compared to RAM. Disk access is measured in milliseconds, or millionths of a second, while RAM access is measured in nanoseconds, or billionths of a second.

Not all of this difference can be practically realized because of Oracle overhead, but most experts say that Oracle RAM is about 2,500 times faster than disk access.
 

 
 
 
Get the Complete
Oracle Tuning Details 

The landmark book "Oracle Tuning: The Definitive Reference Second Edition" has been updated with over 1,150 pages of expert performance tuning tips. It's packed with scripts and tools to hypercharge Oracle 11g performance and you can buy it for 40% off directly from the publisher.
 


 

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

  
 

Oracle performance tuning software 
 
 
 
 

Oracle performance tuning book

 

 
 
 
Oracle performance Tuning 10g reference poster
 
 
 
Oracle training in Linux commands
 
Oracle training Excel
 
Oracle training & performance tuning books
 
   

Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.