Re: 11g Listener Logs
From: Mladen Gogala <gogala.REMOVETHISmladen_at_google.com>
Date: Mon, 23 Apr 2012 18:50:46 +0000 (UTC)
Message-ID: <jn48a6$ppc$9_at_solani.org>
On Mon, 23 Apr 2012 10:27:27 -0700, AM wrote:
Date: Mon, 23 Apr 2012 18:50:46 +0000 (UTC)
Message-ID: <jn48a6$ppc$9_at_solani.org>
On Mon, 23 Apr 2012 10:27:27 -0700, AM wrote:
> Short of writing some AWK script to go through the log every hour and
> parse / count occurrences, then pass that to the database to store in a
> table, I was hoping to do it from within the database. In 10g I just
> created an external table and a procedure to parse the log. That is
> working great. But it does not work with the log.xml, so I am looking
> for another solution.
Well, in 11G there is a ready-made external table for you and a utility to purge it.
-- http://mgogala.freehostia.comReceived on Mon Apr 23 2012 - 13:50:46 CDT