Re: JC's DBA Guide - How do I get it?
Date: 14 Apr 93 12:56:05 GMT
Message-ID: <2056_at_wtcp.DaytonOH.NCR.COM>
In article <1993Apr13.161226.12136_at_dragon.acadiau.ca> peter_at_dragon.acadiau.ca (Peter Steele) writes:
->My original posting was:
->
->>What are the ramifications on Oracle performance if I increase the
->>size of the SGA?
- Stuff deleted --
->>Are there other parameters I should change? Is there a performance
->>document archived somewhere describing any of this?
- Stuff deleted --
->>From: Jonathan Creighton <jcreight_at_us.oracle.com>
->
->It depends on the application. Before increasing the size of the SGA,
->you should collect statistics using the STATISTICS option of the SQL*DBA
->MONITOR command. These will tell you whether you need to increase
->the SGA size.
->
->The tuning of the buffer cache is covered in the "Database Tuning"
->chapter, on page 20-11 of my DBA guide.
^^^^^^^^^^^^
OK, I'll byte. How do I get a copy of Jonathan Creighton's DBA Guide?
-- Ron Beery IRM - WTC Operations, Technical Support Telephone: (513) 445-1596 Ron.Beery_at_wtcp.DaytonOH.NCR.COM VOICEplus: 662-1596 ...!uunet!ncrcom!wtcp!rbeeryReceived on Wed Apr 14 1993 - 14:56:05 CEST