Could you tell me the difference between "roll" memory and "page" memory? I'm using an Oracle/Unix-based OLTP System. I am not a techie.
I'm not quite sure what "roll" is as it refers to Operating Systems. But I can give you an idea of paging and swapping.
Computers have a finite amount of memory. It would be great if all of your programs could fit into that memory. But this is often not the case. To make computers appear as if they have more physical memory (RAM) than they do, we can temporarily use some space on disk. Any space used on disk for the computer's memory is called Virtual Memory.
When a program executes, its instructions are placed into memory. A unit of memory than can hold a programs instructions is called a "page". If the physical memory, or RAM, becomes full, the OS can take portions, or pages of memory that are not currently being used and copy them to disk, copy them to the Virtual Memory. So a page of memory is written to disk. When the instructions in that page are needed, the system reads that page of memory from disk. This often requires a page of memory to be written to disk first to make room for the page to be read in.
If an entire program is moved from memory to disk, this is called a "swap". Swapping can kill performance of any server. If only a portion of a program is moved to disk, this is called "paging".
For More Information
- Dozens more answers to tough Oracle questions from Brian Peasland are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.