RE: guidance

PGA_AGGREGATE_TARGET "Jesse, Rich" <Rich.Jesse_at_qtiworld.com>
Sent by: ml-errors_at_fatcity.com
 09/25/2003 09:34 AM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        RE: guidance

OK, I'll bite: If SORT_AREA_SIZE isn't to be set, then what is? Are you referring to the automagic PGA management?

Rich

Rich Jesse                           System/Database Administrator
rjesse_at_qtiworld.com                  Quad/Tech Inc, Sussex, WI USA

10:30 AM CST = 5:30 PM CEST. Rats! Now I'll have to wait until tomorrow for an answer... :)

> -----Original Message-----
> From: Mogens Nørgaard [mailto:mln_at_miracleas.dk]
> Sent: Wednesday, September 24, 2003 6:45 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: guidance
>
>
> Just talked to Jonathan Lewis from Helsinki. He went through
> some of the
> examples given in the latest issue of Oracle Magazine, and they were
> just plain wrong.
>
> I can't recall them in detail, but I think one of the questions were
> which parameter to set in order to let a user do large sorts.
> In 9i you
> shouldn't set sort_area_size, but that was the correct answer. And so
> on, and so forth.
>
> So the important advise is to do what you think they would
> like to hear :).
>
> Mogens
>
> bulbultyagi_at_now-india.net.in wrote:
>
> >List , I am planning to give my 9i performance tuning exam
> on the first .
> >Any advice you all want to give me ? Pretty nervous about
> it. Sure would
> >appreciate your guidance.
> >........

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).