| 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: OT RE: 24 x 7 on NT?
yours dear
>From: Robertson Lee - lerobe <lerobe_at_acxiom.co.uk>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: OT RE: 24 x 7 on NT?
>Date: Thu, 28 Jun 2001 08:36:42 -0800
>
>erm.... who Marks company or mine ???
>
>I haven't received one of those bloody magazines for months despite
>resubscribing.
>
>-----Original Message-----
>Sent: 28 June 2001 16:19
>To: Multiple recipients of list ORACLE-L
>
>
>Lee,
>
>so why didn't they quote you in the article in the latest Oracle magazine?
>
>:)
>
>Rachel
>
>
> >From: Robertson Lee - lerobe <lerobe_at_acxiom.co.uk>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: RE: OT RE: 24 x 7 on NT?
> >Date: Thu, 28 Jun 2001 06:24:43 -0800
>
><snip>
>
>
> >I would imagine once the American economy eventually sorts itself out (I
> >work for an American company by the way), appropriate funds will be
> >released
> >and I will be involved in the purchase of the aforementioned tools.
> >
> >Regards
> >
> >Lee
> >
> >
> >-----Original Message-----
> >Sent: 28 June 2001 12:26
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Rachel,
> >
> >In the session detail screen, it will list all of the SQL currently in
>the
> >SQLAREA for that session, so if you don't catch the blocked session
> >straight
> >away (away from your desk or out to lunch), you can in fact miss the SQL
>as
> >it may have been aged out of the SQLAREA.
> >
> >The way I would use the tool though would be like this:
> >
> >1) Set up the standard rule - ORA_GLOB_BLOCKED_SESSIONS with a threshold
>of
> >1 (Tell me whenever a session is blocked)
> >
> >The Analyzer agent will then monitor the instance on a REFRESH (x
>sec/min)
> >basis for any blocked sessions.
> >
> >2) Set up an Event Handler under the Alerter Agent that fires off an
> >"External" Action (execute a program or a script), that will fire off a
> >script that will select all SQL for that user, and then email the output
>to
> >your email address, showing you the username etc. with all SQL they have
> >executed.
> >
> >This way you are *almost* guaranteed to catch the SQL they are using. I
>say
> >*almost* as there is that .1% chance that somebody has got a stupidly
>small
> >SQLAREA, and a HELL of a lot of SQL going through it.. Not very likely at
> >all, given the time the Alerter agent would take to perform all of this,
> >and
> >I'm sure your instances are set up a HELL of a lot better than that! :)
> >
> >Then there is the possibility of a User Defined Collection - but that's
> >another story that is too long for this list :)
> >
> >HTH
> >
> >Mark
> >
> >
> >-----Original Message-----
> >Carmichael
> >Sent: Wednesday, June 27, 2001 05:14
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Mark,
> >
> >You list ALL the SQL the blocker has or only the SQL that is doing the
> >blocking? I've been looking for a tool that does the latter for a long
> >time
> >and never found one that can identify the statement, if other SQL has
> >happened in the meantime
> >
> >Rachel
> >
> >
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Mark Leith
> > INET: mark_at_cool-tools.co.uk
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >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).
> >
> >
> >The information contained in this communication is
> >confidential, is intended only for the use of the recipient
> >named above, and may be legally privileged. If the reader
> >of this message is not the intended recipient, you are
> >hereby notified that any dissemination, distribution or
> >copying of this communication is strictly prohibited.
> >If you have received this communication in error, please
> >re-send this communication to the sender and delete the
> >original message or any copy of it from your computer
> >system.
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Robertson Lee - lerobe
> > INET: lerobe_at_acxiom.co.uk
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >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).
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
> INET: carmichr_at_hotmail.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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).
>
>
>The information contained in this communication is
>confidential, is intended only for the use of the recipient
>named above, and may be legally privileged. If the reader
>of this message is not the intended recipient, you are
>hereby notified that any dissemination, distribution or
>copying of this communication is strictly prohibited.
>If you have received this communication in error, please
>re-send this communication to the sender and delete the
>original message or any copy of it from your computer
>system.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Robertson Lee - lerobe
> INET: lerobe_at_acxiom.co.uk
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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.com -- Author: Rachel Carmichael INET: carmichr_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).Received on Thu Jun 28 2001 - 11:01:29 CDT
 |
 |