Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2002
    Posts
    165

    Unanswered: Paging without need for paging

    I just create database.My machine is running Win2000,there are plenty of RAM (2 GB),and available physical RAM is 1,7 GB.I choose for Oracle SGA 1 GB.But,I realized Oracle choose 128 MB for physical RAM,and others in virtual memory.Now I have 1,6 GB physical memory free.
    How one can say:Hey,Oracle,use physical memory!!!

    Thanks,Zvonimir

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Oracle allocates the memory as needed, the sizing parameters you have specified are the limit. You can force Oracle to pre-allocate the entire SGA using PRE_PAGE_SGA=YES in your init.ora.

    Hth
    Bill

  3. #3
    Join Date
    Jan 2002
    Posts
    165
    Thanks a lot,i thought Oracle at startup allocate memory.......

  4. #4
    Join Date
    Oct 2003
    Posts
    706

    Thanks a lot,i thought Oracle at startup allocate memory.......
    Memory is allocated on-demand and "it's all virtual" and that's really the way you want it to be. You can rely upon the operating-system to minimize physical paging I/O as much as it possibly can. In your situation the computer may never page anything out at all. Even though DBMSes like Oracle are brimming with memory-management knobs of their own, I think it best that the host operating-system be left as the master of its own affairs. "Chips are cheap" now, although they weren't when those knobs were put in.
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •