Re: SGA

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Thu, 5 Feb 2009 07:15:32 -0800 (PST)
Message-ID: <4e47df67-535f-4cf8-8687-2ce99a1b9e15_at_j38g2000yqa.googlegroups.com>

On Feb 5, 2:17 am, Robert Klemme <shortcut..._at_googlemail.com> wrote:
> On 05.02.2009 01:42, mrdjmag..._at_aol.com wrote:
>
> > I'm looking for a book that is dedicated to the SGA.  Explaining how
> > the different parts work together, how changing a parameter affects
> > the different parts fo the SGA and the performance.  PGA, Buffer
> > Cache, etc........  Already know how to program.  Do not need a PLSQL
> > review.  Just interested in the SGA in great detail.......
>
> Did you read this?
>
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/memory...
>
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/memory...
>
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/manpro...
>
> If not, it's a good starting point.
>
> Cheers
>
>         robert

Robert, your response lists the same three manuals that came to mind.

Mrdjmag, you cannot go wrong by starting with Concepts, moving to DBA Administration, and then accessing the Performance and Tuning manual as your starting point. Then you can search Oracle support and/or the web for articles written on specific latches, enqueues, and issues.

The full title for the book hpuxrac mentioned is probably: Expert Oracle Database Architecture by Tom Kyte.

HTH -- Mark D Powell -- Received on Thu Feb 05 2009 - 09:15:32 CST