RE: DB-Link activity

Hi Stephane

Thanks for your input. Since the links belong to specific users I will try to audit them as well.

Thanks again.

-----Original Message-----
From: Stephane Faroult [mailto:sfaroult_at_roughsea.com] Sent: 10. október 2005 10:30
To: Birkir Björnsson
Cc: oracle-l_at_freelists.org
Subject: Re: DB-Link activity

Birkir,

    You can also have a look at DBA_SOURCE and at DBA_SYNONYMS ... If dedicated accounts are used for DB link connections, auditing these accounts can also be helpful.

SF

On Mon, 2005-10-10 at 09:29 +0000, Birkir Björnsson wrote:
> Hi Guys
>
>
>
> I have a customer that just took over an legacy system database
> server. This server has around 90 database links. He wants to know how
> to find which links have been used for the last month or so.
>
> So I´m looking into solutions for him, the only thing I could think of
> is query v$sql and select from sql_text field everything with the @ in
> it. So any better ideas are greatly appreciated.
>
>
>
> Kind Regards
>
> Birkir Bjornsson
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l