I think I've missed a bit of this thread so apologies in advance.
I always set timed_statistics-true and I don't worry unduly about lots of
extents.
I'm aware of problems with both approaches (bugs etc.) but as general principles
I'm happy with them and they've never caused a problem.
What's to repent about?
Regards,
Mike
|--------+----------------------->
| | "Rachel |
| | Carmichael" |
| | <carmichr@hot|
| | mail.com> |
| | |
| | 06/28/01 |
| | 10:45 AM |
| | Please |
| | respond to |
| | ORACLE-L |
| | |
|--------+----------------------->
>-------------------------------------------------------------------|
| |
| To: Multiple recipients of list ORACLE-L |
| <[EMAIL PROTECTED]> |
| cc: (bcc: Mike Hately/ETECH) |
| Subject: Re: OT: Exploding the Mythns |
>-------------------------------------------------------------------|
repent? that presentation deliberately contained truth AND non-truth to
make people think
lots=> 4000
in no way shape or form was it written for 9i
>From: Paul Drake <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>CC: [EMAIL PROTECTED]
>Subject: Re: OT: Re: Common Oracle RDBMS Misconceptions
>Date: Thu, 28 Jun 2001 01:09:44 -0400
>
>
>Rachel,
>
>In the presentation, I saw:
>
>always set timed_statistics=true
>having lots of extents is not a problem - |lots|= ???
>
>Care to repent - or stipulate that it was for a de-supported (or soon to
>be) version?
>
>Paul
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).