Home » RDBMS Server » Server Administration » database link usage (10.2.0.3)
database link usage [message #517550] Tue, 26 July 2011 10:05 Go to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Hi,
I am having database A and database B and I am inserting into database b by selecting some records from database a using db link.Is there any way to find whther database link is being used?
Re: database link usage [message #517552 is a reply to message #517550] Tue, 26 July 2011 10:10 Go to previous messageGo to next message
BlackSwan
Messages: 22558
Registered: January 2009
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

SELECT MACHINE FROM V$SESSION;
Re: database link usage [message #517553 is a reply to message #517552] Tue, 26 July 2011 10:16 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
actually both the databases are present in same machine...
Re: database link usage [message #517558 is a reply to message #517553] Tue, 26 July 2011 10:51 Go to previous messageGo to next message
BlackSwan
Messages: 22558
Registered: January 2009
Senior Member
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_1147.htm#g1427852

>DX Distributed transaction entry
Re: database link usage [message #517559 is a reply to message #517550] Tue, 26 July 2011 10:53 Go to previous messageGo to next message
Michel Cadot
Messages: 58643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is there any way to find whther database link is being used?


SQL> desc v$dblink
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 DB_LINK                                   VARCHAR2(128)
 OWNER_ID                                  NUMBER
 LOGGED_ON                                 VARCHAR2(3 CHAR)
 HETEROGENEOUS                             VARCHAR2(3 CHAR)
 PROTOCOL                                  VARCHAR2(6 CHAR)
 OPEN_CURSORS                              NUMBER
 IN_TRANSACTION                            VARCHAR2(3 CHAR)
 UPDATE_SENT                               VARCHAR2(3 CHAR)
 COMMIT_POINT_STRENGTH                     NUMBER


See LOGGED_ON column.

Regards
Michel
Re: database link usage [message #517565 is a reply to message #517559] Tue, 26 July 2011 11:35 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
I checked V$dblink but it doesnot show any entry if you check from some other session.It only shows some entry when you run it in the current session in which you have used the dblink
Re: database link usage [message #517574 is a reply to message #517565] Tue, 26 July 2011 11:59 Go to previous message
Michel Cadot
Messages: 58643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Correct, the information comes from the UGA of the session.
I'm afraid you can't get it.

Regards
Michel
Previous Topic: how to reclaim temp free blocks ?
Next Topic: Unable to calculate "Datafile Shrink possible" size
Goto Forum:
  


Current Time: Fri Aug 01 22:56:44 CDT 2014

Total time taken to generate the page: 0.10085 seconds