RE: listener.log analysis

Jesse,

With a lil modification to control file I could load 25mb worth of listener log into a table for analysis.
Till now I use to delete the old listener log every couple of months, but with simplicty of sql*loader, thinking of running a job which would load the listener log into a table thru oem tcl.

Once I was thinking of setting listener log status to off to avoid listener log, but now I could find

1. which host makes the most connections.
2. which programs makes the most connections.
3. which user uses which application when

Thanks
Mandar

> -----Original Message-----
> From: Jesse, Rich [mailto:Rich.Jesse_at_qtiworld.com]
> Sent: Wednesday, April 30, 2003 2:57 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: listener.log analysis
>
>
> Yes, I've seen the OraMag article before. Very cool idea
> (hello, Stephane!), but aside from the potential problems by
> putting "$ORACLE_HOME/network/log" into UTL_FILE_DIR (one of
> my original criteria for not using UTL_FILE for analyzing the
> listener logs), this method and the TechTarget solution
> (another very cool idea!) seem to suffer from some side-effects.
>
> First, with both solutions, isn't each line in the external
> file treated as one big column? This would seem to make it
> more difficult to actually analyze the data. Kind of a GIGO
> issue, I think. Or maybe it's just that I'm more comfortable
> with the row parsing in SQueaL*Loader. :)
>
> Second, both rely on DBMS_OUTPUT.PUT_LINE for viewing. I
> don't know about y'all, but our listener.log file grows to
> about 2.5MB each day (a good reason in itself to analyze
> it!). In my last analysis, I scrubbed over 13MB worth of log
> in about 10 seconds, with the result being data ready for
> analysis. Without the ability to play with this some more,
> wouldn't the SQueaL*Loader option be preferrable?
>
> Not that I'm totally discounting the usefulness of the
> scripts in the two articles. I just think that a
> SQueaL*Loader solution specifically for analyzing the
> listener logs works much better than the other two.
>
>
> Thanks for listening,
> Rich
>
> Rich Jesse System/Database Administrator
> rich.jesse_at_qtiworld.com Quad/Tech International,
> Sussex, WI USA
>
>
> -----Original Message-----
> Sent: Wednesday, April 30, 2003 3:42 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I found it...here's the URL, it's to an Oracle Magazine
> article called "DIY$: Do-It-Yourself Dynamic Views". It
> does use UTL_FILE, but not Java.
>
> http://www.oracle.com/oramag/webcolumns/2001/index.html?diy_dy
> namic.html
>
> Not sure if you need to sign up for archived articles, but
> this is the article I was referring to. It does work; I
> use it regularly.
>
> Cheers,
> Mike
>
>
> -----Original Message-----
> Sent: Wednesday, April 30, 2003 1:12 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I found this in my "to try someday" pile. Not sure if you
> need to register to access the article.
>
> ==================================================================
> ORACLE TIP:Browsing OS files from TOAD or SQL*Plus:
> Visit
> http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci874
425,00.html to find out more.

Looks like the UTL_FILE way?

Jeff

-----Original Message-----
Sent: Wednesday, April 30, 2003 12:47 PM To: Multiple recipients of list ORACLE-L

Yes, but I thought the only non-Java way was UTL_FILE. Let us know if you find the article!

Rich

Rich Jesse                        System/Database Administrator
rich.jesse_at_qtiworld.com           Quad/Tech International, Sussex, WI

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mandar A. Ghosalkar
  INET: mghosalk_at_byer.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).