Suggest running some benchmark jobs beforehand and compare after. I did that with SAS version 8 vs 9 to Oracle, and 9 was unacceptably slow extracting data.

Michelle Z. Carol Bristow wrote: > Actually, the rules-based optimizer came first, and CBO came later. > > Carol Bristow > 1655 N Fort Myer Dr Ste 925 > Arlington, VA 22209 > ph: 703.682.2612 > fax: 703.528.3100 > > -----Original Message----- > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of > Gerry > Sent: Tuesday, December 05, 2006 12:55 PM > To: SAS-L@LISTSERV.UGA.EDU > Subject: Re: Question about SAS Version 9 and Oracle 10g R2 > > Yusuf: > > 1. There are no know issues with SAS itself, we just went production > (Windows AS2003, Oracle 10G RAC, 4 node cluster) > > 2. Works fine. > > 3. Other than SP4 for SAS 9.1.3, none that I'm aware of. > > 4. YES: Oracle 10G uses rules based optimization, previous versions of > Oracle used cost based optimization -- this is a major change. RBO can > cause > previously OK running queries to run dog slow. You may need to look into > Oracle Hints to help remedy this if you run into this situation (it bit > us > hard !). > > Hope this helps. > > -Gerry > > Gerard T. Pauline > Mgr, Internet Applications & > University Web Master > Computer Systems, DoIT > Pace University > > -----Original Message----- > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of > Mohamedshah, Yusuf > Sent: Tuesday, December 05, 2006 12:37 PM > To: SAS-L@LISTSERV.UGA.EDU > Subject: Question about SAS Version 9 and Oracle 10g R2 > > Dear Sas-ler's > > I am about to install Oracle 10g R2 on a Microsoft server 2003 R2 > Standard Edition. And I am going to use SAS version 9 from my PC to > connect to Oracle 10g R2. I have following questions: > > 1. Does anyone know if there are any issues with this setup. > 2. Is SAS Version 9 compatible with Oracle 10g R2? > 3. Do I need to download any SAS patches to work with Oracle 10g R2. > Currently I am using SAS version 9 on Windows XP Professional 2002 with > Oracle 9i on a SUN Unix box. > 4. Are there any other issues I should be aware of before installing > Oracle 10g R2 on Microsoft Server 2003 R2? > > Any help would be appreciated. > > Thanks > > Yusuf Mohamedshah > Manager, HSIS Lab > Lendis Corporation > Federal Highway Administration > McLean, VA 22101 > Phone: (202) 493 3464 > Fax: (202) 493 3374 > > email: yusuf.mohamedshah@fhwa.dot.gov > Web page: www.hsisinfo.org