optimizer parameters in Oracle 9.2

2003-07-30 Thread Gurelei
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

RE: optimizer parameters in Oracle 9.2

2003-07-30 Thread Jesse, Rich
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

Re: optimizer parameters in Oracle 9.2

2003-07-30 Thread Hemant K Chitale
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

RE: optimizer parameters in Oracle 9.2

2003-07-30 Thread Gurelei
: 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

Re: optimizer parameters in Oracle 9.2

2003-07-30 Thread Tim Gorman
: 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

RE: optimizer parameters in Oracle 9.2

2003-07-30 Thread Thater, William
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

RE: optimizer parameters in Oracle 9.2

2003-07-30 Thread Wolfe Stephen S GS-11 6 MDSS/SGSI
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

Re: optimizer parameters in Oracle 9.2

2003-07-30 Thread 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

RE: optimizer parameters in Oracle 9.2

2003-07-30 Thread Jesse, Rich
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

Re: optimizer parameters in Oracle 9.2

2003-07-30 Thread Wolfgang Breitling
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

RE: optimizer parameters in Oracle 9.2

2003-07-30 Thread Luis deUrioste
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