Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: a PL/SQL design question.
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
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
- text/plain attachment: ESPN_Disclaimer.txt
![]() |
![]() |