Re: JC's DBA Guide - How do I get it?

From: Ron Beery <rbeery_at_wtcp.DaytonOH.NCR.COM>
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!rbeery
Received on Wed Apr 14 1993 - 14:56:05 CEST

Original text of this message