OraFAQ Forum: Server Administration » How to monitor the login through a database link

Home » RDBMS Server » Server Administration » How to monitor the login through a database link (Oracle 10g,Windows XP)

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

How to monitor the login through a database link [message #336980]

Tue, 29 July 2008 09:36

kmsalih
Messages: 197
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

Report message to a moderator

Re: How to monitor the login through a database link [message #336981 is a reply to message #336980]

Tue, 29 July 2008 09:45

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: How to monitor the login through a database link [message #336985 is a reply to message #336981]

Tue, 29 July 2008 09:55

kmsalih
Messages: 197
Registered: March 2006

Senior Member

thanks anacedent

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

Regards
Salih KM

Report message to a moderator

Re: How to monitor the login through a database link [message #338010 is a reply to message #336980]

Sat, 02 August 2008 04:37

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

Report message to a moderator

Previous Topic:	ORA-0600
Next Topic:	How many total releases in oracle 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 09 19:21:40 CDT 2024