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: Paul Drake <paled_at_home.com>
Date: Wed, 14 Mar 2001 22:41:43 -0800
Message-ID: <F001.002CD447.20010314221033@fatcity.com>

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).
Received on Thu Mar 15 2001 - 00:41:43 CST

Original text of this message

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