Message-ID: <F001.005D10E6.20030925083441@fatcity.com>
Date: Thu, 25 Sep 2003 08:34:41 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: ml-errors@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "Jesse, Rich" <Rich.Jesse@qtiworld.com>
Subject: RE: guidance
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

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@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@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@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@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@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).