Hi all:
I have been reading on the optimizer_ parameters for
Oracle 9i - optimizer_max_permutation,
optimizer_index_caching and optimizer_index_cost_adj.
I have also been playing whith them and I can see that
they affect the explain plans for some queries quite
dramatically. Is there any
PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
From: Gurelei [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L
Subject: optimizer parameters in Oracle 9.2
Hi all:
I have been reading
See http://www.evdbt.com/SearchIntelligenceCBO.doc
Hemant
At 06:04 AM 30-07-03 -0800, you wrote:
Hi all:
I have been reading on the optimizer_ parameters for
Oracle 9i - optimizer_max_permutation,
optimizer_index_caching and optimizer_index_cost_adj.
I have also been playing whith them and I
: Gurelei [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L
Subject: optimizer parameters in Oracle 9.2
Hi all:
I have been reading on the optimizer_ parameters
for
Oracle 9i - optimizer_max_permutation,
optimizer_index_caching
: Wednesday, July 30, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L
Subject: optimizer parameters in Oracle 9.2
Hi all:
I have been reading on the optimizer_ parameters
for
Oracle 9i - optimizer_max_permutation,
optimizer_index_caching and
optimizer_index_cost_adj.
I have
Tim Gorman scribbled on the wall in glitter crayon:
Please be aware that the paper and presentation were written in the 8i
timeframe. I swear I'll get it updated for 9i, but already 10G is
looming and it's summer and the weather is nicesigh...
and the 9i migration here is scheduled
Subject: Re: optimizer parameters in Oracle 9.2
Please be aware that the paper and presentation were written
in the 8i timeframe. I swear I'll get it updated for 9i, but
already 10G is looming and it's summer and the weather is
nicesigh...
on 7/30/03 8:24 AM, Gurelei
Subject: optimizer parameters in Oracle 9.2
Hi all:
I have been reading on the optimizer_ parameters
for
Oracle 9i - optimizer_max_permutation,
optimizer_index_caching and
optimizer_index_cost_adj.
I have also been playing whith them and I can
see
that
they affect
Message-
From: Thater, William [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 11:44 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: optimizer parameters in Oracle 9.2
Tim Gorman scribbled on the wall in glitter crayon:
Please be aware that the paper and presentation
Collecting system statistics in 9i is supposed to automagically do what
optimizer_index_cost_adj does, at least if you set it according to the
formula in Tim's paper (The Search for Intelligent Life in the Cost-Based
Optimizer). The CBO then uses different cost factors for single-block IO
Manager
[EMAIL PROTECTED]
(813) 827-9974 DSN 651-9974
-Original Message-
From: Tim Gorman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 12:30 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: optimizer parameters in Oracle 9.2
Please be aware that the paper
11 matches
Mail list logo