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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the architecture of obiee and what each components do?

479


What are the different types of variables in obiee? Explain

506


What is a bridge table ?

473


How we are going to decide which schema we are going to implement in the data warehouse?

473


How will change port of obiee answers?

506






How analytics process your request when you create your requests?

452


What is time series wizard? When and how do you use it?

1244


How will you do different types of narrative reports in obiee?

530


How many bi services node can be clustered together?

491


How will effect the changes for a report , if for certain users only the column heading in the report should be changed?

455


What are the different log files in obiee?

517


How to hide certain columns from a user?

498


What is a table alias in obiee 11g? Where and how will you create it?

497


From where u get the logical query of your request?

459


What is scd type 1 and 2.

499