RE: RE: CBO, RBO and will v5 ever really go away?

2003-10-23 Thread Hemant K Chitale
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: RE: CBO, RBO and will v5 ever really go away? > > Unfortunately, our applications fall into the second category. And due to > the complexity of the queries being run, attempting to turn on CBO also > activates

RE: RE: CBO, RBO and will v5 ever really go away?

2003-10-20 Thread Bellow, Bambi
PM 02:54:25 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: RE: CBO, RBO and will v5 ever really go away? > > Didn't I mention that? Bug 2954921... simple query blows away one of their > internal views. Here's a snippet of t

RE: RE: CBO, RBO and will v5 ever really go away?

2003-10-20 Thread rgaffuri
is that the correct number? its not on metalink. > > From: "Bellow, Bambi" <[EMAIL PROTECTED]> > Date: 2003/10/20 Mon PM 02:54:25 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: RE: CBO, RBO and will v5 ever really go a

RE: RE: CBO, RBO and will v5 ever really go away?

2003-10-20 Thread Bellow, Bambi
le recipients of list ORACLE-L what is the bug? > > From: "Bellow, Bambi" <[EMAIL PROTECTED]> > Date: 2003/10/20 Mon PM 02:04:26 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: RE: CBO, RBO and will v5 ever really go away?

RE: RE: CBO, RBO and will v5 ever really go away?

2003-10-20 Thread rgaffuri
what is the bug? > > From: "Bellow, Bambi" <[EMAIL PROTECTED]> > Date: 2003/10/20 Mon PM 02:04:26 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: RE: CBO, RBO and will v5 ever really go away? > > Unfortunately, our

RE: RE: CBO, RBO and will v5 ever really go away?

2003-10-20 Thread Bellow, Bambi
Unfortunately, our applications fall into the second category. And due to the complexity of the queries being run, attempting to turn on CBO also activates a bug for which Oracle has a fix in v10.1 but will not do a backport, and so, until we are ready to go to 10.1, we are stuck with RBO, and bec

Re: RE: CBO, RBO and will v5 ever really go away?

2003-10-20 Thread rgaffuri
generally speaking there are two groups of people using the RBO. 1. The DBAs who have been around for 15 years and doesnt read release notes and doesnt feel the need to read release notes or documentation because he knows everything. He may have tried the CBO in 1995 and had 1-2 bad experiences.