Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!news.germany.com!postnews.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!bcklog1.nntp.dca.giganews.com!nntp.comcast.com!news.comcast.com.POSTED!not-for-mail NNTP-Posting-Date: Mon, 26 Jun 2006 14:59:15 -0500 Reply-To: "Mark C. Stock" From: "Mark C. Stock" Newsgroups: comp.databases.oracle.server References: <1151344664.765325.89980@p79g2000cwp.googlegroups.com> <1151348430.785600.230050@m73g2000cwd.googlegroups.com> <1151351576.370032.233790@m73g2000cwd.googlegroups.com> Subject: Re: Auditing the use of db links... Date: Mon, 26 Jun 2006 15:59:13 -0400 Organization: Enquery, Incorporated X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 Message-ID: Lines: 27 NNTP-Posting-Host: 68.57.99.188 X-Trace: sv3-5nHPaJiMhW6OZ3X44W4g86Aut4wwIYF8BKjy/KNVh4fjMSavae+3URLwUXaVEhS7QqmMV/Dv+y8N3QV!K0cKb8bmV1rwYkR6v5Ypn+ug1ULtDfFoIdgkYs7aOrgsiWPn4B2YuJ05KpLltgcvtLffc56NI8fH!irqCYuOcHbv6Xso= X-Complaints-To: abuse@comcast.net X-DMCA-Complaints-To: dmca@comcast.net X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.3.32 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:269919 "Steve Howard" wrote in message news:1151351576.370032.233790@m73g2000cwd.googlegroups.com... : : BD wrote: : > > I don't know that a database link has a *version* per se.... : > : > I think I was unclear - by 'level of usage', I wasn't meaning the : > version of the db that the link points to, I simply want to establish : > whether or not the link is being used. If, every time a connection is : > made via that link, I can write to an audit table, that would work... : : You could AUDIT connect on the remote db. : : Regards, : : Steve : and how would you identify which DB link was used from the remote database? i've posted within the past month that you can determine if a DB link was used for a connection via V$SESSION, but you really won't know which db link (just the initiating host) -- mcs