Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
BI Publisher in OBIEE suite -- Connection pool
Hi Gurus
i have couple question when we install BI Publisher along with OBIEE 11g,
question 1 : OBIEE analysis and Dashboards use RPD connection pool but what connection pool does BIP use when we create new JDBC datasource in BI Administrator?
question 2: in RPD Connection pool we enter the maximum connections, timeout and other details, so when we create a JDBC data sources for BIP reports how are the maximum connections, timeout and runaway sessions handled?
jesi
Answers
-
answer 1: no connection pool .... If you create a connection in the Publisher admin page it doesn't use any connection pool but connect by JDBC based on the provided info
answer 2: look at answer 1, there is no connection at all between Publisher JDBC sources and RPD connection pools.
0 -
so there is no place in BIP to handle maximum connections, runaway sessions and timeouts?
0 -
Not sure publisher has the same logic as a connection pool (sharing the connection between the various users), so wouldn't be surprised if Publisher open a new connection every time it needs one and close it when the data are retrieved.
And there are some server settings so there probably are some settings that can be set for that.
0
