Home » RDBMS Server » Server Administration » How to monitor the login through a database link (Oracle 10g,Windows XP)
How to monitor the login through a database link [message #336980] Tue, 29 July 2008 09:36 Go to next message
kmsalih
Messages: 198
Registered: March 2006
Senior Member
Hi Everybody,

I am now auditing my database logins.

I have to impliment the following scenario in my database.

Two Databases A & B.

In B there is a database link that points to a schema in A.

I want to monitor the select statements issued from Database B against Database A.

Please let me know is it possible or not?

Thanks & Regards
Salih KM
Re: How to monitor the login through a database link [message #336981 is a reply to message #336980] Tue, 29 July 2008 09:45 Go to previous messageGo to next message
BlackSwan
Messages: 25578
Registered: January 2009
Location: SoCal
Senior Member
>Please let me know is it possible or not?
Yes, it is possible, but with a SUBSTANTIAL performance penalty by enabling AUDIT.
Re: How to monitor the login through a database link [message #336985 is a reply to message #336981] Tue, 29 July 2008 09:55 Go to previous messageGo to next message
kmsalih
Messages: 198
Registered: March 2006
Senior Member
thanks anacedent

I will try on this and will reply once it is done.

Regards
Salih KM
Re: How to monitor the login through a database link [message #338010 is a reply to message #336980] Sat, 02 August 2008 04:37 Go to previous message
malikjee
Messages: 80
Registered: May 2007
Location: lahore
Member


Yea its possible but use caution with monitoring because

it slows too much the OS if your platformis not much fast to support the feature.
Regars
Malik
Previous Topic: Load of data from PROD into TEST for testing
Next Topic: ORA-12514
Goto Forum:
  


Current Time: Tue Aug 22 21:37:14 CDT 2017

Total time taken to generate the page: 0.01653 seconds