Replace Connection Pool with authenticated Database access Descriptor
Harry83Jun 21 2011 — edited Jun 22 2011APEX by default is a light weight application that uses connection pool (APEX_PUB_USER) by default.
In order to use existing Visual Private database, we need to get authenticated session_user in APEX (that will be APEX_PUB_USER by default). One developer suggests to create a new authenticated DAD(database access descriptor) to replace default connection pool that is coming with APEX as default.
Could anyone tell me whether this is a right approach? Will this cause any performance issues when APEX is turned to a heavy weight application?