OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » database link usage (10.2.0.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

database link usage [message #517550]

Tue, 26 July 2011 10:05

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?

Report message to a moderator

Re: database link usage [message #517552 is a reply to message #517550]

Tue, 26 July 2011 10:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

SELECT MACHINE FROM V$SESSION;

Report message to a moderator

Re: database link usage [message #517553 is a reply to message #517552]

Tue, 26 July 2011 10:16

sekar52
Messages: 141
Registered: May 2010
Location: Mumbai

Senior Member

actually both the databases are present in same machine...

Report message to a moderator

Re: database link usage [message #517558 is a reply to message #517553]

Tue, 26 July 2011 10:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_1147.htm#g1427852

>DX Distributed transaction entry

Report message to a moderator

Re: database link usage [message #517559 is a reply to message #517550]

Tue, 26 July 2011 10:53

Michel Cadot
Messages: 68647
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

Report message to a moderator

Re: database link usage [message #517565 is a reply to message #517559]

Tue, 26 July 2011 11:35

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

Report message to a moderator

Re: database link usage [message #517574 is a reply to message #517565]

Tue, 26 July 2011 11:59

Michel Cadot
Messages: 68647
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 27 10:31:27 CDT 2024