OBIEE Connection Pool

Question

Hi All,

Oracle Business Intelligence 12.2.1.4.0

We increased number of OBIEE users. With that, we are reevaluating the number of connections specified in the connection Pool. I have seen the magic formula of number of connections in oracle support and various blogs I don't want to increase the connections if its not required.

1) I checked obis1-diagnostic.log and didn't find any entry related to server connections to back end data sources. How can I monitor the usage of OBI connection Pool.

Please let me know if I need to check in a different log file to determine if the number of available connection is exceeded.

2) Also I looked into the Perfmon URL. Under Oracle BI PS Thread Pools section, I can see Peak Jobs Queued=20 for Query instance &

Peak Jobs Queued=150 for ChartThreadPool instance. Not sure if it will cause performace issue for users.

Please let me know the conifg files parameters need to be changed to avoid queue ?

Thanks

Ebin

[Deleted User] · Answer

You can't identify a bottleneck or anything if you don't have sound usage statistics. I.e. Usage Tracking. That combined with stats from the DB which you collect together with your DBAs are the only valid starting points for such analyses.

What you're after is the end result of a data collected over a long period of time. You can't get thi from a spot-check.

Ebin Cherian · Answer

Sorry, I missed to mention the oracle doc ID. I was referring to Doc ID 795846.1.

a) Why not?

b) What do you mean "if it's not required"?

Let say if my total number of connection is 100. Even after an increase OBI user count, if 100 connections are not utilized completely at same time, I don't see a point to increase the number of connections. I am not looking for a precise number of connection pool as an answer to question posted here. I know its impossible as other members here don't have any idea on number of reports in dashboard, usage of dashboard etc.

That's why I posted it as more of help to guide me in correct path on where to look to identify connection bottlenecks. Is there any particular log file which list or any other place to monitor this?

[Deleted User] · Answer

Ebin Cherian wrote:
I have seen the magic formula of number of connections in oracle support and various blogs

Which magic formula? If you reference it, post it so people aren't sitting here starting a guessing game.

Ebin Cherian wrote:I don't want to increase the connections if its not required.

a) Why not?

b) What do you mean "if it's not required"?

You're stating zero quantified or quantifiable facts. You're not stating how many users so far and how many after. You're not stating what connection pool settings you have at the moment. You're not stating how usage is at the moment. And no, that "Perfmon URL" isn't a response to all those unanswered questions.

Nobody can tell you what would be a good approach based on literally nothing.