Home » RDBMS Server » Server Administration » DB Link (Oracle 10g , UNIX)
DB Link [message #386102] Thu, 12 February 2009 12:33 Go to next message
dr46014
Messages: 48
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.
Re: DB Link [message #386103 is a reply to message #386102] Thu, 12 February 2009 12:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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 Go to previous messageGo to next message
dr46014
Messages: 48
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.
Re: DB Link [message #386106 is a reply to message #386104] Thu, 12 February 2009 12:47 Go to previous message
Mahesh Rajendran
Messages: 10672
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.

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


Current Time: Mon Dec 05 15:19:46 CST 2016

Total time taken to generate the page: 0.04794 seconds