tag:blogger.com,1999:blog-4096575.post7661136448030238212..comments2024-03-19T03:20:26.726-04:00Comments on The Arup Nanda Blog: Mining Listener LogsArup Nandahttp://www.blogger.com/profile/03392706779349258765noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-4096575.post-30973203068514256372012-12-04T23:22:01.877-05:002012-12-04T23:22:01.877-05:00@Jon Thanks for the compliments. I am glad you cou...@Jon Thanks for the compliments. I am glad you could use it.Arup Nandahttps://www.blogger.com/profile/03392706779349258765noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-91235055993261753042012-12-04T19:22:54.561-05:002012-12-04T19:22:54.561-05:00Very handy stuff - I am doing a DB upgrade/migrati...Very handy stuff - I am doing a DB upgrade/migration, and this will help me clean up my firewall rules - if they haven't connected in a year, they are off the list!Jon Finkenoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-86173423979391533972012-06-05T03:10:36.984-04:002012-06-05T03:10:36.984-04:00I came after a long time,i glad to read such post ...I came after a long time,i glad to read such post you did a great work its impressing thanks i will keep visiting.Nicholashttp://www.diskdoctors.com/massachusetts-lab.asp/noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-40343395196304254482011-11-18T23:14:36.533-05:002011-11-18T23:14:36.533-05:00Great stuff! Thanks! I used this to track down w...Great stuff! Thanks! I used this to track down why I suddenly got a max_processes exceeded. Used your tools to grab 15 minute increments before and after when the problem occured & found my culprit. <br /><br />so, basicaly, a series of these:<br /><br />col action for a10<br />col connect_string for a50<br />col service_name for a20<br />set lines 100<br />set pages 50<br />col cnt for 99,999<br />col pgm for a75<br /><br />spool 1045to1100lis.log<br /><br />select distinct parse_listener_log_line(connect_string, 'PROGRAM') pgm, count(*) cnt<br /> from listener_log<br /> where log_date > to_date('2011-11-18 10:45', 'YYYY-MM-DD HH:MI')<br /> and log_date < to_date('2011-11-18 11:00', 'YYYY-MM-DD HH:MI')<br /> group by parse_listener_log_line(connect_string, 'PROGRAM')<br /> order by cnt;<br /><br /><br />spool off<br /><br />Thank you very much!<br /><br />-Lisalisawarehttps://www.blogger.com/profile/04525752380977189029noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-8120042664750591352010-07-17T16:53:33.092-04:002010-07-17T16:53:33.092-04:00Thanks for answering my question..
How do you mak...Thanks for answering my question..<br /><br />How do you make use of this mining to detect connect heavy applications or periods (log on storms)? <br /><br />I've read on one Oracle COE case study that the "Listener records the number of connect requests it can processes per second, not the number of connect requests it gets per second."<br /><br />It also mentioned the following.. <br />"the Listener will fork and execute a new process and then look into the protocol stack and pick up all the connect requests that are there. It only logs the connection request at some point during the processing of that request (it does not have the information it puts in the log yet), so it does not log every connection request as it pulls it from the protocol stack."<br /><br />Here's the document.. <br />Case Study Master [ID 342534.1] Configuration Solutions for a High Load EnvironmentAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-80834360002868311682010-05-21T05:29:07.018-04:002010-05-21T05:29:07.018-04:00Great job Arup, in the last month i'm very bus...Great job Arup, in the last month i'm very busy on a trouble DB-client connection, your advise are always amazing. <br />bye <br />AlbertoAlbertohttps://www.blogger.com/profile/01805632595255042258noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-51801644608148442842010-05-20T10:07:00.452-04:002010-05-20T10:07:00.452-04:00@karlarao: Not directly; but you can devise a way ...@karlarao: Not directly; but you can devise a way to connect the time from the app server to the time in the listener. It's tricky since the time could be different on both. It should be a little easier with some sort of NTP program.Arup Nandahttps://www.blogger.com/profile/03392706779349258765noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-53533987550599316412010-05-19T22:04:12.679-04:002010-05-19T22:04:12.679-04:00Good Stuff :) but I also wonder how you could make...Good Stuff :) but I also wonder how you could make use of the listener logs to diagnose a network performance issue..Anonymousnoreply@blogger.com