Re: max open cursors case

Jacques,

Regarding item 'c' below:

Quantify 'faster'. Is it enough to matter?

Also, if the DBA actually knows what he/she is doing, there's a very good reason for using multiple tables.

Normalization, the removal of redundant data.

Jared

On Tuesday 08 April 2003 16:53, Jacques Kilchoer wrote:
> > -----Original Message-----
> > From: Goulet, Dick [mailto:DGoulet_at_vicr.com]
> >
> > Bashing Duhvelopers is a favorite past time of DBA's
> > and I believe for good reason:
>
> A lot of what you say is true, but what is the view from the other side of
> the fence? e.g. what are the justifiable complaints developers have with
> DBAs?
>
> I think a few are:
> a) Assuming that John Q. Developer knows all the Oracle features and is
> aware of what is poor Oracle coding practice.
> b) Not having time for every developer to run up with a question "how do I
> write this SQL statement" but then complaining as soon as it's put in
> production.
> c) The Duh-BA forces me to separate data in 10 different tables even though
> my query would run a lot faster if everything was in one table.
> d) When I have to write a program to update all the rows in a table and ask
> "how do I avoid that 'snapshot too old' thing I've been hearing about?" the
> Duh-BA says "maybe you'll get lucky."
> e) Calling me a "duh-veloper" behind my back.
>
> Any others?

Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 
----------------------------------------

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.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).