RE: guidance

Rich - Actually the hint in that posting made me realize what I was wrestling with on an index build. Don Burleson explains it well  http://www.praetoriate.com/oracle_tips_sorting_operations.htm

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, September 25, 2003 11:35 AM To: Multiple recipients of list ORACLE-L

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: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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).