You were brought to this page based on an internet search
and as a free service to Oracle DBAs.
The text below is an except from the book,
Oracle Performance Firefighting, written by
Craig Shallahamer of
OraPub, Inc.
Figures and tables are not included on this page, only their reference.
To order the book in either print or PDF form, click
here.
©2009, 2010 by Craig Shallahamer. This is copyrighted material.
PleaseOut of respect for those involved in the creation of the book and also for
their familes, we ask you to respect the copyright both in intent and deed. Thank you.
-------------------------------
In memory, paging is the first line of defense. A process asks the operating system for memory (for example, issuing the C malloc call), and the operating system looks for free memory. First, the operating system looks for free memory pages or memory from other processes that have not recently been used. This is called a page fault, but not a physical page fault. (The fault part is unfortunate, but that's what it's called.)
Out-of-memory paging is the second line of defense. If the process memory is not satisfied, the operating system gets a little more aggressive. It now finds another process's memory page (which hopefully has not been used in a while) and writes or pages it out to disk onto the swap area (on Windows, that's the page file). This is known as a page out (po), or a physical page fault. Physical page faults are normal and acceptable up to a point. Your operating system administrator and experience on a specific platform will provide the best guidance.
Swapping is the final line of defense. Traditionally, swapping refers to all memory associated with a process being moved out of real memory and written to disk in the swap area. This is indeed unfortunate, because if the process needs to be run, all that swapped-out memory must be read-swapped-back into real memory. It's expensive from a CPU perspective and when really bad, also from an IO subsystem perspective.
©2009, 2010 by Craig Shallahamer. This is copyrighted material.
PleaseOut of respect for those involved in the creation of the book and also for
their familes, we ask you to respect the copyright both in intent and deed. Thank you.
|