Oracle-L: Re: Oracle Job Task Analysis

From: <Jared.Still_at_radisys.com>
Date: Wed, 02 Apr 2003 09:59:10 -0800
Message-ID: <F001.0057854B.20030402095910@fatcity.com>

Scott,

This is quite a list you have compiled.

I wouldn't subtract anything.

The only thing I could think of to add was in the Scalability section.

This section seems to concentrate on using Oracle technologies to enhance scalability, but there is another level that I think needs to be considered as well.

The ability to scale ( or not ) is built into an application. An app that
calls 'select something from dual' in every transaction is going to have problems.

So will apps where the developers insist on trying to do everything in code rather than relying on the database.

A DBA should be able to recognize when this is happening. The best course is to have an adivisory position in this regard when an app is being developed. Doesn't often happen this way though.

A DBA should be able to demonstrate common developer habits that inhibit scalability, and how to recode these so that they are more scalable.

Being able to do so in PL/SQL is sufficient, and in fact preferable.

Any chance of us seeing the completed analysis?

Jared

Scott <oraracdba_at_yahoo.com>
Sent by: root_at_fatcity.com
04/01/2003 01:14 PM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Oracle Job Task Analysis

I am putting together a prelimanary job task analysis for Oracle DBA's and would like some input from you hardworking DBA's on this list.

Here is what I have so far for core competencies and I would like to add or subtract from this list based on your input.

Oracle Architecture And Options
Security and Network Access
Application Design and Modelling
Backup And Recovery
Software Maintenance And Operation
SEGMENT and DATA MANAGEMENT
Tuning And Troubleshooting

My Recommendations for slightly more advanced competencies that are still quite important For many installations.

H. Scalability
I. High Availability
J. Business Intelligence

Here is what I have as sub-components for the core competencies.

ORACLE ARCHITECTURE AND OPTIONS ...

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: Jared.Still_at_radisys.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 Wed Apr 02 2003 - 11:59:10 CST