RE: guidance

That Burleson paper referenced below,
<http://www.praetoriate.com/oracle_tips_sorting_operations.htm> http://www.praetoriate.com/oracle_tips_sorting_operations.htm, is quite entertaining. (I'd be careful with using it as guidance) Found at least 5 errors/urban myths is in it which is pretty good for such a short paper. His last paragraph for sure cracks me up:  

<quote> If you like Oracle tuning, you might enjoy my latest book "Creating a Self-tuning Oracle Database" by Rampant TechPress. It's only $9.95 (I don't think it is right to charge a fortune for books!) and you can buy it right now at this link:
 <http://www.rampant.cc/book_oracle9i_sga.htm> www.rampant.cc/book_oracle9i_sga.htm </quote>    

-----Original Message-----
Sent: Friday, September 26, 2003 11:45 AM To: Multiple recipients of list ORACLE-L

Indeed, that statement doesn't even pass the 'Is it reasonable test'.

Assume a sort in memory takes 0.2 seconds. Accordingly, the same sort on disk would take 46.7 minutes:

( .2 * 14000 ) / 60 = 46.6666666666667

That just doesn't sound reasonable to me.

Jared

        "Cary Millsap" <cary.millsap_at_hotsos.com> Sent by: ml-errors_at_fatcity.com

 09/26/2003 08:34 AM
 Please respond to ORACLE-L

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

I'd be interested to see the sequence of tests that support the hypothesis that "disk sorts are about 14,000 times slower than memory sorts."

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:

- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...

-----Original Message-----
DENNIS WILLIAMS
Sent: Thursday, September 25, 2003 12:30 PM To: Multiple recipients of list ORACLE-L

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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Cary Millsap
 INET: cary.millsap_at_hotsos.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: Rognes, Sten
  INET: Sten.Rognes_at_schwab.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).