Re: Help - DBA interview questions I faced
What I have found is that interviewing for an Oracle DBA job is quite different from doing the actual job. I've been a contractor - and had to interview after each gig was over. My job consisted of "action" - entering the commands, people skills, collecting useful scripts "just in case" - and using them shortly afterwards. When a situation came up, it meant going through my spreadsheet of resources collected over the years. For interviewing, it can be more theoretical "bookish" - 1. What are the four essential background processes and how are they used. 2. How is an "outer join" different from an "inner join". I liked the interviews where they told me about their project, and I told them how I could contribute - strengths and weaknesses. I'm great at *. I don't know much about YYY, but I'm willing to learn. We cannot know everything. On my last project, we had seven Oracle DBAs. Each one had something to contribute. Sometimes I'd know something that the most seasoned, knowledgeable DBA would not know - because they had not learned new extensions to existing commands. What I do with difficult interviews - when I haven't done well, is to write down the questions as they are being asked. Research the answers, and be better prepared for the next interview. That's how I got my start in DBA-land. I eventually knew most of the answers to most questions. I even discovered DBAs who had the wrong answers to their own interview questions. What can you do - just keep in mind you're dealing with human beings. You will end up at the job that is best for you - and the client. Jenny Jacobson www.oracle-dba-consulting.com On Tue, 25 Dec 2001, Dharani Ravi wrote: > Thanks for your reply. Initially I felt demoralised > after reading your reply. Truth is always bitter. > You are correct. My Oracle concepts knowledge needs > to be improved. I read Oracle 8 concepts manual two -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenny Jacobson INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Another Oracle DBA gets "The Bullet" WAS: Help!: Job Descrip
Rachael, In 1996, I moved from Minnesota to Houston Texas (Katy). By the time summer rolls around, you get used to the humidity. It's like getting used to the COLD up north. Jenny Jacobson On Tue, 13 Nov 2001, Rachel Carmichael wrote: > 'cause there ain't enough money in the world to bail you out? > > The only problem I have with Texas is the heat. I have good friends > down there (you guys all know who you are and if you don't, WAKE UP)... > but I went down over Memorial Day weekend to SA and nearly melted from > the humidity. This does nothing to induce me to move South. > > > > --- Jeffery Stevenson <[EMAIL PROTECTED]> wrote: > > Bail money??? Why wasn't I invited? :) > > > > Yeah, like was mentioned, there's some positions available in Austin, > > but > > not as prevalent as it used to be. VC money has been tightened up so > > a lot > > of these companies looking to grow have been hit hard (and the bigger > > companies are just cutting back to save money). The problem I see > > though is > > that companies seem to be trimming back too much. I'm starting to > > hear > > little rumours here and there of companies going, "Maybe we shouldn't > > have > > gotten rid of most of our support/operations people?" It's not bad > > here > > though...it'll pick back up again...and I agree it's a great place to > > live. > > > > Guvm'nt jobs? Eep! Yeah Scott, I noticed that SA had about 4 times > > as many > > Oracle/DBA positions listed than Austin when I scouting the market > > for a > > friend who's looking at this area. That scared me... > > > > Jeffery Stevenson > > Databeast Slayer > > Medical Present Value, Inc. > > Austin, TX > > > > > > -Original Message- > > Sent: Monday, November 12, 2001 9:30 PM > > To: Multiple recipients of list ORACLE-L > > Description for > > > > > > David, > > > > Yes you should drive down/me drive up to meet. Just let me get past > > some > > current difficulties. We could leave bail money with the wives! > > Hehehe... > > > > San Antonio (SA) has been hit, but definitely not as hard as > > Austin/Dallas/Houston. I'll probably regret this (if I end up > > competing for > > a job), but anyone looking for a job could do a lot worse than > > looking in > > SA. Most of the tech jobs here are government, gov/private > > consulting, or > > big company IT (USAA, MCI, SBC, etc). The largest industry however > > is > > tourism, which has been hammered. This doesn't affect techies much > > though. > > > > If one has no qualms about managing databases of bigger and better > > ways to > > "break things and kill people", then DOD contracting is the way to go > > in > > Central Texas. Cost of living is very low, and SA is the 8th largest > > city > > in the US. Upsides: steady work, excellent food, mild winters, lots > > of > > recreational activities. Downsides: Inept city government, yearly > > drought, > > HOT for 9 months of the year. > > > > --Scott Shafer > > San Antonio, TX > > > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Monday, November 12, 2001 7:05 PM > > Description for > > > > > > > > > > Thanks folks for the replies I got. Compiled them into a sort of > > > superDeveloper/Data Architect/All-Around wonderful human being job > > > description. > > > > > > The job market in Austin is really poor for us "high-tech" types > > right > > now. > > > This was the home or a principal branch office of a large number of > > failed > > > dot coms and Internet business ventures. A partial list of Austin > > failures > > > includes (but is by no means limited to): > > > > > > Netpliance > > > Hand Technologies > > > ConnectSouth (my alma mater) > > > DrKoop.Com > > > Garden.Com > > > Furniture.Com > > > carOrder.Com > > > > > > Layoffs in many (most?) surviving companies have further added to > > the glut > > > of talent out on the streets. Other large Austin employers > > reducing staff > > > in the tech area include AMD, Motorola, SamSung, IBM, Perficient > > and CSC. > > > Non-tech companies such as law firms, trav
Re: OT -- suggestions to ensure nerdiness in potential IT staff
On Wed, 1 Aug 2001, Boivin, Patrice J wrote: > e.g. one should know what Heathkit was (not that A+ stuff) , and the > Sinclair, not to mention a few other things: > I don't know the answer to all those questions. However I was a ham radio operator - K0VIH calling CQ CQ CQ - with a Heathkit DX40 xmitter and an AR88 receiver. Math major in college. Earned an A in slide rule. Jenny Jacobson www.oracle-dba-consulting.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenny Jacobson INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: any way to stop rollback for dml?/8.1.7.1/Solaris 8
alter table . nologging; Jenny Jacobson www.oracle-dba-consulting.com On Fri, 27 Jul 2001, Austin, Steve S wrote: > Does anyone know of a way to inhibit rollback from being generated for DML? > > We've got a data warehouse load process that we're trying to speed up > (involving sqlldr and then some DML afterwards.) The staging tables it uses > are entirely for this process -- there's no need to rollback if it fails; > we'd truncate them and start again with that set of data. > > Aside from sqlldr direct mode and import direct mode, can anyone think of > ways to do this? > > Thanks, > Steve > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Austin, Steve S > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Jenny Jacobson INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Re: Jobs
IMHO: If recruiters can post jobs, each of us can post our need for a job. However, sending a resume is unnecessary. If someone is interestered, they can contact the poster privately and request a resume. Jenny Jacobson www.oracle-dba-consulting.com On Mon, 23 Jul 2001, Jon Walthour wrote: > > > Listers: > > Is it appropriate to be sending one's resume to the mailing list > (especially as an attachment)? I don't think so, but have not > heard much to that effect thus far. So, maybe it is. Can someone > please enlighten me? > > Jon Walthour > > >--- Original Message --- > >From: "C.S.Venkata Subramanian" <[EMAIL PROTECTED]> > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Date: 7/23/01 8:30:27 AM > > > Hello, > >I'm currently working in India as Oracle DBA. I'm willing to > relocate to UK or Europe for a descent salary. I'm attaching > my resume with this mail. > > > >Expecting to hear from you > > > >Regards > >Venkata Subramanian C.S. > >-- > > > >On Mon, 16 Jul 2001 11:30:50 > > Culum Slater wrote: > >>Hello Oracle professionals, > >> > >> > >>Are there any Oracle DBA's currently looking for work in and > around London, England. > >> > >>If so, send me a copy of your cv and I will do my best to find > you the right job. > >> > >>We are an Oracle specialist recruitment consultancy. > >> > >>Regards > >> > >>Culum Slater > >>Managing Director > >>CMS Global Ltd > >> > >>D/L: 01923 233196 > >> > >>M/N: 07960 113 738 > >> > >>[EMAIL PROTECTED] > >> > >>CMS Global Ltd, 39 Elizabeth House, Watford, Herts, WD24 4RE > >> > > > > > >Get 250 color business cards for FREE! > >http://businesscards.lycos.com/vp/fastpath/ > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jon Walthour > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Jenny Jacobson INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: OFF TOPIC: My Unix mail file is too huge to access
Thanks to all who replied. I received some very helpful ideas and new knowledge. Charlie Mengler came up with the solution I used: 1. Use vi on this huge file to find a place to split the file. 2. Then issue the command: cat jenny | head -153498 | > jenny153498 3. Place the new jenny153498 file in the directory of PINE folders. 4. Use PINE and view the messages in the jenny153498 folder. Thanks. Jenny On Thu, 24 May 2001, PD Miller wrote: > At 13:49 -0800 24/5/01, Jenny Jacobson wrote: > >How do I get into my old mail so I can 1) delete old messages and > >2) access a VERY important email that I need to use. > > Eudora uses the exact format used for unix mail files, so I recommend that. > > >I don't think my unix account has a pop3 server. Someone suggested I ftp > >the file to my PC and read it there. When I did a file command, it said > >the mail file was ASCII text, but my important email has an attached Excel > >spreadsheet. Do I ftp in ASCII or binary mode? > > Binary for certain. Eudora can sort out the attachment format as long > as the file has not been translated. Not just email, but with > everything, use binary only. Even if you need the line terminators > translated, ftp is the worst way on earth to do it. > > >I don't have any mail > >software on my PC (I use a shell account and Yahoo). I don't want to use > >my Yahoo account to process this huge file via pop3. > > http://www.eudora.com/ and it is free. > > Regards > > Paul Miller > > -- > - > Carib Data Limited > > <mailto:[EMAIL PROTECTED]> > <http://www.caribdata.co.uk> > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: PD Miller > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Jenny Jacobson INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
OFF TOPIC: My Unix mail file is too huge to access
Last fall I stayed away from the computer for a long time -- nice vacation. When I went to read my email, I had over 6,000 messages. I started reading and deleting away. Got knocked off the net without exiting. This happened several times until I was no longer able to bring up my email in PINE on Unix. I saved the mail file and let the system continue in a new file. The old mail file is 30 MB. Now I have a stable environment. How do I get into my old mail so I can 1) delete old messages and 2) access a VERY important email that I need to use. I don't think my unix account has a pop3 server. Someone suggested I ftp the file to my PC and read it there. When I did a file command, it said the mail file was ASCII text, but my important email has an attached Excel spreadsheet. Do I ftp in ASCII or binary mode? I don't have any mail software on my PC (I use a shell account and Yahoo). I don't want to use my Yahoo account to process this huge file via pop3. How do I access my important email in this old mail file? Thanks. Jenny Jacobson -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenny Jacobson INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Happy Birthday List !!
Jared sent out his notice of the new mailing list on May 26, 1998. Jenny Jacobson Oracle DBA Consultant Available for project - no perm Resume: http://home.earthlink.net/~jennydba On Thu, 26 Apr 2001, John Kanagaraj wrote: > Jared, > > >I guess it has been a couple of years now. > > > >Or is it three? > > > >Sorry, I really don't remember what year it was. > > > >Anyone recall with any accuracy? > > > >Jared > > > > The earliest message from the list that I saved in my mail folder is dated > 3-Aug-98, from the days when it was at Teleport (pre-predecessor of > fatcity?). I assume that the list was present earlier than that time, so > three years is probably right. The one from the 'oracledba' list at > Mailinglist.net (predecessor of LazyDBA) was shortly after. That's a looong > time as far as Listservs go (I think). Anyway, fantastic job Jared! And > thanks for your time, patience and persistence. > > John Kanagaraj > (used to be that lone voice from remote Brunei, back on the list after a > hectic three months) > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: John Kanagaraj > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Jenny Jacobson INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Should each partition have it's own tablespace and datafile?
One tablespace per partition.
If you're not sure of the final size of the partition,
consider putting each tablespace file
with autoexend ON and specify max filesize (MAXSIZE).
For example: if partition extent size is 10M, the autoextend value could
be 100M to have room for 10 more extents. This tip helps avoid a lot of
wasted space AND/OR getting calls in the middle of the night to make the
filesize larger. Be sure the autoextend does not attempt to extend
the filesize beyond the capacity of the disk. Sizes chosen would
depend upon your knowledge of the partition size needed to hold the data
and your strategy. Could also autoextend at 10M, but performance would
be affected if a lot of new extents were added during a load.
Syntax:
CREATE TABLESPACE CUST_DATA_0401
DATAFILE '/u5/oracle/oradata/data/cust_data_0401.dbf'
SIZE 100M
AUTOEXTEND ON
NEXT 100M
MAXSIZE 500M;
and the corresponding index - file size dependent upon how many indexes
present on the table and how large the column sizes are. If you have
five indexes (in a datawarehousing environment), the size of the index
tablespace COULD be larger than the corresponding data tablespace.
CREATE TABLESPACE CUST_IDX_0401
DATAFILE '/u06/oracle/oradata/index/cust_idx_0401.dbf'
SIZE 50M
AUTOEXTEND ON
NEXT 10M
MAXSIZE 300M;
Jenny Jacobson
Oracle DBA Consultant
Member - RMP Consulting Partners LLC - Member NAACB
Available for project
On Wed, 11 Apr 2001 [EMAIL PROTECTED] wrote:
>
> We have a 120 Gig datawarehouse that uses
> more than 100 date-based partitions. For financial
> and political reasons, we have run out of disk space
> to give this database as it continues in it's relentless
> growth.
>
> The developers have resigned themselves to purge
> out some of the old data and get rid of partitions that
> are more than two years old.
>
> We currently have about ten tablespaces that contain
> all of the data and indexes for this database. There is
> a small, medium, and large tablespace for data and
> for indexes plus some other specialized tablespaces
> by functionality.
>
> Anyway, dropping a couple dozen of these partitions
> is not going to be enough to free up some disk space
> for us. Instead we're going to have to export our data,
> drop the tablespaces, and recreate them as a smaller
> size and then reimport the data minus the dropped
> partitions.
>
> Since we're going to all of this work, I'm wondering
> if we should reorg these partitions by creating a tablespace
> for each partition and a single datafile for each tablespace.
> That way in the future, every time we want to drop a partition,
> it will be very easy to reclaim the disk space associated with
> that partition. I don't want to have to do these reorgs every
> month.
>
> How do most places physically lay out their partitions?
> What is the downside of having a datafile for each partition?
> Wasted space? Would a compromise be to assign
> six months worth of partitions to a single tablespace?
>
> We are currently on version 8.0.4 of Oracle on Sun Solaris 2.6
> but we will be upgrading soon to 8.1.7. Looks like I may need
> to reorg this before we can upgrade as we are rapidly running
> out of room.
>
> Thanks,
>
> Cherie Machler
> Gelco Information Network
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: Jenny Jacobson
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
