Oh he
does that all the time, part time DBA, full time salesman. You got to make
the big bucks somehow...
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Rognes, Sten
Sent: Friday, September 26, 2003 3:15 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: guidanceThat Burleson paper referenced below, 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:www.rampant.cc/book_oracle9i_sga.htm </quote>-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, September 26, 2003 11:45 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: guidance
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
Please respond to ORACLE-L
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).
