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

Thread: Urgent

  1. #1
    Join Date
    Sep 2002
    Posts
    21
    Hi lists,
    See the RAM is 1GB and Database is 20 GB
    Then, what should be the SGA size .
    Kindly make it asap..
    bye
    Saravanan Oracle DBA(8i OCP)


  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    SGA can be upto 500MB. What is the present SGA setting?

    Moreover, check v$sgastat for 'free memory' after 1 day of peak activity.

    Cheers.



  3. #3
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Oracle recommeds that you should leave 20% of RAM for unix processes. If this is the case you could use up to 80% or the RAM (if there is only one instance running).
    OCP 8i, 9i DBA
    Brisbane Australia

  4. #4
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by grjohnson
    Oracle recommeds that you should leave 20% of RAM for unix processes.
    Hi

    Can you please post the link/url of this note/article to facilitate a detailed study of this issue.

    Thanks & Regards.


    [Edited by ggnanaraj on 09-24-2002 at 02:29 AM]

  5. #5
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    SGA can actually be as big as you want as long as you avoid paging and swapping.

    saran - depends on database requirements as to how you size SGA. To start with, you need to run some scripts on dictionary cache, library cache, buffer pool, redo log buffer and check hit ratio's to decide how to size these areas.

    I think you will find these scripts at this site. They are also posted all over the web.


    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

Posting Permissions

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


Click Here to Expand Forum to Full Width