Re: managing open database links?

On Tue, 18 Apr 2006 15:20:04 -0400, "Mark C. Stock" <mcstockX_at_Xenquery .com> wrote:

><flame retardant>
>i'm in the process of researching this but have not found anything yet, so
>any pointers would be helpful
>this is immediately applicable to R9.2
></flame retardant>
>
>is there any way to detect all outgoing open database links (not just those
>established by the current session)?
>
>is there any way to detect all incoming open database links?
>
>is there any direct or indirect way to close \outgoing or incoming database
>links other than the outgoing links established by the current session?

We modified our application to do
select '<some_database_identifier>' from dual on initial connection
to make our lives easier with identifying where really SQL is running from

.......
We run Oracle 9.2.0.6 on RH4 AMD
we are currently looking for a DBA
remove NSPAM to email Received on Tue Apr 18 2006 - 15:33:57 CDT