Re: SGA
From: Mtek <mtek_at_mtekusa.com>
Date: Thu, 5 Feb 2009 11:43:14 -0800 (PST)
Message-ID: <bb406b82-4645-445a-a2d0-0103cfda5a4f_at_p2g2000prn.googlegroups.com>
On Feb 5, 9:15 am, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
> 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 --
Date: Thu, 5 Feb 2009 11:43:14 -0800 (PST)
Message-ID: <bb406b82-4645-445a-a2d0-0103cfda5a4f_at_p2g2000prn.googlegroups.com>
On Feb 5, 9:15 am, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
> 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 --
Thanks for all your replies. One thing I am looking for is how to identify certain situations and what effect it has when you change a certain memory parameter, on the situation, on the entire database?
Examples:
I have some issues with my sort area. So I increase that. What effect would have on the SGA, PGA, UGA, etc.......I think that kind of information can be quite useful.....
OR
Certain packages are executed hundreds of time. Should they be pinned? If yes, again, what effect on everything.....
That kind of info is a good tool to have.....
Much Thanks Again.... Received on Thu Feb 05 2009 - 13:43:14 CST