"Rachel Carmichael" <[EMAIL PROTECTED]> on 07/31/2001 11:48:02 AM
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: (bcc: Chaim Katz/Completions/Bombardier)
Rachel,
I don't know how to retreive the locking sql either, but reading this discussion
it occurred to me that 1) in v$session (of the blocked session) we have the
file#,block#,row# that is being waited on. Maybe with logminer (or something
like it) we could find the most recent SQL that affected this block/row?
Chaim
Gary,
I wish it did. I worked with Q Diagnostics for quite a while, and worked
directly with the developer (although calling John Beresniewicz a developer
is an understatement, he's brilliant!) on answering that problem.
Neither Q nor anything from Platinum (does that tell you how long ago it
was?) was able to find the locking sql with any precision. The answer I got
back from both of them was "if you figure out how to do it, PLEASE let us
know"
Having said that, Q Diagnostics was indeed bliss... I fixed locks before
users complained, was able to model and monitor bad SQL and fix it and had
lots of good info directly on the desktop.
Rachel
>From: "Gary Weber" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Evaluation questions
>Date: Tue, 31 Jul 2001 06:11:36 -0800
>
>Rachel,
>
>I believe your second wish from below (locking SQL) has been granted by
>former Savant product called Q Diagnostic Center, currently owned by
>Precise. Drill down to locks, including user and SQL info - its a bliss.
>
>Gary Weber
>Senior DBA
>Charles Jones, LLC
>609-530-1144, ext 5529
>
>-----Original Message-----
>Carmichael
>Sent: Tuesday, July 31, 2001 8:56 AM
>To: Multiple recipients of list ORACLE-L
>
>
>one I want is "can the package tell me when a datafile extends"
>
>also, I want (and have NEVER found) a package that can tell me the locking
>SQL, when the locker has gone on and done other SQL after the lock.
>
>ex.
>
>user1 does:
> select * from table for update where <some where clause>
> update table
> insert into second table
>and does not commit
>
>user2 comes in and tries to update the first table, one of the rows that
>meets user1's where clause
>
>I can tell that user1 is blocking user2 but not the SQL that is doing the
>blocking. That's useful in beating duhvelopers about the head in order to
>get the code fixed.
>
>
>
> >From: "O'Neill, Sean" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Evaluation questions
> >Date: Tue, 31 Jul 2001 02:25:49 -0800
> >
> >I'm still slogging away at selection process of DB monitor tool. I'm now
> >at
> >stage where I'm compiling a list of specific tasks I'd like to take the
> >contenders through and score them on same.
> >E.G.
> >Can package alert if Oracle DB goes down?
> >Can package alert if Control File extends?
> >
> >I'd appreciate your feedback on what you think the monitor package should
> >be
> >able to do, ya know those things you want to know about before anyone
>else
> >does!. I'm particularly fishing for events that might be a bit more
> >obscure
> >yet still useful to monitor.
> >
> >
> >Sean :)
> >
> >Rookie Data Base Administrator
> >Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K
> >[0%] OCP Oracle8i DBA
> >[0%] OCP Oracle9i DBA
> >-------------------------------- ------------
> >Organon (Ireland) Ltd.
> >E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode]
> >
> >Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
> >
> >"Nobody loves me but my mother... and she could be jivin' too." - BB
>King
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: O'Neill, Sean
> > INET: [EMAIL PROTECTED]
> >
> >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: [EMAIL PROTECTED] (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/intl.asp
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
> INET: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: Gary Weber
> INET: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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/intl.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
