From carmichr@hotmail.com Thu, 15 Mar 2001 11:46:23 -0800 From: "Rachel Carmichael" Date: Thu, 15 Mar 2001 11:46:23 -0800 Subject: Re: Oracle DBA evolution path - please share your opinion Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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 >Reply-To: ORACLE-L@fatcity.com >To: Multiple recipients of list ORACLE-L >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@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@LAZYDBA.com > > to subscribe send a blank email to oracledba-subscribe@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@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@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@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@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@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@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@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@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).