What is connection pool and how many connection pools did you have in your last project?






What is connection pool and how many connection pools did you have in your last project?..

Answer / madhu

Connection pool is needed for every physical database.
It contains information about the connection to the database, not the database itself.
Can use either shared user accounts or can use pass-through accounts 
We can have multiple connection pools for each group to avoid waiting

Is This Answer Correct ?    1 Yes 0 No

Post New Answer




More OBIEE Interview Questions

If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?

1 Answers  


What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?

1 Answers  


We have 4 dimension tables, in that 2 tables need to have hierarchies then in such a case is it mandatory to create hierarchies for all the dimension tables?

1 Answers  


What is the difference between Data Level Security and Object Level Security?

1 Answers  


What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?

1 Answers  






How do implement event polling table?

1 Answers  


Why do we have multiple LTS in BMM layer? What is the purpose?

1 Answers  


How do i disable cache for only 2 particular tables?

1 Answers  


What are different types of variables? 

1 Answers  


Can you have multiple data sources in OBIEE?

1 Answers  


You worked on standalone or integrated system?

1 Answers  


How do you define the relationship between facts and dimensions in BMM layer?

1 Answers  






Categories