Database Administration (MOSC)

MOSC Banner

Connection Pool confusion - New Schema = new connection?

edited Sep 8, 2016 12:57AM in Database Administration (MOSC) 5 commentsAnswered ✓

Confusion on Connection Pool in relation to Database Instrumentation from Oracle DBA perspective - somehow I'm thinking they should work together to get full benefit of connection pool

Connection pool is useless unless I'm using same schema over and over again?

If I login with different schema name everytime, a new connection will have to be created for that schema in addition to the idle ones (connection pool keeps a minimum number of connections open)?

However, to make connection pool useful I need to use one schema for the whole application. I would create all users under one schema and manage it all using database instrumentation.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center