Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BI PS and BI Server Sessions

Received Response
11
Views
1
Comments
Nila
Nila Rank 3 - Community Apprentice
edited Aug 13, 2024 7:00PM in Oracle Analytics Forum

Hi Guys,

We having some issue with BI Server performance. This is due to BI Server is re-initiating new sessions when BI PS Session is idle for more than 3 mins.

So there are duplicate session created on BI Server side and when these get created it fires INIT blocks which stress our source DB.

If you check the no of sessions in PS is very low (< 10) but BI Server sessions are high (> 30).

How can we reduce this? Is there a setting that we can increase so BI Server dose not create new session corresponding to BI PS session or increase the no of BI PS -> BI Server connections?

Appreciate your help!

Neal.

Answers