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" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 09/26/2003 08:34 AM
|
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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.
[EMAIL PROTECTED]
-----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
[EMAIL PROTECTED] 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:[EMAIL PROTECTED]
> 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
>
> [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
