Sorry for the delay in replying; something more urgent popped up.
Nope, the x$uganco doesn't show the db_links opened by other sessions. The
inst_id field looks like it would be useful only in Parallel Server
environments. Any other ideas?
I can't believe Oracle doesn't keep track of open
Sorry, no more ideas.
Allan
-Original Message-
Sent: Wednesday, February 26, 2003 6:19 AM
To: Multiple recipients of list ORACLE-L
Sorry for the delay in replying; something more urgent popped up.
Nope, the x$uganco doesn't show the db_links opened by other sessions.
The inst_id field
I think I spoke too soon.
The v$dblink view shows the db_links opened by the current session only.
I want to be able to find out the db_links opened by all current sessions
and the sids for the sessions. This way I can monitor all the application
instances that opened the db_link and those that
There is an underlying x$table named x$uganco that contains a column
named inst_id which is being filtered in the view_definition for
V$DBLINK as found in V$FIXED_VIEW_DEFINITION. Selecting from the
x$uganco should do the trick. Mind you there are no rows in there when
the links are not active
Charu,
The view V$DBLINK can show you if the link is in use.
select open_cursors, in_transaction
from v$dblonk
where db_link = 'mylink'
HTH.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, February 21, 2003 8:03 AM
Dear
V$dblink
-Original Message-
Sent: Friday, February 21, 2003 7:04 AM
To: Multiple recipients of list ORACLE-L
Dear Listers,
Oracle 8i HP-UX11.
We have a database link with a remote database which is accessed from
the application code. In the application code, a call is made to the
Darn!!
I had taken a hasty look at 'Oracle 8i reference', before posting the query.
Not my day today.
Thanks Allan.
Regards,
Charu
-Original Message-
Allan
Sent: Friday, February 21, 2003 5:04 PM
To: Multiple recipients of list ORACLE-L
V$dblink
-Original Message-
Sent:
