Date: Thu, 9 Nov 2006 14:53:17 -0500
Reply-To: Gerry <gpauline@PACE.EDU>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Gerry <gpauline@PACE.EDU>
Organization: Pace University
Subject: Re: SAS 9.1.3, Oracle 10G And Oracle RAC
In-Reply-To: <200611090952.kA96RSUj014686@mailgw.cc.uga.edu>
Content-type: text/plain; charset=us-ascii
Ben:
Speaking to SAS tech support, they basically said the same thing, as there
are no known issues between SAS and Oracle 10g.
They are such common companion products that if there was a problem between
the two, it would likely be documented somewhere, especially considering
that SAS v9.1.3 and Oracle 10g have been out for a while.
As you note below, SAS TS suggested running an app with the diagnostics
(SASTRACE, FULLSTIMER) on and sending them the SASLOG. I'll try this later
today.
We quelled a good number of the SAS jobs yesterday, along with ad hoc stuff
(SAS), and there are still issues. Other users are also reporting problems,
ie: MS-ACCESS connections, etc , not just SAS (SAS is the largest group).
Oracle RAC is failing on both memory and CPU. This is a 4 node cluster,
Windows 2003 AS, each node has 6 or 8 gigabytes of memory, I don't remember
exactly (more memory is being added) running on Dell 6800 class machines, so
there is plenty of horsepower. According to server support, the machines
aren't overtaxed.
Thank you for your note, and I apologize for not responding sooner.
-Gerry
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
ben.powell@CLA.CO.UK
Sent: Thursday, November 09, 2006 4:52 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: SAS 9.1.3, Oracle 10G And Oracle RAC
Bringing this thread to the top:
The SAS program code is unlikely to be a cause but it could be:-
a) the method used for SAS to connect to 10g, or
b) the installation of 10g itself
Of the two I would say the former is more simple to check and rule out (on
this list)...
How is the Oracle RAC failing? Memory / CPU / i/o ?
Rgds.
On Wed, 8 Nov 2006 13:33:43 -0500, Gerry <gpauline@PACE.EDU> wrote:
>SASperts:
>
>
>
>Does anyone know of any new considerations that have to be made when
running
>SAS and Oracle 10g ? The environment having an issue is a 4 node, Oracle
10g
>RAC setup on Windows 2003 servers. Our SAS users are coding both LIBNAME
and
>SQL PASSTHRU. SAS environment is v9.1.3, Windows XP and advanced server,
>running from both SAS/Base and SAS/Enterprise Guide 3 & 4.1.
>
>
>
>The Oracle system is having some serious issues, and since the majority of
>connections to the database are by SAS, the question has been raised if
>perhaps the issues were SAS related. These "issues" have occurred in two
>phases, previous to two days ago, there were complaints by SAS users of
jobs
>that ran satisfactorily on Oracle 9i were performing horribly under 10g.
>
>
>
>Then 2 days ago, everything started to be affected, the transactional (SCT
>Banner ERP suite) system users, even doing PL/SQL compiles. We are aware
>that internally, Oracle 10g does cost based optimizations vs 9i's rules
>based optimizations, nothing specifically that should be done on the SAS
>side.
>
>
>
>At this point, we are not sure where the problem is, SAS or Oracle, which
is
>why we are reaching out to your collective expertise to see if there are
any
>specific 10g considerations to make, SAS system opts or in coding (in
>testing, no problems were encountered before going production on 10g) or
>problems that you may have heard about.
>
>
>
>We will also be contacting SAS tech support, but knowing the diversity of
>experience and expertise, thought SAS-L might be the better bet to start
>with :-) ! All help/suggestions/ideas will be much appreciated.
>
>
>
>Thank you.
>
>
>
>-Gerry
>
>
>
>Gerard T. Pauline
>
>Mgr, Internet Applications &
>
>University Web Master
>
>Computer Systems, DoIT
>
>Pace University
| 
