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: 25046
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: ORA-0600
Next Topic: How many total releases in oracle 10g
Goto Forum:
  


Current Time: Fri Dec 09 04:04:11 CST 2016

Total time taken to generate the page: 0.16778 seconds