Search

OakieTags

Who's online

There are currently 0 users and 28 guests online.

Recent comments

Affiliations

Mining listener logs

When is the last time you looked at the listener logs? Perhaps never. Not a very good idea. Listener logs contain a wealth of information on security events - it shows you the profile of hosts connecting to the database, the programs they are using and attempting to communicate but failed, among other things. But reading the listener logs is not exactly a pleasant experience. A while ago I wrote a series of articles on an online eZine called DBAZine.com on how to create an external table to read the listener logs using simple SQL; but unfortunately DBAZine.com has folded.
I have placed the articles here as well as on my website for your reference. As always, I would love to hear from you how you felt about these, stories of your own use and everything in between.

AttachmentSize
MiningListenerLogPart1.pdf117.6 KB
MiningListenerLogPart2.pdf145.29 KB
MiningListenerLogPart3.pdf121.86 KB