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: RE: a PL/SQL design question.

RE: RE: a PL/SQL design question.

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Tue, 10 Dec 2002 06:29:21 -0800
Message-ID: <F001.0051611D.20021210062921@fatcity.com>


Dear Richard,

These are a bunch of developers who think they are "GOD" (at-least their managers think so) ... we have learned that it is better to let them try and fail themselves rather than trying to explain them the right thing ... it works all the time. It is their database, and they own it, so if it has any problems, they suffer ... and learn.

Lather .. rinse .. repeat.

Yes, they could have done something better, but sometimes they need output in a fraction of a second ... because when "bottomline" or "clock" gets updated during a live broadcast, having 1 to 1.5 second delay is unacceptable... Most other times these developers are good ... they fight if their queries take longer than 500ms ... they try to tune and tune the code to make it right. It is only "sometimes" something like this happens.

Plus we never could reliably run dbms_jobs on 9012 on AIX 433 .. all dba related actions rely on "cron" ..
Raj



Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----
Sent: Tuesday, December 10, 2002 9:13 AM To: Jamadagni, Rajendra; Multiple recipients of list ORACLE-L

DBMS jobs are good things for stuff that can occur totally within the database
and on a scheduled basis only. It sounds, RAJ, like your developers made a real
mess. What would have been a better idea would have been to have the trigger
update a table that the job on a scheduled basis checked for what it needed to
do.

Dick Goulet


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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).

Received on Tue Dec 10 2002 - 08:29:21 CST

Original text of this message

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