Re: sort_area

From: Ivan Bajon <iba_at_no_spam@post1.tele.dk>
Date: Mon, 4 Oct 1999 13:13:32 +0200
Message-ID: <7ta253$ll1$1@news.inet.tele.dk>

Hi Jack

sort_area_size is part of the PGA (the user's allocated memory) when running Oracle without the Multithreaded Server Option (MTS). If you are running MTS (which you're probably not) sort_area_size is part of the UGA which resides in SGA. So, calculate SGA without sort_area_size.

Regards,
Ivan Bajon
Senior Consultant, OCP

Jack Zhu <jackzhu_at_qwestinternet.net> wrote in message news:37F83D13.AE8B9209_at_qwestinternet.net...
> Hi,
>
> From the book "Oracle Performance Tunning Tips&Techniques", I know
> "sort_area_size" is not belonged to Oracle SGA. But the "Oracle for
> Linux manual" (from Oracle Corp.) clearly indicated that when we
> calculate the SGA size, we have to add the "sort_area_size" size.
>
> I'm confused. Which one is right?
>
> Thanks!!!
>
Received on Mon Oct 04 1999 - 06:13:32 CDT

Re: sort_area_size?