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

Thread: Sga_target ?

  1. 04-23-2007, 04:37 PM #1
    pascal01
    pascal01 is offline Member
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    222

    Exclamation Sga_target ?

    I have a 4G memory windows server. I want to create an OLTP database on this machine. I have Oracle 10.2 installed. I want to use 2G of memory for this instance. Can someone please advise whether I should set the SGA_TARGET to 2G and have the server manage the buffer_pool and shared_pool? Can someone please advise whether this is good practice or should I manually set the memory parameters? I never used this parameter before and I am not sure what impact it might have on performance. Thank you.
    Reply With Quote Reply With Quote
  2. 04-23-2007, 05:59 PM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    just use the auotmatic stuff, if it doesnt work for you change it

    Thats a pretty small server so it will get it mostly right
    Reply With Quote Reply With Quote
  3. 04-24-2007, 05:16 AM #3
    waitecj's Avatar
    waitecj
    waitecj is offline Advisor
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Just remember that if you keep the old parameters set, they become the minimum size the respective pool will shrink to. If you have them set too high, you will limit Oracle's ability to make its own mind up about how it should share about the memory.
    Assistance is Futile...
    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