Thanks, I'll post.
-Original Message-
Sent: Thursday, March 21, 2002 3:58 AM
To: Multiple recipients of list ORACLE-L
Why not post the query and the two plans ?
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html
Thanks
-Original Message-
Sent: Wednesday, March 20, 2002 11:23 PM
To: Multiple recipients of list ORACLE-L
Are the sizes of the tables same on both development and production
machines? In our case, we used histograms on indexed columns and that
brought execution plans same on both the
Why not post the query and the two plans ?
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Build
Are the sizes of the tables same on both development and production
machines? In our case, we used histograms on indexed columns and that
brought execution plans same on both the database.
Look for analyze command syntax to build histograms.
--- [EMAIL PROTECTED] wrote:
> Both have current stati
Both have current statistics. Data distribution is smaller on DEV. Both
are using CBO.
-Original Message-
Sent: Tuesday, March 19, 2002 4:53 PM
To: Multiple recipients of list ORACLE-L
What about current statistics on both DBs?
Is the distribution of the data reasonably the same?
Are
Thank you..
Buffer cache is smaller on DEV.
What specific parameters are you refering you?
Indexes are in the same order.
-Original Message-
Sent: Tuesday, March 19, 2002 5:52 PM
To: Multiple recipients of list ORACLE-L
buffer cache size the same ?
init.ora parameters the same ?
index
Thank you I will look into this option. Can tell me more on this if have
already implemented this feature.
Srini
-Original Message-
Sent: Wednesday, March 20, 2002 1:58 AM
To: Multiple recipients of list ORACLE-L
hi Srini,
Why don;t you use stored outlines.
-Original Message
Yes they both are, only difference being the amount of data in Prod and DEV
databases for this query. Prod has more.
Srini
-Original Message-
Sent: Tuesday, March 19, 2002 9:43 PM
To: Multiple recipients of list ORACLE-L
Are the tables/indexes analyzed the same way, if you use CBO?
hi Srini,
Why don;t you use stored outlines.
-Original Message-
Sent: Tuesday, March 19, 2002 20:18
To: Multiple recipients of list ORACLE-L
Hello:
I have an identical query that has similar explain plan on both Prod and Dev
environment, only difference being that certain indexes are
Are the tables/indexes analyzed the same way, if you use CBO?
- Kirti
-Original Message-
Sent: Tuesday, March 19, 2002 4:14 PM
To: Multiple recipients of list ORACLE-L
Thank you for the response. The indexes on both sides are regular non-unique
indexes. Any other possible reasons..
buffer cache size the same ?
init.ora parameters the same ?
index columns created in similar order
Anjo.
[EMAIL PROTECTED] wrote:
> Thank you for the response. The indexes on both sides are regular non-unique
> indexes. Any other possible reasons..
> Srini
>
> -Original Message-
> Sen
Thank you for the response. The indexes on both sides are regular non-unique
indexes. Any other possible reasons..
Srini
-Original Message-
Sent: Tuesday, March 19, 2002 1:34 PM
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] wrote:
>
> Hello:
>
> I have an identical query
What about current statistics on both DBs?
Is the distribution of the data reasonably the same?
Are they both using the same optimizer?
I would state that "obiviously" something is different
between the two instances; otherwise you'd get exactly
the same results.
[EMAIL PROTECTED] wrote:
>
> H
[EMAIL PROTECTED] wrote:
>
> Hello:
>
> I have an identical query that has similar explain plan on both Prod and Dev
> environment, only difference being that certain indexes are performing
> unique scan on Prod and Range scan on Dev.
> Can you cast some light on how this can be matched and unde
Reply-To: [EMAIL PROTECTED]
>>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>>Subject: Re: Oracle tuning book
>>Date: Tue, 08 May 2001 16:45:25 -0800
>>
>>I'm not sure about the "Mogens as god" deal, but Gaja is a
>fine eva
an teach me much and who I
feel privileged to have met
>From: Don Granaman <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Oracle tuning book
>Date: Tue, 08 May 2001 16:45:25 -0800
>
>I
rti" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: Oracle tuning book
> >Date: Tue, 08 May 2001 09:32:54 -0800
> >
> >Yes it is..
> >That's my official
On Tue, 8 May 2001,Rachel Carmichael scribbled on the wall in glitter crayon:
->brilliant :)
Well, that let's me out.;-)
--
Bill Thater Certifieable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't
brilliant :)
>From: "Kevin Kostyszyn" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Oracle tuning book
>Date: Tue, 08 May 2001 11:55:33 -0800
>
>Just a quick one,
I read the book from Sean Hull and Andy Duncan, and it is a really good
book.
The only thing that was expecting in that one was a brief description of
mod_plsql
and a few examples. Other then that, it mentions practically every open
source tool
worth mentioning. I love the description of Matt's Or
[EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Oracle tuning book
>Date: Tue, 08 May 2001 09:32:54 -0800
>
>Yes it is..
>That's my official full first name..
>Hope Mogens doesn't get any ideas ;)
>
>- Ki
in
fun, but boy did Gaja jump :)
Rachel
>From: "Deshpande, Kirti" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Oracle tuning book
>Date: Tue, 08 May 2001 09:32:54 -0800
>
>
Yes it is..
That's my official full first name..
Hope Mogens doesn't get any ideas ;)
- Kirti
> -Original Message-
> From: Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 10:46 AM
> To: Multiple recipients of list ORACLE-L
> Subjec
yup -- Kirti wrote it with Gaja and did a heck of a job too!
>From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Oracle tuning book
>Date: Tue, 08 Ma
I'd be scared except I KNOW it's good :)
>From: Kimberly Smith <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Oracle tuning book
>Date: Tue, 08 May 2001 07:40:52 -0800
>
>OK
ltiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Oracle tuning book
>Date: Tue, 08 May 2001 06:25:49 -0800
>
>On Tue, 8 May 2001,Rachel Carmichael scribbled on the wall in glitter
>crayon:
>
>->one that will be out in a few weeks... Oracle Per
On Tue, 8 May 2001,Jamadagni, Rajendra scribbled on the wall in glitter crayon:
->Kirti,
->
->Is that your name on the book with Gaja?
I do believe so.;-) And the other autograph I'll need to get.;-)
--
Bill Thater Certifieable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
OK Rachel, based on your recommendation alone I am going after management
to get that book so my other half has an idea what I am talking about when I
ask him to do something. I just love training new DBA's.
-Original Message-
Sent: Tuesday, May 08, 2001 6:26 AM
To: Multiple recipients
Kirti,
Is that your name on the book with Gaja?
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have f
it is :)
>From: "Thater, William" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Oracle tuning book
>Date: Tue, 08 May 2001 06:25:49 -0800
>
>On Tue, 8 May 2001,Rachel
On Tue, 8 May 2001,Deshpande, Kirti scribbled on the wall in glitter crayon:
->Bill,
->
->Yes it is. Trust Me ;)
->
->- Kirti Deshpande
OK. I done already ordered it.;-)
"Hi my name is Bill and I'm a Compulsive Tuner.";-)
--
Bill Thater Certifieable ORACLE DBA
Telergy, Inc.
On Tue, 8 May 2001,Rachel Carmichael scribbled on the wall in glitter crayon:
->one that will be out in a few weeks... Oracle Performance Tuning 101 by Gaja
->Krishna Vaidyanatha, a member of this list. (Oracle Press)
If the book is written like he presents, I'm ordering my copy now. [Now if I
Bill,
Yes it is. Trust Me ;)
- Kirti Deshpande
> -Original Message-
> From: Thater, William [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 9:26 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Oracle tuning book
>
> On Tue, 8 May 2
:Re: Oracle tuning book
one that will be out in a few weeks... Oracle Performance Tuning 101
by Gaja
Krishna Vaidyanatha, a member of this list. (Oracle Press)
No, I do not get anything for promoting this book -- except perhaps
a hug
from Gaja the next time I
Seema,
I just got back from a seminar presented by Richard Niemiec of TUSC corp.
His seminar was super and very informative. I would recommend his book on tuning. It
can be located at www.tusc.com and is on sale this week.
ROR mª¿ªm
>>> [EMAIL PROTECTED] 05/07/01 06:11PM >>>
Hi
Which book is go
one that will be out in a few weeks... Oracle Performance Tuning 101 by Gaja
Krishna Vaidyanatha, a member of this list. (Oracle Press)
No, I do not get anything for promoting this book -- except perhaps a hug
from Gaja the next time I see him (but I'd get that anyway)
I was privileged to do t
Title: RE: Oracle tuning book
> -Original Message-
> From: Seema Singh [mailto:[EMAIL PROTECTED]]
>
> Which book is good for oracle tuning(8i)?
> Thanks
This book is very good, and covers Oracle 8i (I'm not sure in how much detail Oracle 8.1 is discussed,
The frequency of when a script should be run depends entirely on what the
script does.. For instance - You may have a script that looks for space
bound objects within your database (can't throw their next extent),
depending on the number of objects within your database, this could be a
REAL KILLER
38 matches
Mail list logo