| 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?
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).
-- 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 - 09:40:28 CDT
 |
 |