Bigger SGA = Faster recovery?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Bigger SGA = Faster recovery?

  1. #1
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204

    Bigger SGA = Faster recovery?

    Will a larger SGA make recovery any faster (10.2)?
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    That sounds like a theoretical question... Will a larger SGA make recovery faster for a generally small database that requires very little recovery, not likely. But if the database is larger either in the 100's of GB or terabyte range, doesn't it still depend on the type of recovery needed and how that recovery makes use of the SGA.

    I would bet that someone could create a large 10g test database with a 2GB SGA with auto tuning features turned on and a known amount of recovery that needs to happen. Perhaps you can do 10 large updates on different sqlplus sessions, then without commiting in any session, do a shutdown abort and bring up the database with timing turned on. Then change the SGA to 4GB and do the exact same test again.

    I would guess that if the SGA is properly sized making it gigantic would not help, and some would argue that if you make the SGA too large it might take longer to recover. But enough speculation let us know how it turns out!
    this space intentionally left blank

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