11g Listener Logs

From: ExecMan <artmerar_at_yahoo.com>
Date: Mon, 23 Apr 2012 06:17:57 -0700 (PDT)
Message-ID: <06737694-8454-4c4d-aba1-4fe2772d6102_at_36g2000yqi.googlegroups.com>


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! Received on Mon Apr 23 2012 - 08:17:57 CDT

Original text of this message