DB-Link activity

From: Birkir Björnsson <birkir_at_miracle.is>
Date: Mon, 10 Oct 2005 09:29:21 -0000
Message-ID: <C580E77635830944882B58581F4183044420B3@gandalf.miracle.is>

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

Received on Mon Oct 10 2005 - 04:36:48 CDT