RE: Oh Where Oh Where Is My Redo Coming From

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Fri, 21 Feb 2003 12:32:03 -0800
Message-ID: <F001.0055542B.20030221123203@fatcity.com>

Ethan,

There is a option in TOAD that automatically commits after every query ... turn that off ...

Raj

---

Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !!

-----Original Message-----
Sent: Friday, February 21, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L

As always Jonathan you give me plenty of areas to go looking, thanks for the great advice. One of the problems is cron kicks off various application processes in the line of over 60 per minute (log in, do something, log out, oh and commit between each row of course). That on top of hundreds of users accessing the system and oh 4 or 5 developers working in the same database doing whatever they please. I found one guy the other day had issued 290,000 commits in a single session using Toad. Argghhhh! You get the idea. I am attempting to bring in a little sanity to the situation before they recommend buying more CPUs!

• Ethan

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).



text/plain attachment: ESPN_Disclaimer.txt

Received on Fri Feb 21 2003 - 14:32:03 CST