RE: Move to Sys Admin

Paula,

I had the same issue about 10 years back. Moved into a SysAdmin position - initially no one considered my Oracle skills until the onsite DBA ran into issues and I stepped in and sorted it out. From then on, I became the unofficial DBA...

In addition, hard, technical skills (such as Unix Admin/DBA) are always in demand as compared to intangible, soft skills (Data Management, Project Management), etc. It is always a good idea to keep in touch with the latter, but not at the expense of the former. Hard times will force Damagement to postpone/cancel that all important 'Enterprise wide Data Integration Study', but the backend SysAdmin/DBA dept has to still run...

All the best!
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Disappointment is inevitable, but Discouragement is optional!

• The opinions and statements above are entirely my own and not those of my employer or clients **

> -----Original Message-----
> From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM]
> Sent: Thursday, May 22, 2003 1:19 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Move to Sys Admin
>
>
> Paula
> - Usually it occurs the other direction, with a sys admin
> becoming a DBA.
> - You'll spend a lot more time on-site. DBAs can usually
> do their job
> remotely. Can't do a hardware upgrade remotely.
> - I'd say that if they let you, go for it. Broadening your
> career never
> hurts. If after a year you decide it isn't for you, what have
> you lost?
>
>
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> -----Original Message-----
> Sent: Thursday, May 22, 2003 2:23 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Organization combining data administration and physical
> database. In some
> ways it makes sense except for some of the personalities
> combined with lack
> of IT experienced involved. Therefore, since I really like
> the organization
> I am considering going to the server-side (if they let me).
> What do you
> guys think? Lots of experience in database - oracle DBA 8
> years jumps to
> system administration. Reaction or good career choice? Yes,
> I will miss
> the DBA stuff.
>
> Oracle OCP DBA
>
>
> -----Original Message-----
> <mailto:ineyman_at_perceptron.com> ]
> Sent: Thursday, May 22, 2003 2:27 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Stephane,
>
> You forgot to finish your message with :-)
>
> Igor Neyman, OCP DBA
> ineyman_at_perceptron.com
>
>
>
> -----Original Message-----
> Faroult
> Sent: Thursday, May 22, 2003 12:37 PM
> To: Multiple recipients of list ORACLE-L
>
> 1 select COLUMN_NAME, DATA_LENGTH
> 2 from DBA_TAB_COLUMNS
> 3 where TABLE_NAME='DBA_IND_COLUMNS'
> 4* and COLUMN_NAME = 'COLUMN_NAME'
> SQL> /
>
> COLUMN_NAME DATA_LENGTH
> ------------------------------ -----------
> COLUMN_NAME 4000
>
> So it looks like no matter what the column name looks like,
> the column_name is always 4000 characters long.
>
> SF
>
> >----- ------- Original Message ------- -----
> >From: "gmei" <gmei_at_incyte.com>
> >To: Multiple recipients of list ORACLE-L
> ><ORACLE-L_at_fatcity.com>
> >Sent: Thu, 22 May 2003 08:11:53
> >
> >SQL> select * from v$version;
> >
> >BANNER
> >Oracle8i Enterprise Edition Release 8.1.7.3.0 -
> >Production
> >PL/SQL Release 8.1.7.3.0 - Production
> >CORE 8.1.7.0.0 Production
> >TNS for Solaris: Version 8.1.7.3.0 - Production
> >NLSRTL Version 3.4.1.0.0 - Production
> >
> >SQL> create table t1(f1 char(1), f2 varchar2(1), f3
> >number, f4 number(1));
> >
> >Table created.
> >
> >SQL> select COLUMN_NAME,DATA_LENGTH from cols where
> >TABLE_NAME='T1';
> >
> >COLUMN_NAME DATA_LENGTH
> >------------------------------ -----------
> >F1 1
> >F2 1
> >F3 22
> >F4 22
> >
> >
> >So it looks like no matter what precision one
> >defines for NUMBER column, the
> >data_length is always 22. So char or varchar would
> >use less space for column
> >data (not index data).
> >
> >Guang
> >
> >> -----Original Message-----
> >> From: root_at_fatcity.com
> >[ mailto:root_at_fatcity.com <mailto:root_at_fatcity.com> ]On Behalf Of
> >> Orr, Steve
> >> Sent: Thursday, May 22, 2003 11:07 AM
> >> To: Multiple recipients of list ORACLE-L
> >> Subject: RE: flag
> >>
> >>
> >> Y/Null instead of Y/N worked really well for us.
> >We had a
> >> multi-million row table that was often queried
> >with the flag
> >> value and only returned a small number of rows
> >based on the
> >> flag. An index was needed on the flag but if all
> >rows
> >> contained a 'Y' or an 'N' then the index required
> >a lot of
> >> overhead and quickly became stale and needed
> >rebuilding. By
> >> changing the data to Y/Null instead of Y/N and
> >rewriting the
> >> code just a little we had a much smaller index
> >and
> >> performance didn't degrade. Using NULL for
> >boolean operations
> >> works well because NULL is not nothin' ya know.
> >>
> >> - Steve
> >>
> >>
> >> -----Original Message-----
> >> Sent: Wednesday, May 21, 2003 9:07 PM
> >> To: Multiple recipients of list ORACLE-L
> >>
> >>
> >> I liked the idea of using 0/1 for Java Boolean
> >operations
> >> but on the other side of the argument is that we
> >inadvertently
> >> did a datatype transformation and ended up not
> >using the
> >> index (Oracle implicitly converted the data side
> >to number
> >> and failed to use the index, where we compared
> >against
> >> a field defined, based on a table and the table
> >had been
> >> created with wrong data type AAAaaargh.
> >>
> >> I much prefer Y/N. However because many of our
> >> applications (for Fed Govt) need to be bilingual,
> >
> >> 1/0 is used (rather than worry about storing
> >Oui/Non)
> >>
> >> - Babette
> >> -----Original Message-----
> >> Sent: Wednesday, May 21, 2003 8:28 PM
> >> To: Multiple recipients of list ORACLE-L
> >>
> >>
> >> If it's a Y/N flag (boolean) that needs to be
> >indexed then
> >> you can just make
> >> it Y/NULL and handle it via code. This can
> >substantially
> >> reduce the size of
> >> the index. (not talking about bitmap indexes now)
> >
> >>
> >>
> >>
> >> -----Original Message-----
> >> Sent: Wednesday, May 21, 2003 3:48 PM
> >> To: Multiple recipients of list ORACLE-L
> >>
> >>
> >> Are you planning to use the flagged column as a
> >boolean across a jdbc
> >> connection? If so, then go with a number
> >datatype. The 9i
> >> jdbc driver does
> >> not know how to handle boolean datatype, thus if
> >you store
> >> 'Y' in a char
> >> column the jdbc driver will throw errors when the
> >java
> >> application calls
> >> GetBoolean against the jdbc driver.
> >>
> >> Mark
> >>
> >> -----Original Message-----
> >> Sent: Wednesday, May 21, 2003 1:17 PM
> >> To: Multiple recipients of list ORACLE-L
> >>
> >>
> >> Would you use a number or char for a flag in a
> >table? Would you use a
> >> char since it's one byte and a number is 22
> >bytes?
> >>
> >> Dave
> >> --
> >> Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net <http://www.orafaq.net>
> >> --
> >> Author: David Turner
> >> INET: turner_at_tellme.com
> >>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> <http://www.orafaq.net>
> --
> Author: Stephane Faroult
> INET: sfaroult_at_oriolecorp.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> <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).
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> <http://www.orafaq.net>
> --
> Author: Igor Neyman
> INET: ineyman_at_perceptron.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> <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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.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).