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: 25352
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: Wed Apr 26 16:57:02 CDT 2017

Total time taken to generate the page: 0.13477 seconds