Re: Becoming ORACLE DBA

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:2cldc11h91chifj5gno8d44rduf5t0pevl_at_4ax.com...
> On Sat, 2 Jul 2005 10:35:21 -0600, "Mark A" <nobody_at_nowhere.com>
> wrote:
>
>>There is one aspect of working as a DBA that has not been mentioned and is
>>often more important. That is as a database designer. The physical
>>database
>>design has a huge impact on the success of a project and the ability to
>>come
>>up with a flexible, but well-performing database design is one of the most
>>important aspects of a DBA. This requires a knowledge of the business,
>>application development, and the ability to work well with development
>>teams. Poor database designs are the number one reason that application
>>development projects fail.
>
> I don't know what your background is, but my experience is that
> developers usually do all the design. That usually results in a
> database without referential integrity, and not even adhering to 1NF,
> let alone to 3NF. Obviously, there is nothing a DBA can do about that.
> However, when the database performs poorly, invariably exactly those
> developers start blaming the DBA.
> When the DBA can make clear, it is not a database problem, but an
> application problem, the developers usually come up with all kind of
> silly assertions about their product, like 'enforcing integrity in the
> application server is much more efficient' and usually flatly refuse
> to repair the flaws and errors demonstrated.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

Sounds familiar ;-) We had performance problems, and 2 external audits showed the source of the problems was unefficient SQL (cartesian joins, no bind variables, ...) and database design problems (lack of primary keys, no indexed fk columns, numbers stored as varchars, unused indexes, ...). Still, the DBA and sysadmin were blamed ... and higher management decided to buy 2 extra CPU's ... On meetings, I sometimes had the impression everyone was thinking "what the hell is he talking about". Very frustrating ... Received on Sat Jul 02 2005 - 15:15:36 CDT