10g oem does all this shee for me now.. I liked doing the coding for all that but I don't get to do it anymore here. The coding here would be I would grep my saved file and see when the number of lines hits my threshold then page... And then when the consecutive lines is interrupted I would send the clear page... That kind of idea anyways.. I love to code that stuff but in this shop we have lots of tools to do that now. Brian -----Original Message----- From: Post, Ethan [mailto:Ethan.Post@xxxxxx] Sent: Monday, November 14, 2005 3:40 PM To: Spears, Brian; stellr@xxxxxxxxxx Cc: oracle-l Subject: RE: A Challenge OK, but now I am sitting in a movie theater and my phone is paging me every time it runs to tell me there is a problem, on my way out the door I fail to get the page that tells me everything is OK now. Also I am getting a page because the threshold was exceed for a couple minutes as opposed to...I know something is likely wrong because the threshold has been over N for an hour. -----Original Message----- From: Spears, Brian [mailto:BSpears@xxxxxxxxxxxxxxxxx] Sent: Monday, November 14, 2005 2:32 PM To: stellr@xxxxxxxxxx; Post, Ethan Cc: oracle-l Subject: RE: A Challenge Yes, this is what I did 4 or so years ago. Just save and grep on top (in a 5 second loop) for thresholds and page. Grep the saved files for history of problem... Very basic. The unix guys now save all the stats for us and can produce reports for any type of performance issue. Brian -- //www.freelists.org/webpage/oracle-l