| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle DBA evolution path - please share your opinion
nice, very nice..... and just in time, as I have decided to "put a stake in the ground" (to quote our CTO) and take back control of my databases. My programmers have been allowed to run riot due to a limited number of hours in the day for me to get things done. No more.
Now, where did I leave that kevlar vest?
Rachel
>From: Paul Drake <paled_at_home.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Oracle DBA evolution path - please share your opinion
>Date: Wed, 14 Mar 2001 22:10:33 -0800
>
>How's this for starting down the path to the dark side?
>
>set pagesize 0 linesize 132
>set heading off verify off termout off feedback off
>REM give them their own sandbox
>CREATE TABLESPACE "TRAFFIC" NOLOGGING
> DATAFILE 'E:\ORACLE\ORADATA\DEV\TRAFFIC.DBF' SIZE 128M
> EXTENT MANAGEMENT LOCAL UNIFORM SIZE 160K
>/
>spool no_more_garbage_in_real_tablespaces.sql
>select 'set heading on verify on feedback on termout on'||chr(10)||
> 'set pagesize 9999 linesize 80'
> from dual
>/
>select 'spool bdbafh_gets_revenge.lst' from dual
>/
>select 'REM '||username||' go play in traffic'||chr(10)||
> 'REVOKE RESOURCE FROM '||username||';'||chr(10)||
> 'ALTER USER '||username||' QUOTA 0 ON USERS;'||chr(10)||
> 'ALTER USER '||username||' QUOTA 0 on INDX;'||chr(10)||
> 'ALTER USER '||username||' QUOTA 48M ON traffic;'
> from dba_users
> where username not in ('SYS','SYSTEM','CEO','OEM')
>/
>select 'spool off' from dual
>/
>spool off
>@no_more_garbage_in_real_tablespaces.sql;
>
>enjoy.
>
>Paul
>
>"Gogala, Mladen" wrote:
> >
> > Did anybody explain you the path of a BDBAFH (DBA version of BOFH)?
> >
> > -----Original Message-----
> > Sent: Wednesday, March 14, 2001 11:16 AM
> > To: Multiple recipients of list ORACLE-L
> >
> > Thanks a lot to all who have responded !
> > U guys really give me inspiration and motivation to go ahead and learn
> > things .
> > I decided to learn everything i could about Oracle ( mainly from these
> > lists ) and simultaniously epand my Java experience .
> > I think it's a good path !
> > Thanks a lot again for your thoughts .
> > BTW , Gaurav , what is "apps dba" ?
> > How could i learn this ?
> >
> > Thanks a lot !
> >
> > -----Original Message-----
> > Behalf Of Gaurav Verma
> > Sent: Tue, February 27, 2001 7:18 AM
> > To: ORACLE-L_at_lists.sunysb.edu
> >
> > Andrey .. good question!
> >
> > > Some background : i've been around Oracle for
> > > several years , i'm DBAing for
> > > 2+ years now , i have written some java code (jdbc ,
> > > some XML etc) , perl ,
> > > PL/SQL , Tcl/Tk , a lot of UNIX scripting .
> > > .Where do i go to from here ?\
> >
> > Long way to go..
> >
> > >
> > > Many people say that the profession of Oracle DBA is
> > > going to be less
> > > demanded in future , because of :
> > > 1) either other DB ( like less-expensive MS SQL
> > > Server or free MySQL) will
> > > occupy the market , especially in small enterprises
> > > ;
> >
> > thats bullshit. If you are a good dba then you should
> > know where to sell your skills. Big organisations
> > still rely on Oracle and will. Oracle aint gonna die
> > so fast.
> >
> > > 1) either other DB ( like less-expensive MS SQL
> > > Server or free MySQL) will
> > > occupy the market , especially in small enterprises
> >
> > is an wayward extrapolation and not yet a reality. We
> > all know the limitations of Sqlserver etc. FOr
> > enterprise use, Oracle is still the best.
> >
> > > 2) or Oracle will "improve" the DB management and
> > > make it "point and click"
> > > , so you do not need a dedicated Oracle DBA at all
> > > or you need less Oracle
> > > DBAs .
> > >
> > thats true. Oracle will always improve the interface.
> > and it did. from SQl*dba to OEM, it has improved a lot
> > (point and click) but still you do need human
> > intervention a lot. Human decision is still human
> > decision and you should know it better. DBAs are
> > always going to be in demand. You could say.. people
> > might need lesser.. but then what do just have to do
> > is become one of the best. Keep updating your skills.
> >
> > > So , the bottom line is : what should i learn now ?
> > > how can i extend my
> > > expertise ? In which fields ?
> >
> > Hmm... guess you should try out the marketable skills.
> > working on production databases, high-availability
> > implementations, partitioning, datawarehousing,
> > replication, parallel server (now replaced with (9i
> > clusters) blah blah blah
> >
> > > Please share your thoughts !
> > > Thanks a lot in advance !
> >
> > So my friend, there is a lot to learn and work upon.
> > You could even consider becoming an apps dba rather
> > being an plain oracle dba. It pays a lot more and you
> > have to believe me there. 11i is HOTTTT man.
> >
> > just my 2 cents.
> >
> > cheers,
> >
> > Gaurav
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Get email at your own domain with Yahoo! Mail.
> > http://personal.mail.yahoo.com/
> >
> > --------
> > Think you know someone who can answer the above question? Forward it to
> > them!
> > to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> > to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: andrey
> > INET: bronfin_at_visualtop.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > 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).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Gogala, Mladen
> > INET: MGogala_at_oxhp.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > 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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Paul Drake
> INET: paled_at_home.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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 Thu Mar 15 2001 - 13:46:23 CST
 |
 |