DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: In Oracle 9i, does Oracle require SGA memory on startup.

  1. 06-29-2004, 04:51 AM #1
    ssmith
    ssmith is offline Senior Member
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258

    In Oracle 9i, does Oracle require SGA memory on startup.

    When you startup Oracle, and the shared_pool_size is 160m, the buffer_cache_size is 80m, and the log_buffer=512K. Does Oracle require 240m on startup. I remember in previous releases you could load the SGA on startup on Unix (can't remember the parameter). Or does Oracle only require the memory when it is needed? This is an 9i database.
    Reply With Quote Reply With Quote
  2. 06-29-2004, 09:30 AM #2
    tamilselvan
    tamilselvan is offline Senior Advisor
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    You need more than 240 MB memory to startup oracle.

    Tamil
    Reply With Quote Reply With Quote
  3. 06-29-2004, 09:52 AM #3
    slimdave
    slimdave is offline Foreign Script Kiddie
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    I believe that the behaviour is governed by the parameter prepage_sga, or something like that.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE
    Reply With Quote Reply With Quote
  4. 06-29-2004, 11:56 AM #4
    julian
    julian is offline Senior Advisor
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Yeah, with pre_page_sga, you may read the entire SGA into real memory at instance startup.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width