Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle DBA evolution path - please share your opinion

Re: Oracle DBA evolution path - please share your opinion

From: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Thu, 15 Mar 2001 11:58:03 -0800
Message-ID: <F001.002CD87A.20010315064257@fatcity.com>

I think I'll still use the original script. I AM that evil </wicked witch cackling laugh>

>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:50:20 -0800
>
>sorry - that should have included the following line:
>
> 'ALTER USER '||username||' DEFAULT TABLESPACE
>traffic;'||chr(10)||
>
>I'm not *that* evil.
>
>Pd
>
>Paul Drake wrote:
> >
> > 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).



Get your FREE download of MSN Explorer at http://explorer.msn.com
-- 
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:58:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US