From oracle-l-bounce@freelists.org Mon Oct 10 04:36:48 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9A9amfQ026852 for ; Mon, 10 Oct 2005 04:36:48 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9A9acvX026821 for ; Mon, 10 Oct 2005 04:36:38 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 851E81F9CD9; Mon, 10 Oct 2005 04:36:35 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 21103-05; Mon, 10 Oct 2005 04:36:35 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 002B41F9E16; Mon, 10 Oct 2005 04:36:34 -0500 (EST) Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5CD7D.18989AAC" Subject: DB-Link activity X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830 Date: Mon, 10 Oct 2005 09:29:21 -0000 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: DB-Link activity thread-index: AcXNfdamWr/EerSGS8Oi0SVTT6WsRg== From: =?iso-8859-1?Q?Birkir_Bj=F6rnsson?= To: X-archive-position: 26615 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: birkir@miracle.is Precedence: normal Reply-To: birkir@miracle.is X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.7 required=5.0 tests=BAYES_00,HTML_60_70, HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5CD7D.18989AAC Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Guys =20 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.=20 So I=B4m 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. =20 Kind Regards=20 Birkir Bjornsson =20 ------_=_NextPart_001_01C5CD7D.18989AAC Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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=B4m 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

------_=_NextPart_001_01C5CD7D.18989AAC-- -- http://www.freelists.org/webpage/oracle-l