DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: permisible size of sga

  1. #1
    Join Date
    May 2002
    Posts
    193
    Dear Sir,

    I have a total sga size of around 36% of my ram (on advanced server 2000). What is the maximum allowable size of the total ram (%) can the sga have (as a thumb rule). I need to know this as I will have to increase the buffers for a greater hit ratio.

    Regards,

    K.Diwakar

    [Edited by diwakar on 06-08-2002 at 08:27 AM]

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    yes very interesting

  3. #3
    Join Date
    May 2002
    Posts
    193
    Of course this is not a place to post questions which I did not notice when I posted this question but posting such intelligent replies by a senior person like the moderator does not give weightage to your position. A thread with the same name has been started in the other section

    [Edited by diwakar on 06-12-2002 at 07:30 AM]

  4. #4
    Join Date
    Apr 2002
    Location
    Phoenix, AZ
    Posts
    175
    OS needs some RAM,
    other tools like Backups, Internet Explorer running need some RAM,

    take the rest for Oracle to a point you avoid paging/swapping
    Sridhar R Patnam

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by diwakar
    Of course this is not a place to post questions which I did not notice when I posted this question but posting such intelligent replies by a senior person like the moderator does not give weightage to your position. A thread with the same name has been started in the other section

    [Edited by diwakar on 06-12-2002 at 07:30 AM]
    at the end you learnt to read

  6. #6
    Join Date
    May 2002
    Posts
    193
    hello Mr Pando....

    What a sensible comment by an intelligent person..... Once again three cheers to u. I wouldnt like to add anything more to this....... Leaving it open to everyone.....



  7. #7
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    So diwaker,
    Did you find out how much memory you can allocate?
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  8. #8
    Join Date
    Nov 2001
    Posts
    335
    Originally posted by diwakar
    Of course this is not a place to post questions which I did not notice when I posted this question but posting such intelligent replies by a senior person like the moderator does not give weightage to your position. A thread with the same name has been started in the other section

    [Edited by diwakar on 06-12-2002 at 07:30 AM]
    diwakar,
    Why this is not a place to post questions like you did?What is other section where thread with the same name started?

    One, who thinks that the other one who thinks that know and does not know, does not know either!

  9. #9
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    It is advisable to look /search for the FAQ in the forum/on the net. There you'll be able to gather more information than expecting/waiting for an answer which others may or may not answer.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  10. #10
    Join Date
    Nov 2001
    Posts
    335
    I agree, it is advisable. However, if someone did not do this then he/she could be suggested to do so or provided a link to related threads.
    There is nothing wrong with asking any kind of question in regards of Oracle database administration in this forum. It is a open forum after all.
    One, who thinks that the other one who thinks that know and does not know, does not know either!

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