Re: 11g Listener Logs

From: joel garry <>
Date: Mon, 23 Apr 2012 08:55:27 -0700 (PDT)
Message-ID: <>

On Apr 23, 6:17 am, ExecMan <> 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.  A 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.  I've been searching
> around and trying to brainstorm and was looking to see what anyone
> else has done.  I'm sure I'm not the first who wants to parse the
> listener log and get stats / counts.
> Thanks!

Some people have done some similar things with the alert log:

I'm lazy, I'd go along with the old scripts unless I saw something really kewl someone had already figured out. I can see the reasons for adcri - all sorts of versions and platforms coming in to Oracle support, uniform and stratifiable error logging - but I'm hard to convince that they are better at any site than the simple olde ways of text files and a nice parsing language.


-- is bogus.
Received on Mon Apr 23 2012 - 10:55:27 CDT

Original text of this message