| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_dynamic.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.
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 USA
-- 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 servicesReceived on Wed Apr 30 2003 - 16:56:39 CDT
---------------------------------------------------------------------
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).
 |
 |