OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » DB Link (Oracle 10g , UNIX)

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

DB Link [message #386102]

Thu, 12 February 2009 12:33

dr46014
Messages: 49
Registered: February 2007

Member

Hi All
I am working in a data warehousing environment where we are using Oracle 10g as database.We have some DB links in our database.There are various tools we use for data processing and I am not sure about the code level details of each tool how they connect to database.They may be using DB links.I need to list out those processes.So i need the below details:

1.How to get the DB Link details.Which DB link connects to which database.
2.Is there any way to find out the statistics which DB link was last used on which date and from which UNIX user.

If you have any other suggestions to find out the details please let me know.

Report message to a moderator

Re: DB Link [message #386103 is a reply to message #386102]

Thu, 12 February 2009 12:36

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Look into dba_db_links.
Even there, the HOST column would identify only the tnsentry used.
For the second, you need to employ some extensive auditing.

[Updated on: Thu, 12 February 2009 12:37]

Report message to a moderator

Re: DB Link [message #386104 is a reply to message #386102]

Thu, 12 February 2009 12:42

dr46014
Messages: 49
Registered: February 2007

Member

Can i know in which user in remote database i am connecting to?
For my 2nd questions is there any way to prepare scripts to audit that details only.I need to check which process is being executed using the DB links.

Report message to a moderator

Re: DB Link [message #386106 is a reply to message #386104]

Thu, 12 February 2009 12:47

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>Can i know in which user in remote database i am connecting to?
Yes. Information in dba_db_links.
I do not think there is an option to audit only dblink usage.
You audit for SQL (which would use the dblink) and find the associated database user.

Report message to a moderator

Previous Topic:	ORA-01507: database not mounted (merged)
Next Topic:	Why din I see warning threshold in my alert log

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 04:20:39 CDT 2024