Business Objects Connection Pooling RAC input needed

From: <Christopher.Taylor2_at_parallon.net>
Date: Wed, 5 Sep 2012 17:22:46 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E885156462A2_at_NADCWPMSGCMS10.hca.corpad.net>

Disclaimer:
(I know nothing about Business Objects servers so I'm looking for BO knowledge transfer here)
Env:
Oracle 10.2.0.4
3 Linux-x64 Nodes 64GB RAM, 8 cores

We have BO servers (4?) that run reports against our Oracle database using the RAC database name.

It appears that the BO servers use some type of connection pooling. I found a flag called -MaxConnections that can be set on the BO server side, however I'm doubtful that it is actually set.

When a publication kicks off, it runs 11 reports, and they run something like 9-10 publications I believe for month end. For 1 publication (or maybe its 2) we see 20 Oracle database connections (dedicated connections) startup from the BO servers.

All 20 db connections (for 1 or 2 publications) connect to 1 node (instead of dividing the 20 connections among all 3 nodes).

When these 20 db connections fire up, the CPUs (8 cores) become 100% busy - (SQL tuning opportunity here so ignore the tuning aspect for the moment)

So I'm wondering:

a.)     Anyone have experience with BO connection pooling - ASSUMING that it does exist as I imagine it does?
b.)     Anyone have experience with BO connections going to 1 node in a RAC environment?
c.)     Anyone have any tips on BO performance (either database or BO server side) related to Oracle?  (I'm already thinking about resource profiles as the CPUs get pegged on each node to allow business processing to continue unhindered

(Basically, I'm developing a divide and conquer strategy where the reports still have to run and business has to continue processing while we sort out the SQL tuning bits and work on those)

Regards,
Chris Taylor

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 05 2012 - 17:22:46 CDT