Why Does Discoverer Create Two Dedicated Connections?
A couple of people recently asked the question on the OTN Discoverer Forum:
"I am new to Discoverer tool as such. Therefore I have this question, pl pardon me if it very basic.
When I use the desktop edition of Discoverer to make a connection to the Oracle db. One the database side, it creates 2 dedicated connection for that Discoverer session. Is this normal, so something is not right in my environment configuration."
and
"I've recently started using Discoverer and I too have noticed this 'feature'.
I have a vanilla Discoverer 4.1 Client Installation on NT, without tweaking any of the defaults. I'm sure our DBA's would like to know why there are 2 sessions - and if this can be configured (i.e. reduced)."
The reason you have
two dedicated connections is because Discoverer makes two connections to the
database - one to the End User Layer tables, and one to the source database
tables themselves.
This is mentioned in metalink note
62315.1 "SQL*Net Tracing Requirements for Discoverer".