Re: 11g Listener Logs
From: joel garry <joel-garry_at_home.com>
Date: Mon, 23 Apr 2012 08:55:27 -0700 (PDT)
Message-ID: <ad3e26c2-3e78-4b6b-9f39-961de3f5a212_at_pt7g2000pbc.googlegroups.com>
On Apr 23, 6:17 am, ExecMan <artme..._at_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. 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!
Date: Mon, 23 Apr 2012 08:55:27 -0700 (PDT)
Message-ID: <ad3e26c2-3e78-4b6b-9f39-961de3f5a212_at_pt7g2000pbc.googlegroups.com>
On Apr 23, 6:17 am, ExecMan <artme..._at_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. 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: http://laurentschneider.com/wordpress/2008/04/alert-log-in-xml-format.html
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.
jg
-- _at_home.com is bogus. http://www.infoworld.com/t/intellectual-property/oracle-java-patent-upheld-191484Received on Mon Apr 23 2012 - 10:55:27 CDT