Re: How to understand SGA?

From: Nan Xiao <xiaonan830818_at_gmail.com>
Date: Mon, 29 Feb 2016 15:07:04 +0800
Message-ID: <CA+MhoaP4G=Ja6c4_zEBitVtYuvp5UhquRNQaKUeyGqoETXvqjg_at_mail.gmail.com>



Hi Chris,

Thanks very much for your reply!

I should check these materials first when meeting issues next time.

Best Regards
Nan Xiao

On Mon, Feb 29, 2016 at 2:25 PM, Christian Antognini < Christian.Antognini_at_trivadis.com> wrote:

> Hi
>
> I have a generic but IMO important advice for you.
>
> When dealing with questions like the following...
>
> > So what is the meaning of "server processes" here? Which definition is
> more accurate? How to understand SGA?
>
> ... the first thing you should do is to open the Concept Guide at
> http://docs.oracle.com/database/121/CNCPT/toc.htm. For example, in this
> specific case, "Overview of the System Global Area (SGA)" at
> http://docs.oracle.com/database/121/CNCPT/memory.htm#GUID-24EDB8CD-8279-4CED-82AF-642FC01A4A73.
> In there you also find the term "server processes"... so, if you don't know
> what those things are, you check the Glossary available in the same book.
> So, for "server processes", you find a definition at
> http://docs.oracle.com/database/121/CNCPT/glossary.htm#GUID-E660AC1C-B704-4DC1-A35A-DB49EFB34F4A
> .
>
> The Concept Guide is one of the most important books published by Oracle.
> Every time you have question related to the architecture of the database
> engine, you should refer to it.
>
>
> HTH
> Chris Antognini
>
> Troubleshooting Oracle Performance, Apress 2008/2014
> http://top.antognini.ch
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 29 2016 - 08:07:04 CET

Original text of this message