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
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 under what conditions
this discrepancy mig
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,
for a beginner. I learned a lot.
Should be out by the end of May, I believe you can pre-order it already.
Rachel
>From: "Seema Singh" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Oracle tuni
[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]
;Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Oracle tuning book
>Date: Mon, 07 May 2001 14:11:39 -0800
>
>Hi
>Which book is good for oracle tuning(8i)?
>Thanks
>-Seema
>___
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
;
Hi
Which book is good for oracle tuning(8i)?
Thanks
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
INET: [EMAIL PRO
D]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Oracle tuning book
>Date: Mon, 07 May 2001 14:11:39 -0800
>
>Hi
>Which book is good for oracle tuning(8i)?
>Thanks
>-Seema
>_
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,
Hi
Which book is good for oracle tuning(8i)?
Thanks
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
INET: [EMAIL
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
When I took over the position of Oracle DBA I inherited a number of scripts,
including some
tuning scripts. Plus through this list and meta-link I have found a number
of resources about
tuning, What I am unsure about is when to capture the information required
for tuning decisions
The scripts I
41 matches
Mail list logo