Received: by 10.68.227.230 with SMTP id sd6mr14324361pbc.8.1335198435241;
        Mon, 23 Apr 2012 09:27:15 -0700 (PDT)
Path: r9ni89818pbh.0!nntp.google.com!news2.google.com!postnews.google.com!h20g2000yqd.googlegroups.com!not-for-mail
From: ExecMan <artme...@yahoo.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: 11g Listener Logs
Date: Mon, 23 Apr 2012 09:25:36 -0700 (PDT)
Organization: http://groups.google.com
Lines: 30
Message-ID: <d33c4621-a0ca-4366-b190-3bda193d81ed@h20g2000yqd.googlegroups.com>
References: <06737694-8454-4c4d-aba1-4fe2772d6102@36g2000yqi.googlegroups.com> <d161e2f6-21c2-4797-a52e-14ff3cf66cda@r32g2000yqj.googlegroups.com>
NNTP-Posting-Host: 208.65.116.5
Mime-Version: 1.0
X-Trace: posting.google.com 1335198435 14921 127.0.0.1 (23 Apr 2012 16:27:15 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 23 Apr 2012 16:27:15 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: h20g2000yqd.googlegroups.com; posting-host=208.65.116.5; posting-account=Te8R5QoAAAD0OcZ51Bsj60HqyktlOVZb
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.10)
 Gecko/20100914 Firefox/3.6.10,gzip(gfe)
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Apr 23, 10:26=A0am, ddf <orat...@msn.com> wrote:
> On Apr 23, 7:17=A0am, ExecMan <artme...@yahoo.com> wrote:
>
> > Hi,
>
> > I'm trying to find a good way to parse / audit the 11g listener logs.
> > In our 10g databases this was pretty simple. =A0A couple of procedures
> > and an external table pointing to the log and I can run queries and
> > gather stats by the hour, connect counts from different hosts, etc.
>
> > But, for 11g with the log being in XML and could be a number of logs,
> > I'm not quite sure how to get this accomplished. =A0I've been searching
> > around and trying to brainstorm and was looking to see what anyone
> > else has done. =A0I'm sure I'm not the first who wants to parse the
> > listener log and get stats / counts.
>
> > Thanks!
>
> I'm running 11.2.0.3 and I find a text copy of the listener log in C:
> \oradb\diag\tnslsnr\<host>\listener\trace where c:\oradb is my
> diagnostic_dest. =A0I also find this text log under Linux on 11.2.0.2,
> again starting at <diagnostic_dest> and going to diag/tnslsnr/<host>/
> listener/trace. =A0I would expect that you can point this 10g script to
> the 11g location and continue to use it as you have always done.
>
> David Fitzjarrell

Hmm...I guess I could do that.  I was hoping to use the newer
features, since eventually the old stuff will be scratched.  Maybe
loading it and some type of XML query would work against it?