Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Evaluation questions

RE: Evaluation questions

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Tue, 31 Jul 2001 10:44:52 -0700
Message-ID: <F001.0035A946.20010731104727@fatcity.com>

Also, please keep in mind that some applications will "select for update..." and lock a row until the commit is issued. That could take a long time if the user is busy with daily office activities.
ROR mª¿ªm

>>> carmichr_at_hotmail.com 07/31/01 12:21PM >>>
Mark,

Transactions should not typically last more than 15-20 minutes. But I want a warning that there is a lock, not a kill, as it is possible that a non-typical transaction would last longer. As an example, I'm thinking of taking phone orders and entering them into a system (catalog sales). Typical orders might be small, but holiday time might take longer -- that's why I want it configurable.

I don't have sql that does it, that's the problem. And I have no idea how often to surf through the v$ tables, again a problem. Also, if you have cursor_sharing on, how does that affect it all?

Sigh... but it's fun to try to solve on a boring day.

Rachel

>From: "Mark Leith" <mark_at_cool-tools.co.uk>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Evaluation questions
>Date: Tue, 31 Jul 2001 06:55:30 -0800
>
>Rachel,
>
>You are right, I have not seen a tool that does this as standard either,
>though I think there could be a way of doing this with our particular
>product, that I will look in to - but I have a couple of questions:
>
>In a real world situation - what would the timeframe be for a user to
>update
>a table, then move on to another transaction? If we were to monitor blocked
>sessions, and want to catch the SQL they are currently executing by firing
>a
>select from v$SQLAREA/V$SQLTEXT action, and inserting a row to a temp
>table,
>how often should the monitoring collection refresh to guarantee collecting
>that statement?
>
>Is there any SQL that you have currently which can give you this
>information, without going this round about way?
>
>Cheers
>
>Mark
>
>-----Original Message-----
>Carmichael
>Sent: Tuesday, July 31, 2001 01:56
>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" <Sean.ONeill_at_organon.ie>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >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: sean.oneill_at_organon.ie [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: Sean.ONeill_at_organon.ie
> >
> >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/intl.asp
>
>--
>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).
>
>--
>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).



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: 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

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 Tue Jul 31 2001 - 12:44:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US