Workspace Manager Questions
Hello, I have some Workspace Manager Questions and I'm interested in general opinions/feelings about it. A little bit of background first: Our database is about 450GB, and we maintain a separate production and development instance. Multiple projects share the same instance, and the same tables, but they have different and overlapping data build and release cycles. When we migrate, we clone the database by putting it in online backup mode, copy the datafiles, and then restore as a new (production) instance. Obviously we're currently only in a position to release/migrate at the lowest common denominator, which creates downtime for the projects with significantly faster build cycles. We run 9iR2 on SuSE Enterprise. I'm interested in introducing Oracle's Workspace Manager in hopes of allowing migrations to occur while some projects are still in mid-build, and I'm curious about some of the following issues: 1) Reliability using Workspace Manager -- Each workspace has the potential to be up to 100 GB large and span several hundred tables. 2) Impact of conducting a migration while a workspace is open. -- I assume it wouldn't be a problem-- just extra data to copy, and a little bit of clean up time afterwards in production clearing out the open workspaces? 3) Feasibility of merging a workspace of this size back into the database -- Fortunately I don't foresee there to be significant conflicts during the merger 4) Best I can tell, the use of Workspace Manager wouldn't require any significant code changes. Is this correct? Any other Gotchas or things I should know about Workspace Manager? Any other opinions or approaches to solving this problem? We're also exploring the possibility of just giving each project its own instance, but there are significant shared data and projects which rely on the data as whole. (And yes, we have explored database links as a solution to this last point). Thanks much in advance for the insight wisdom. --Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Saffitz INET: [EMAIL PROTECTED] 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: [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: RMAN questions
I suppose just how much redundancy makes you sleep well is up to you. But, one additional bit of info to keep in mind is that the backup info also gets stored in the control files, and rman can use those too if no catalog database is available. Making a copy of a control file after the backup finishes, and saving that copy, can be a part of the rman backup. That way, if you lost all control files and your catalog database, rman can use your saved control file copy get back at least most, if not all, of your stuff. -Original Message- Any suggestions would be appreciated. I can handle the scripting my self. Im just looking for a viable plan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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).
RMAN questions
We have both 8i and 9i instances, but 'eventually' plan to migrate everything to 9i. I'm looking at using RMAN for our backup and recovery. We have many instances but essentially 2 types. 1. Production instances that have both OLAP and OLTP. These must be in archive log mode. 2. We have staging instances where we do data loads. We do not put these in archive log mode for obvious reasons. We do our backups of these with transportable tablespaces and running dbverify. We also have 2 locations. One is remote. Its not practical to store our backups from the remote location at our local location or vice versa. So we will need 2 seperate RMAN setups. I have seen that some people like to use two instances that have RMAN. Many people will just put the RMAN catalog in an existing instance. Is that really a good idea? The idea behind two instances is that they can back each other up. Is that really enough? You can lose both instances, then your backup sets are useless. We have a shared NAS, so each location uses the same set of storage. We do backup to tape as well. Any suggestions would be appreciated. I can handle the scripting my self. Im just looking for a viable plan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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: RMAN questions
I do not think you need 2 Rman catalogs. Build a small database just for Rman. After the daily backup finished bring it down and do os level backup of all the environment for this small backup. You can then easily restore it in case of disk problems. Remember: A backup is good only when you can restore from it. Test restores. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 4:44 PM We have both 8i and 9i instances, but 'eventually' plan to migrate everything to 9i. I'm looking at using RMAN for our backup and recovery. We have many instances but essentially 2 types. 1. Production instances that have both OLAP and OLTP. These must be in archive log mode. 2. We have staging instances where we do data loads. We do not put these in archive log mode for obvious reasons. We do our backups of these with transportable tablespaces and running dbverify. We also have 2 locations. One is remote. Its not practical to store our backups from the remote location at our local location or vice versa. So we will need 2 seperate RMAN setups. I have seen that some people like to use two instances that have RMAN. Many people will just put the RMAN catalog in an existing instance. Is that really a good idea? The idea behind two instances is that they can back each other up. Is that really enough? You can lose both instances, then your backup sets are useless. We have a shared NAS, so each location uses the same set of storage. We do backup to tape as well. Any suggestions would be appreciated. I can handle the scripting my self. Im just looking for a viable plan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] 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: [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: RMAN questions
i must have misread the docs. i thought it was either catalog or control file. didnt know you could do both thanks. From: [EMAIL PROTECTED] Date: 2003/12/04 Thu AM 11:04:26 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RMAN questions I suppose just how much redundancy makes you sleep well is up to you. But, one additional bit of info to keep in mind is that the backup info also gets stored in the control files, and rman can use those too if no catalog database is available. Making a copy of a control file after the backup finishes, and saving that copy, can be a part of the rman backup. That way, if you lost all control files and your catalog database, rman can use your saved control file copy get back at least most, if not all, of your stuff. -Original Message- Any suggestions would be appreciated. I can handle the scripting my self. Im just looking for a viable plan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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: RMAN questions
backup of all the environment for this small backup. It should have been: for this small database. Sorry about the mistake. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 6:44 PM I do not think you need 2 Rman catalogs. Build a small database just for Rman. After the daily backup finished bring it down and do os level backup of all the environment for this small backup. You can then easily restore it in case of disk problems. Remember: A backup is good only when you can restore from it. Test restores. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 4:44 PM We have both 8i and 9i instances, but 'eventually' plan to migrate everything to 9i. I'm looking at using RMAN for our backup and recovery. We have many instances but essentially 2 types. 1. Production instances that have both OLAP and OLTP. These must be in archive log mode. 2. We have staging instances where we do data loads. We do not put these in archive log mode for obvious reasons. We do our backups of these with transportable tablespaces and running dbverify. We also have 2 locations. One is remote. Its not practical to store our backups from the remote location at our local location or vice versa. So we will need 2 seperate RMAN setups. I have seen that some people like to use two instances that have RMAN. Many people will just put the RMAN catalog in an existing instance. Is that really a good idea? The idea behind two instances is that they can back each other up. Is that really enough? You can lose both instances, then your backup sets are useless. We have a shared NAS, so each location uses the same set of storage. We do backup to tape as well. Any suggestions would be appreciated. I can handle the scripting my self. Im just looking for a viable plan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] 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: [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.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] 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: [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: dba interview questions
What was all of that about swallows, anyway? And Bambi, didn't your last name formerly end with an s? It's great to have you back on the list, in any event. --- Bellow, Bambi [EMAIL PROTECTED] wrote: Kirti -- I've had that experience too. I generally start a telephone interview hopping around the person's resume and asking questions about individual jobs... what did they do here... what do they mean by that there what was the environment over there... was management supportive in that job over there... now let's talk about the technical side of things... because there's no way to tell whether you are talking to the person who's going in for the F2F over the phone... Notice that nowhere in there is any reference to swallows. That comes later in the interview when you want to discern whether this is established knowledge or just crammed 30 minutes before the phone is supposed to ring. Bambi. -Original Message- Sent: Tuesday, October 28, 2003 4:35 PM To: Multiple recipients of list ORACLE-L Better still, sometimes 'X' takes the questions while 'Y' the candidate just stands next to him because 'X' can answer but Y does not. Tel.int means you (most probably) have not seen the guys face..correct?? By the time Visa gets approved (if overseas candidate), 'Y' ensures that he 'gains' some experience. GovindanK -Original Message- Sent: 10/24/2003 7:45:29 AM To: [EMAIL PROTECTED] Oh! Well. I have not seen Tom's book yet. But still, when the candidate is explaining this stuff to you, there are plenty of opps to question him/her to find out if he/she really knows fundamental things.. During one phone interview, we could clearly hear the paper shuffle in the background, while the candidate asked us to repeat the question (a couple of times) to 'make sure' he understood it correctly before answering (reading?)it :) We stopped phone interview process after this!! - Kirti --- [EMAIL PROTECTED] wrote: that question is diagrammed and answered in tom kytes new book. :) im waiting to get asked it. there is a new ault book out on interview questions. I dont think they are very tough. I think situational questions are better. Have a development DB set up with things for the applicant to do. I find that most employers ask the same easy questions. Particularly developer questions --- system manager wrote: Dear List, Can anyone send me a list of dba interview questions? Thanks, ___ Get Your 10MB account for FREE at http://mail.arabia.com ! http://ads.arabia.com/?SHT=text_email_english Access MILLIONS of JOBS NOW! __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] 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: [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: dba interview questions
How salty is the water? -Original Message- Bellow, Bambi Sent: 27 October 2003 17:20 To: Multiple recipients of list ORACLE-L Bill -- I appreciate your input to this very complex question. IMHO, however, she turned me into a newt! is, technically, an interview *statement* rather than an interview *question*. That being said, it can be used at the beginning or end of the interview to set tone, but lesser candidates might be inclined to send envelopes full of grass to thank you for taking the time to interview them. This may, or may not, be received favorably, and one must realize the risks in making bold statements when interviewing candidates who may be subpar. Along those lines, I admit that in all my years of interviewing, I have found that there are interview questions that it is simply better not to ask: when do you come around next? (leads interviewee to think that he has advanced to a second interview), and how do you know he's a king? (leads to answers about SCOTT and MILLER with CONNECT BYs. Not at all the intended response). However, I think you're on the right track, if a bit early in the scene. Perhaps you'd consider What also floats in water?. Of course, there are multiple answers (e.g., apples, very small stones, mud, churches) which could arguably be deemed to show an acceptable level of knowledge, an ability to think outside the box, and an inventive approach, even if the salient points might not be wholly accurate. Even so, the correct answer (a duck) is technically not correct as it does not float, but swims (new scientific has determined this with a fair amount of accuracy), and I'd hate to hire a DBA who was stuck in old paradigms of science and/or technology. A CICS programmer, sure, but not a DBA. Now, if you'll just bring me a shrubbery, I can get on with my database analysis. Bambi. -Original Message- Sent: Friday, October 24, 2003 9:24 AM To: Multiple recipients of list ORACLE-L Cary Millsap scribbled on the wall in glitter crayon: Bambi, Be careful. Many will fall in love with you if you continue to submit such things as this to the list. how about: she turned me into a newt! a newt? i got better. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Behind an able man there are always other able men. - Chinese Proverb -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [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.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] 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: [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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] 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: [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: dba interview questions
I ask things like tell me the thing you've done that you are most proud of and tell me your nightmare situation and how did you recover from it Ans: My worst nightmare, my date pick her nose infront of me, I call cab infront of her. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] 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: [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: dba interview questions
Only two questions are required to ensure you get an appropriate person for the job (any job): 1) What do you think of David Bowie, is he brilliant or what ? and providing they answer the above question positively 2) Are you any good ? Works every time ;) Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 7:44 PM I ask things like tell me the thing you've done that you are most proud of and tell me your nightmare situation and how did you recover from it Ans: My worst nightmare, my date pick her nose infront of me, I call cab infront of her. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] 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: [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.net -- Author: Richard Foote INET: [EMAIL PROTECTED] 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: [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: dba interview questions
Only two questions are required to ensure you get an appropriate person for the job (any job): 1) What do you think of David Bowie, is he brilliant or what ? David who? Shall we sign the contracts now? ;) Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] 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: [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: dba interview questions
On 10/28/2003 06:59:24 AM, Richard Foote wrote: 1) What do you think of David Bowie, is he brilliant or what ? Or what. and providing they answer the above question positively 2) Are you any good ? I'm ad to the one. Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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: dba interview questions
You're likely to get the kind of response my kids would give: Wasn't he with the Beatles or the Stones or some other *old* band like that? Hell, my son considers the Offspring to be over the hill and Linkin Park as starting to lose it... About 7 years ago, I interviewed someone who listed Phish as one of his interests. I asked him What is Phish? and then spelled it for him. The expressions that swept across his face in one second ran from frank astonishment, to disbelief, to pity, to a carefully-composed poker face as he answered, A musical group that I like. Food for thought: when I was a kid in the 70s, my father would play his big band records and my brothers and I would roll our eyes and leave the house. Such lame, ancient music! At the time, those recordings were 30-35 years old... Um... For a kid today, the Stones, the Beatles, Pink Floyd, Frank Zappa, Yes, and Bowie are far more ancient. Not just in years, but the years do add up... ..'scuse me, I think I hear a bottle of Metamucil calling... on 10/28/03 4:59 AM, Richard Foote at [EMAIL PROTECTED] wrote: Only two questions are required to ensure you get an appropriate person for the job (any job): 1) What do you think of David Bowie, is he brilliant or what ? and providing they answer the above question positively 2) Are you any good ? Works every time ;) Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 7:44 PM I ask things like tell me the thing you've done that you are most proud of and tell me your nightmare situation and how did you recover from it Ans: My worst nightmare, my date pick her nose infront of me, I call cab infront of her. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] 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: [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.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] 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: [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: dba interview questions
I am shocked Tim you forgot Robbin Trower :-). -Original Message- Sent: Tuesday, October 28, 2003 7:09 AM To: Multiple recipients of list ORACLE-L You're likely to get the kind of response my kids would give: Wasn't he with the Beatles or the Stones or some other *old* band like that? Hell, my son considers the Offspring to be over the hill and Linkin Park as starting to lose it... About 7 years ago, I interviewed someone who listed Phish as one of his interests. I asked him What is Phish? and then spelled it for him. The expressions that swept across his face in one second ran from frank astonishment, to disbelief, to pity, to a carefully-composed poker face as he answered, A musical group that I like. Food for thought: when I was a kid in the 70s, my father would play his big band records and my brothers and I would roll our eyes and leave the house. Such lame, ancient music! At the time, those recordings were 30-35 years old... Um... For a kid today, the Stones, the Beatles, Pink Floyd, Frank Zappa, Yes, and Bowie are far more ancient. Not just in years, but the years do add up... ..'scuse me, I think I hear a bottle of Metamucil calling... on 10/28/03 4:59 AM, Richard Foote at [EMAIL PROTECTED] wrote: Only two questions are required to ensure you get an appropriate person for the job (any job): 1) What do you think of David Bowie, is he brilliant or what ? and providing they answer the above question positively 2) Are you any good ? Works every time ;) Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 7:44 PM I ask things like tell me the thing you've done that you are most proud of and tell me your nightmare situation and how did you recover from it Ans: My worst nightmare, my date pick her nose infront of me, I call cab infront of her. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] 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: [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.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] 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: [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.net -- Author: Conner, Bill INET: [EMAIL PROTECTED] 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: [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: dba interview questions
Give whisky, scotch and beer to Mladen and he'll be good -Original Message- Mladen Gogala Sent: 28 octobre, 2003 08:59 To: Multiple recipients of list ORACLE-L On 10/28/2003 06:59:24 AM, Richard Foote wrote: 1) What do you think of David Bowie, is he brilliant or what ? Or what. and providing they answer the above question positively 2) Are you any good ? I'm ad to the one. Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] 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: [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: dba interview questions
Oddly, I was thinking the same thing about Monty Python and the Holy Grail. And then I thought... NAAH. Grail is the only common denominator that I know of that all technical geeks have in common... but now that its some obscene number of years old, I've been on a quest to find another one... a non-Star Trek one, as Star Trek has so many adherents to various generations of it... Anyone? Bambi. -Original Message- Sent: Tuesday, October 28, 2003 8:09 AM To: Multiple recipients of list ORACLE-L You're likely to get the kind of response my kids would give: Wasn't he with the Beatles or the Stones or some other *old* band like that? Hell, my son considers the Offspring to be over the hill and Linkin Park as starting to lose it... About 7 years ago, I interviewed someone who listed Phish as one of his interests. I asked him What is Phish? and then spelled it for him. The expressions that swept across his face in one second ran from frank astonishment, to disbelief, to pity, to a carefully-composed poker face as he answered, A musical group that I like. Food for thought: when I was a kid in the 70s, my father would play his big band records and my brothers and I would roll our eyes and leave the house. Such lame, ancient music! At the time, those recordings were 30-35 years old... Um... For a kid today, the Stones, the Beatles, Pink Floyd, Frank Zappa, Yes, and Bowie are far more ancient. Not just in years, but the years do add up... ..'scuse me, I think I hear a bottle of Metamucil calling... on 10/28/03 4:59 AM, Richard Foote at [EMAIL PROTECTED] wrote: Only two questions are required to ensure you get an appropriate person for the job (any job): 1) What do you think of David Bowie, is he brilliant or what ? and providing they answer the above question positively 2) Are you any good ? Works every time ;) Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 7:44 PM I ask things like tell me the thing you've done that you are most proud of and tell me your nightmare situation and how did you recover from it Ans: My worst nightmare, my date pick her nose infront of me, I call cab infront of her. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] 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: [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.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] 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: [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.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] 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: [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: dba interview questions
Bellow, Bambi scribbled on the wall in glitter crayon: Oddly, I was thinking the same thing about Monty Python and the Holy Grail. And then I thought... NAAH. Grail is the only common denominator that I know of that all technical geeks have in common... but now that its some obscene number of years old, I've been on a quest to find another one... a non-Star Trek one, as Star Trek has so many adherents to various generations of it... Anyone? dust puppy and the one true ping? -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] The superior man is distressed by the limitation of his ability; he is not distressed by the fact that men do not recognize the ability he has. - Confucius -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [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: dba interview questions
How about Life of Brian? That's even better then the Holy Grail. On 10/28/2003 01:19:25 PM, Thater, William wrote: Bellow, Bambi scribbled on the wall in glitter crayon: Oddly, I was thinking the same thing about Monty Python and the Holy Grail. And then I thought... NAAH. Grail is the only common denominator that I know of that all technical geeks have in common... but now that its some obscene number of years old, I've been on a quest to find another one... a non-Star Trek one, as Star Trek has so many adherents to various generations of it... Anyone? dust puppy and the one true ping? -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] The superior man is distressed by the limitation of his ability; he is not distressed by the fact that men do not recognize the ability he has. - Confucius -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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: dba interview questions
Proud? landing a rock to fakie followed by a fakie 360 in near vertnot bad for a 41 yo Nightmare? Playing a particularly embarrasing gig with a manic dreppressive folk music ogre, 120 minutes of pure hell in front of an audience. I refused to play anymore gigs with him. Do I get the job...?? -Original Message- Sent: Tuesday, October 28, 2003 3:44 AM To: Multiple recipients of list ORACLE-L I ask things like tell me the thing you've done that you are most proud of and tell me your nightmare situation and how did you recover from it Ans: My worst nightmare, my date pick her nose infront of me, I call cab infront of her. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] 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: [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.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] 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: [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: dba interview questions
Ghostbusters? When someone asks if you're a god, you say 'YES'! ...and the flowers are still standing. Tell him about the Twinkie, Egon. Joe vs. The Volcano? Not a nice place you have here, Joe. I know he can get the job, but can he do the job? The Hunt for Red October? Be careful what you shoot at, Ryan. Most things in here don't react well to bullets. Next time, Jack, write a [gosh darn] memo. I said speak your mind, Jack, but geezus. One ping only. Come on, Big D, fly! Princess Bride? Have fun storming the castle! Did I make it clear that your job is at stake? Do you want me to send you back where you were -- unemployed in Greenland? Simpsons? Your manager says for you to shut up. And the weak and nerdy are admired for their computer programming ability. (OK, not a movie) Young Frankenstein? Throw the third switch! Not the THIRD switch! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 12:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: dba interview questions How about Life of Brian? That's even better then the Holy Grail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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: dba interview questions
Ah. Some time ago when running a Youth Group, I discovered that there is only one infallible answer when faced with a 'popular beat music combo, m'lud' that one has never heard of. This consist of nodding ones head sagely and saying ' ah yes, but don't you think that they've gone a bit commercial'. Works every time - even with groups that have only released 1 record that sold 42 copies. Rumour has it even David Bowie fans are fooled by this particular line. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Gorman Sent: 28 October 2003 14:09 To: Multiple recipients of list ORACLE-L Subject: Re: dba interview questions You're likely to get the kind of response my kids would give: Wasn't he with the Beatles or the Stones or some other *old* band like that? Hell, my son considers the Offspring to be over the hill and Linkin Park as starting to lose it... About 7 years ago, I interviewed someone who listed Phish as one of his interests. I asked him What is Phish? and then spelled it for him. The expressions that swept across his face in one second ran from frank astonishment, to disbelief, to pity, to a carefully-composed poker face as he answered, A musical group that I like. Food for thought: when I was a kid in the 70s, my father would play his big band records and my brothers and I would roll our eyes and leave the house. Such lame, ancient music! At the time, those recordings were 30-35 years old... Um... For a kid today, the Stones, the Beatles, Pink Floyd, Frank Zappa, Yes, and Bowie are far more ancient. Not just in years, but the years do add up... ..'scuse me, I think I hear a bottle of Metamucil calling... on 10/28/03 4:59 AM, Richard Foote at [EMAIL PROTECTED] wrote: Only two questions are required to ensure you get an appropriate person for the job (any job): 1) What do you think of David Bowie, is he brilliant or what ? and providing they answer the above question positively 2) Are you any good ? Works every time ;) Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 7:44 PM I ask things like tell me the thing you've done that you are most proud of and tell me your nightmare situation and how did you recover from it Ans: My worst nightmare, my date pick her nose infront of me, I call cab infront of her. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] 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: [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.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] 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: [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.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] 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: [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: dba interview questions
How about Dogma? That's a new movie and it is hillarious. Salma Hayek character was very impresive. On 10/28/2003 02:49:32 PM, Jesse, Rich wrote: Ghostbusters? When someone asks if you're a god, you say 'YES'! ...and the flowers are still standing. Tell him about the Twinkie, Egon. Joe vs. The Volcano? Not a nice place you have here, Joe. I know he can get the job, but can he do the job? The Hunt for Red October? Be careful what you shoot at, Ryan. Most things in here don't react well to bullets. Next time, Jack, write a [gosh darn] memo. I said speak your mind, Jack, but geezus. One ping only. Come on, Big D, fly! Princess Bride? Have fun storming the castle! Did I make it clear that your job is at stake? Do you want me to send you back where you were -- unemployed in Greenland? Simpsons? Your manager says for you to shut up. And the weak and nerdy are admired for their computer programming ability. (OK, not a movie) Young Frankenstein? Throw the third switch! Not the THIRD switch! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 12:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: dba interview questions How about Life of Brian? That's even better then the Holy Grail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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: dba interview questions
Bumper sticker sighted just the other day: My karma ran over your dogma How about Dogma? That's a new movie and it is hillarious. Salma Hayek character was very impresive. On 10/28/2003 02:49:32 PM, Jesse, Rich wrote: Ghostbusters? When someone asks if you're a god, you say 'YES'! ...and the flowers are still standing. Tell him about the Twinkie, Egon. Joe vs. The Volcano? Not a nice place you have here, Joe. I know he can get the job, but can he do the job? The Hunt for Red October? Be careful what you shoot at, Ryan. Most things in here don't react well to bullets. Next time, Jack, write a [gosh darn] memo. I said speak your mind, Jack, but geezus. One ping only. Come on, Big D, fly! Princess Bride? Have fun storming the castle! Did I make it clear that your job is at stake? Do you want me to send you back where you were -- unemployed in Greenland? Simpsons? Your manager says for you to shut up. And the weak and nerdy are admired for their computer programming ability. (OK, not a movie) Young Frankenstein? Throw the third switch! Not the THIRD switch! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 12:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: dba interview questions How about Life of Brian? That's even better then the Holy Grail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] 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: [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: dba interview questions
-Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Wednesday, 29 October 2003 05:44 To: Multiple recipients of list ORACLE-L Subject: Re: dba interview questions How about Life of Brian? That's even better then the Holy Grail. You're right, Mladen ... because we're all individuals. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] 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: [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: dba interview questions
Better still, sometimes 'X' takes the questions while 'Y' the candidate just stands next to him because 'X' can answer but Y does not. Tel.int means you (most probably) have not seen the guys face..correct?? By the time Visa gets approved (if overseas candidate), 'Y' ensures that he 'gains' some experience. GovindanK <-Original Message-> Sent: 10/24/2003 7:45:29 AM To: [EMAIL PROTECTED] Oh! Well. I have not seen Tom's book yet. But still, when the candidate is explaining this stuff to you, there are plenty of opps to question him/her to find out if he/she really knows fundamental things.. During one phone interview, we could clearly hear the paper shuffle in the background, while the candidate asked us to repeat the question (a couple of times) to 'make sure' he understood it correctly before answering (reading?)it :) We stopped phone interview process after this!! - Kirti --- [EMAIL PROTECTED] wrote: > that question is diagrammed and answered in tom kytes new book. :) im waiting to get asked it. > > there is a new ault book out on interview questions. I dont think they are very tough. I think > situational questions are better. Have a development DB set up with things for the applicant to > do. > > I find that most employers ask the same easy questions. Particularly developer questions > > > --- system manager <[EMAIL PROTECTED]> wrote: > Dear List, Can anyone send me a list of dba interview questions? > > Thanks, > > ___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!
RE: dba interview questions
Kirti -- I've had that experience too. I generally start a telephone interview hopping around the person's resume and asking questions about individual jobs... what did they do here... what do they mean by that there what was the environment over there... was management supportive in that job over there... now let's talk about the technical side of things... because there's no way to tell whether you are talking to the person who's going in for the F2F over the phone... Notice that nowhere in there is any reference to swallows. That comes later in the interview when you want to discern whether this is established knowledge or just crammed 30 minutes before the phone is supposed to ring. Bambi. -Original Message-From: Govindan K [mailto:[EMAIL PROTECTED]Sent: Tuesday, October 28, 2003 4:35 PMTo: Multiple recipients of list ORACLE-LSubject: Re: dba interview questionsBetter still, sometimes 'X' takes the questions while 'Y' the candidate just stands next to himbecause 'X' can answer but Y does not. Tel.int means you (most probably) have not seen the guys face..correct??By the time Visa gets approved (if overseas candidate), 'Y' ensures that he 'gains' some experience.GovindanK-Original Message- Sent: 10/24/2003 7:45:29 AMTo: [EMAIL PROTECTED]Oh! Well. I have not seen Tom's book yet. But still, when the candidate is explaining this stuff to you, there are plenty of opps toquestion him/her to find out if he/she really knows fundamental things..During one phone interview, we could clearly hear the paper shuffle in the background, while thecandidate asked us to repeat the question (a couple of times) to 'make sure' he understood itcorrectly before answering (reading?)it :) We stopped phone interview process after this!! - Kirti--- [EMAIL PROTECTED] wrote: that question is diagrammed and answered in tom kytes new book. :) im waiting to get asked it. there is a new ault book out on interview questions. I dont think they are very tough. I think situational questions are better. Have a development DB set up with things for the applicant to do. I find that most employers ask the same easy questions. Particularly developer questions--- system manager <[EMAIL PROTECTED]>wrote: Dear List, Can anyone send me a list of dba interview questions? Thanks, ___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!
RE: dba interview questions
Please kill this thread, as it no longer has anything to do with DBA interview questions. Schilling, Ben [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/28/2003 02:29 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: dba interview questions Another bumper sticker seen today: That was Zen, this is Tao. -Original Message- Sent: Tuesday, October 28, 2003 4:20 PM To: Multiple recipients of list ORACLE-L Bumper sticker sighted just the other day: My karma ran over your dogma How about Dogma? That's a new movie and it is hillarious. Salma Hayek character was very impresive. On 10/28/2003 02:49:32 PM, Jesse, Rich wrote: Ghostbusters? When someone asks if you're a god, you say 'YES'! ...and the flowers are still standing. Tell him about the Twinkie, Egon. Joe vs. The Volcano? Not a nice place you have here, Joe. I know he can get the job, but can he do the job? The Hunt for Red October? Be careful what you shoot at, Ryan. Most things in here don't react well to bullets. Next time, Jack, write a [gosh darn] memo. I said speak your mind, Jack, but geezus. One ping only. Come on, Big D, fly! Princess Bride? Have fun storming the castle! Did I make it clear that your job is at stake? Do you want me to send you back where you were -- unemployed in Greenland? Simpsons? Your manager says for you to shut up. And the weak and nerdy are admired for their computer programming ability. (OK, not a movie) Young Frankenstein? Throw the third switch! Not the THIRD switch! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 12:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: dba interview questions How about Life of Brian? That's even better then the Holy Grail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] 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: [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
RE: dba interview questions
Another bumper sticker seen today: That was Zen, this is Tao. -Original Message- Sent: Tuesday, October 28, 2003 4:20 PM To: Multiple recipients of list ORACLE-L Bumper sticker sighted just the other day: My karma ran over your dogma How about Dogma? That's a new movie and it is hillarious. Salma Hayek character was very impresive. On 10/28/2003 02:49:32 PM, Jesse, Rich wrote: Ghostbusters? When someone asks if you're a god, you say 'YES'! ...and the flowers are still standing. Tell him about the Twinkie, Egon. Joe vs. The Volcano? Not a nice place you have here, Joe. I know he can get the job, but can he do the job? The Hunt for Red October? Be careful what you shoot at, Ryan. Most things in here don't react well to bullets. Next time, Jack, write a [gosh darn] memo. I said speak your mind, Jack, but geezus. One ping only. Come on, Big D, fly! Princess Bride? Have fun storming the castle! Did I make it clear that your job is at stake? Do you want me to send you back where you were -- unemployed in Greenland? Simpsons? Your manager says for you to shut up. And the weak and nerdy are admired for their computer programming ability. (OK, not a movie) Young Frankenstein? Throw the third switch! Not the THIRD switch! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 12:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: dba interview questions How about Life of Brian? That's even better then the Holy Grail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] 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: [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.net -- Author: Schilling, Ben INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: dba interview questions
Bill -- I appreciate your input to this very complex question. IMHO, however, she turned me into a newt! is, technically, an interview *statement* rather than an interview *question*. That being said, it can be used at the beginning or end of the interview to set tone, but lesser candidates might be inclined to send envelopes full of grass to thank you for taking the time to interview them. This may, or may not, be received favorably, and one must realize the risks in making bold statements when interviewing candidates who may be subpar. Along those lines, I admit that in all my years of interviewing, I have found that there are interview questions that it is simply better not to ask: when do you come around next? (leads interviewee to think that he has advanced to a second interview), and how do you know he's a king? (leads to answers about SCOTT and MILLER with CONNECT BYs. Not at all the intended response). However, I think you're on the right track, if a bit early in the scene. Perhaps you'd consider What also floats in water?. Of course, there are multiple answers (e.g., apples, very small stones, mud, churches) which could arguably be deemed to show an acceptable level of knowledge, an ability to think outside the box, and an inventive approach, even if the salient points might not be wholly accurate. Even so, the correct answer (a duck) is technically not correct as it does not float, but swims (new scientific has determined this with a fair amount of accuracy), and I'd hate to hire a DBA who was stuck in old paradigms of science and/or technology. A CICS programmer, sure, but not a DBA. Now, if you'll just bring me a shrubbery, I can get on with my database analysis. Bambi. -Original Message- Sent: Friday, October 24, 2003 9:24 AM To: Multiple recipients of list ORACLE-L Cary Millsap scribbled on the wall in glitter crayon: Bambi, Be careful. Many will fall in love with you if you continue to submit such things as this to the list. how about: she turned me into a newt! a newt? i got better. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Behind an able man there are always other able men. - Chinese Proverb -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [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.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] 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: [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: dba interview questions
Nope - you will get the diagram and basic description in Tom's book (and of course the Concepts manual) but that's not the idea of using this for an interview. As they (hopefully) draw the SGA you can drift into musings like: So - if all these changes are in memory - how do we ensure against not losing data if we have a power failure That (hopefully) leads us onto redo logs, which leads to more musings: But if we've only get three - what happens when all three are full , or if they're good - there is no such thing as full for a file - how does oracle 'know' that the redo is full etc etc etc... If its a production role - you simply head down the path that most appropriate for that. If its development, you start heading down other paths (say) when they talk about library cache ... eg parsing, blah blah blah... And perhaps the best thing is, you'll easily get to detect the honesty rating. Sometimes the best answer is I have no f...ing idea. That's fine with me, and so much better than a load of BS. The saddest thing I did last week was conduct 10 or so interviews (for developers, not DBA's). Not a single one could answer the question: What is a bind variable and explain its significance to Oracle :-( A couple gave me the time honoured answer of: Hmmm, yes, I used them in my last project but cannot quite remember the specificsspare me please Cheers Connor --- [EMAIL PROTECTED] wrote: that question is diagrammed and answered in tom kytes new book. :) im waiting to get asked it. there is a new ault book out on interview questions. I dont think they are very tough. I think situational questions are better. Have a development DB set up with things for the applicant to do. I find that most employers ask the same easy questions. Particularly developer questions From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 09:49:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: dba interview questions The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] 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: [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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http
RE: dba interview questions
A French or English Swallow? -Original Message- Sent: Thursday, October 23, 2003 5:39 PM To: Multiple recipients of list ORACLE-L Mladen -- I'm *stunned* you missed the most obvious of all DBA 101 questions... What is the average air velocity of an unladen swallow? Bambi. -Original Message- Sent: Thursday, October 23, 2003 4:14 PM To: Multiple recipients of list ORACLE-L 1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] 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: [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.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] 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: [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: dba interview questions
The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] 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: [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: dba interview questions
Bellow, Bambi scribbled on the wall in glitter crayon: Mladen -- I'm *stunned* you missed the most obvious of all DBA 101 questions... What is the average air velocity of an unladen swallow? African or European?;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Experiments before 1880 showed that light always travels athe the same speed relative to you, no matter how you were moving - basis for Einsteins axiom on moving observers. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [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: dba interview questions
Title: RE: dba interview questions That's the inherent problem with using those kinds of lists and books is that both sets of people can read and glean. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: Kirtikumar Deshpande [mailto:[EMAIL PROTECTED]] Sent: Friday, October 24, 2003 8:49 AM To: Multiple recipients of list ORACLE-L Subject: Re: dba interview questions The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List, Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] 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: [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). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
RE: dba interview questions
Cary Millsap scribbled on the wall in glitter crayon: Bambi, Be careful. Many will fall in love with you if you continue to submit such things as this to the list. how about: she turned me into a newt! a newt? i got better. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Behind an able man there are always other able men. - Chinese Proverb -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [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: dba interview questions
that question is diagrammed and answered in tom kytes new book. :) im waiting to get asked it. there is a new ault book out on interview questions. I dont think they are very tough. I think situational questions are better. Have a development DB set up with things for the applicant to do. I find that most employers ask the same easy questions. Particularly developer questions From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 09:49:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: dba interview questions The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] 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: [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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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: dba interview questions
Pre-packaged questions are always a bad idea. When a company needs a DBA, it should know what do they need him for. Do they need them to monitor and troubleshoot production database and ensure the availability of the database, or help developers, or lead the database related projects or to help clients and install software or mop the floors and grind coffee? The abbreviation DBA can be applied to the great variety of business roles, some of which are mutually exclusive. Cary Millsap is using terms performance analyst and performance related projects. Traditionally, companies do not have performance analysts, they have DBA's performing this function. The abbreviation DBA came to mean almos anything short of performing brain surgery. To make a long story short, the company looking for a DBA should know what specific job functions are they interested in, what specific skills are needed to perform the required job functions and adjust the the interviewing process. For instance, if you need a DBA to go and help your clients, then driver's license would be a requirement. Sounds trivial, but I know a lot of folks from NYC that don't drive and don't have driver's license. Generally speaking, driver's license is not a requirement for the DBA position, but sometimes, it can be. On 10/24/2003 09:49:26 AM, Kirtikumar Deshpande wrote: The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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: dba interview questions
Oh! Well. I have not seen Tom's book yet. But still, when the candidate is explaining this stuff to you, there are plenty of opps to question him/her to find out if he/she really knows fundamental things.. During one phone interview, we could clearly hear the paper shuffle in the background, while the candidate asked us to repeat the question (a couple of times) to 'make sure' he understood it correctly before answering (reading?)it :) We stopped phone interview process after this!! - Kirti --- [EMAIL PROTECTED] wrote: that question is diagrammed and answered in tom kytes new book. :) im waiting to get asked it. there is a new ault book out on interview questions. I dont think they are very tough. I think situational questions are better. Have a development DB set up with things for the applicant to do. I find that most employers ask the same easy questions. Particularly developer questions From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 09:49:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: dba interview questions The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] 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: [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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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). __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] 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: [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: dba interview questions
Mladen Gogala scribbled on the wall in glitter crayon: Pre-packaged questions are always a bad idea. When a company needs a DBA, it should know what do they need him for. Do they need them to but that would provide that the company actually know how to define job duties and then convey them to HR who would then be able to screen applicants on actual experience and not just groups of letters. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] One had to cram all this stuff into one's mind for the examinations, whether one liked it or not. This coercion had such a deterring effect on me that, after I had passed the final examination, I found the consideration of any scientific problems distasteful to me for an entire year. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [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: dba interview questions
wait, the people you interview can read? :) we've had this discussion off and on on this list over the last few years. I've been on interviews where one of the questions was about what display setting I needed to make in order to do an install. This is Oracle? This is also documented in the install guide. a better question would have been what are the steps you take before doing an install? Standardized tests have standardized answers. The tests end up published (or the interviewees publish the questions) and you get OCP. I ask things like tell me the thing you've done that you are most proud of and tell me your nightmare situation and how did you recover from it --- April Wells [EMAIL PROTECTED] wrote: That's the inherent problem with using those kinds of lists and books is that both sets of people can read and glean. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- Sent: Friday, October 24, 2003 8:49 AM To: Multiple recipients of list ORACLE-L The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] 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: [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). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [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: dba interview questions
Ryan Would that diagram be in Effective Oracle by Design by Tom Kyte? Can you elaborate? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 24, 2003 9:29 AM To: Multiple recipients of list ORACLE-L that question is diagrammed and answered in tom kytes new book. :) im waiting to get asked it. there is a new ault book out on interview questions. I dont think they are very tough. I think situational questions are better. Have a development DB set up with things for the applicant to do. I find that most employers ask the same easy questions. Particularly developer questions From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 09:49:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: dba interview questions The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] 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: [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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [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: dba interview questions
We prefer to ask their experiences and then throw a curve ball and ask them to defend it. Small issues like Why would/wouldn't an index help? etc ... Another question that I *always* ask is what do you or have you read in last 3 months outside of Oracle manuals? or Do you know any other sites that give you lot of oracle related information? I expect to hear at-least couple form following list ... ixora, hotsos, jlcomp, oracle-dba, oraperf, orapub. If they mention that they have read YAPP, that's a bonus too. But if someone says they haven't read anything other than manuals questions become a little steep. Raj -Original Message- Sent: Friday, October 24, 2003 9:49 AM To: Multiple recipients of list ORACLE-L The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] 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: [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: dba interview questions
On 10/24/2003 11:04:34 AM, Thater, William wrote: but that would provide that the company actually know how to define job duties and then convey them to HR who would then be able to screen applicants on actual experience and not just groups of letters. Now we are talking about the job description for damagement. HR is usually perfectly capable of picking the best candidate, the one with the most expensive suit, groundless self-confidence and least amount of knowledge or management capabilities. Racial, gender and religious prejudices are usually a plus. Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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: dba interview questions
Bill So you are an HR person with a well-written job description in hand and a stack of resumes on the other (how may would you say a job posting would garner today -- 200?) It has been a long week of major and minor employee issues and the hiring manager has begun making ugly noises about when am I going to see some candidates?. So you stuff the whole stack in your briefcase with the illusion of a nice quiet evening to get some solitude to really go through these resumes. But there are issues with your teenage daughter and your wife's reaction to these issues, and you glance at your watch, see it is 9 pm. and realize you meant to go through those resumes. So you sit down, read the job description once, looks like Greek, read it again, no better. Now you pick up the first resume and try to relate the words on the job description to the candidate's experience. You say to yourself, hmm . . this is going to be a long evening. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 24, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Mladen Gogala scribbled on the wall in glitter crayon: Pre-packaged questions are always a bad idea. When a company needs a DBA, it should know what do they need him for. Do they need them to but that would provide that the company actually know how to define job duties and then convey them to HR who would then be able to screen applicants on actual experience and not just groups of letters. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] One had to cram all this stuff into one's mind for the examinations, whether one liked it or not. This coercion had such a deterring effect on me that, after I had passed the final examination, I found the consideration of any scientific problems distasteful to me for an entire year. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [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: dba interview questions
its in the first book expert one on one. he talks about it on his webpage. its also in the concepts document. its just a diagram of oracle and the background processes. he says its the weeding out question he asks. maybe 1 in 10 get it right. From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 11:29:25 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Re: dba interview questions Ryan Would that diagram be in Effective Oracle by Design by Tom Kyte? Can you elaborate? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 24, 2003 9:29 AM To: Multiple recipients of list ORACLE-L that question is diagrammed and answered in tom kytes new book. :) im waiting to get asked it. there is a new ault book out on interview questions. I dont think they are very tough. I think situational questions are better. Have a development DB set up with things for the applicant to do. I find that most employers ask the same easy questions. Particularly developer questions From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 09:49:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: dba interview questions The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] 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: [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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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: dba interview questions
That's more like it. The recent postings re this thread got too serious and all suffered from the same fatal flaw - they assumed that the interviewer knows something about Oracle database administration. But then you don't need a list of interview questions. Those lists are for interviewers who know nothing about the job they are interviewing for, which is why they do not only need a list of questions, but also the cheat sheet with the answers. I like Bambi's question the best. At 09:44 AM 10/24/2003, you wrote: On 10/24/2003 11:04:34 AM, Thater, William wrote: but that would provide that the company actually know how to define job duties and then convey them to HR who would then be able to screen applicants on actual experience and not just groups of letters. Now we are talking about the job description for damagement. HR is usually perfectly capable of picking the best candidate, the one with the most expensive suit, groundless self-confidence and least amount of knowledge or management capabilities. Racial, gender and religious prejudices are usually a plus. Mladen Gogala Oracle DBA Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] 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: [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: dba interview questions
Let me continue the story. Around 11PM you want to watch a movie, so you decide to pick a few candidates, according to their letterheads, the overall outlook of the resume , resounding company names that they worked for (no matter in what capacity), the school they attended and the overall physical appearance, if such information is available. You also remember that John, the guy you play poker with has intervened in favor of one of the candidates. The short list of candidates is assembled, with your friend's candidate on top. You remember that the hiring manager owes you a favor and, voila, the fresh DBA is here! On 10/24/2003 11:54:32 AM, DENNIS WILLIAMS wrote: Bill So you are an HR person with a well-written job description in hand and a stack of resumes on the other (how may would you say a job posting would garner today -- 200?) It has been a long week of major and minor employee issues and the hiring manager has begun making ugly noises about when am I going to see some candidates?. So you stuff the whole stack in your briefcase with the illusion of a nice quiet evening to get some solitude to really go through these resumes. But there are issues with your teenage daughter and your wife's reaction to these issues, and you glance at your watch, see it is 9 pm. and realize you meant to go through those resumes. So you sit down, read the job description once, looks like Greek, read it again, no better. Now you pick up the first resume and try to relate the words on the job description to the candidate's experience. You say to yourself, hmm . . this is going to be a long evening. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 24, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Mladen Gogala scribbled on the wall in glitter crayon: Pre-packaged questions are always a bad idea. When a company needs a DBA, it should know what do they need him for. Do they need them to but that would provide that the company actually know how to define job duties and then convey them to HR who would then be able to screen applicants on actual experience and not just groups of letters. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] One had to cram all this stuff into one's mind for the examinations, whether one liked it or not. This coercion had such a deterring effect on me that, after I had passed the final examination, I found the consideration of any scientific problems distasteful to me for an entire year. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City
Re: RE: dba interview questions
not sure i like the 'read outside the oracle manuals'. I find that alot of people read alot of really bad books and then dont read the stuff on OTN. oracle has very good docs. I do have a beef over lack of syntax examples... From: Jamadagni, Rajendra [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 11:39:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: dba interview questions We prefer to ask their experiences and then throw a curve ball and ask them to defend it. Small issues like Why would/wouldn't an index help? etc ... Another question that I *always* ask is what do you or have you read in last 3 months outside of Oracle manuals? or Do you know any other sites that give you lot of oracle related information? I expect to hear at-least couple form following list ... ixora, hotsos, jlcomp, oracle-dba, oraperf, orapub. If they mention that they have read YAPP, that's a bonus too. But if someone says they haven't read anything other than manuals questions become a little steep. Raj -Original Message- Sent: Friday, October 24, 2003 9:49 AM To: Multiple recipients of list ORACLE-L The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] 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: [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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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: dba interview questions
do any of you ask dbas pl/sql questions? I think its important for DBAs to be good developers as well. especially if they are part of a development team. I dont think the skill sets should be seperate. they overlap. From: Jamadagni, Rajendra [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 11:39:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: dba interview questions We prefer to ask their experiences and then throw a curve ball and ask them to defend it. Small issues like Why would/wouldn't an index help? etc ... Another question that I *always* ask is what do you or have you read in last 3 months outside of Oracle manuals? or Do you know any other sites that give you lot of oracle related information? I expect to hear at-least couple form following list ... ixora, hotsos, jlcomp, oracle-dba, oraperf, orapub. If they mention that they have read YAPP, that's a bonus too. But if someone says they haven't read anything other than manuals questions become a little steep. Raj -Original Message- Sent: Friday, October 24, 2003 9:49 AM To: Multiple recipients of list ORACLE-L The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] 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: [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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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: dba interview questions
Ask them what their daily, weekly, and monthly procedures are. How do they accomplish them? Do they have an example of their daily checklist (or can they generate it from memory)? Kirtikumar DeshpandeTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] kirtikumar_desh cc: pandeSubject: Re: dba interview questions @yahoo.com Sent by: ml-errors 10/24/2003 09:49 AM Please respond to ORACLE-L The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] 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: [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.net -- Author: Thomas Day INET: [EMAIL PROTECTED] 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: [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: dba interview questions
I have had a couple of interviews for Oracle DBA jobs where they pull out a list of technical questions about the most minor items you can think of. Being able to answer them indicates how good a person's grey brain cells are at memorizing trivia. They do not measure a persons ability to problem solve which is a skill that I think a company would be interested in when hiring a DBA! My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 24, 2003 9:39 AM Pre-packaged questions are always a bad idea. When a company needs a DBA, it should know what do they need him for. Do they need them to monitor and troubleshoot production database and ensure the availability of the database, or help developers, or lead the database related projects or to help clients and install software or mop the floors and grind coffee? The abbreviation DBA can be applied to the great variety of business roles, some of which are mutually exclusive. Cary Millsap is using terms performance analyst and performance related projects. Traditionally, companies do not have performance analysts, they have DBA's performing this function. The abbreviation DBA came to mean almos anything short of performing brain surgery. To make a long story short, the company looking for a DBA should know what specific job functions are they interested in, what specific skills are needed to perform the required job functions and adjust the the interviewing process. For instance, if you need a DBA to go and help your clients, then driver's license would be a requirement. Sounds trivial, but I know a lot of folks from NYC that don't drive and don't have driver's license. Generally speaking, driver's license is not a requirement for the DBA position, but sometimes, it can be. On 10/24/2003 09:49:26 AM, Kirtikumar Deshpande wrote: The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing
RE: RE: dba interview questions
Sure do, here's my favorite: You have a database with 3000 registered users, you need to lock all accounts except for a list of 20. How would you do it? Obviously there's several correct answers. But the one I'm looking for is the anonymous PL/SQL block defined like: declare stmt varchar2(200); begin for a in (select username from dba_users where username not in ('SYS','SYSTEM',...)) loop stmt := 'alter user '||a.username||' account lock'; execute immediate stmt; end loop; end; / Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, October 24, 2003 12:00 PM To: Multiple recipients of list ORACLE-L do any of you ask dbas pl/sql questions? I think its important for DBAs to be good developers as well. especially if they are part of a development team. I dont think the skill sets should be seperate. they overlap. From: Jamadagni, Rajendra [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 11:39:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: dba interview questions We prefer to ask their experiences and then throw a curve ball and ask them to defend it. Small issues like Why would/wouldn't an index help? etc ... Another question that I *always* ask is what do you or have you read in last 3 months outside of Oracle manuals? or Do you know any other sites that give you lot of oracle related information? I expect to hear at-least couple form following list ... ixora, hotsos, jlcomp, oracle-dba, oraperf, orapub. If they mention that they have read YAPP, that's a bonus too. But if someone says they haven't read anything other than manuals questions become a little steep. Raj -Original Message- Sent: Friday, October 24, 2003 9:49 AM To: Multiple recipients of list ORACLE-L The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] 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: [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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] 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: [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
RE: RE: dba interview questions
What do you need the stmt for? Just do: begin for a in (select username from dba_users where username not in ('SYS','SYSTEM',...)) loop execute immediate 'alter user '||a.username||' account lock'; end loop; end; / Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Sent: Friday, October 24, 2003 2:00 PM To: Multiple recipients of list ORACLE-L Sure do, here's my favorite: You have a database with 3000 registered users, you need to lock all accounts except for a list of 20. How would you do it? Obviously there's several correct answers. But the one I'm looking for is the anonymous PL/SQL block defined like: declare stmt varchar2(200); begin for a in (select username from dba_users where username not in ('SYS','SYSTEM',...)) loop stmt := 'alter user '||a.username||' account lock'; execute immediate stmt; end loop; end; / Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, October 24, 2003 12:00 PM To: Multiple recipients of list ORACLE-L do any of you ask dbas pl/sql questions? I think its important for DBAs to be good developers as well. especially if they are part of a development team. I dont think the skill sets should be seperate. they overlap. From: Jamadagni, Rajendra [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 11:39:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: dba interview questions We prefer to ask their experiences and then throw a curve ball and ask them to defend it. Small issues like Why would/wouldn't an index help? etc ... Another question that I *always* ask is what do you or have you read in last 3 months outside of Oracle manuals? or Do you know any other sites that give you lot of oracle related information? I expect to hear at-least couple form following list ... ixora, hotsos, jlcomp, oracle-dba, oraperf, orapub. If they mention that they have read YAPP, that's a bonus too. But if someone says they haven't read anything other than manuals questions become a little steep. Raj -Original Message- Sent: Friday, October 24, 2003 9:49 AM To: Multiple recipients of list ORACLE-L The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] 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: [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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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.net -- Author: Goulet, Dick INET: [EMAIL
RE: RE: dba interview questions
Heck, Our helpdesk doesn't even reset passwords!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, October 24, 2003 3:04 PM To: Multiple recipients of list ORACLE-L I would have answered: I'd send the list to the help desk as they take care of logins and tell them to lock all accounts except the list I send. What is it you say?? your help desk doesn't do that? Tsk, tsk, tsk... hehehe -Original Message- Sent: Friday, October 24, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Sure do, here's my favorite: You have a database with 3000 registered users, you need to lock all accounts except for a list of 20. How would you do it? Obviously there's several correct answers. But the one I'm looking for is the anonymous PL/SQL block defined like: declare stmt varchar2(200); begin for a in (select username from dba_users where username not in ('SYS','SYSTEM',...)) loop stmt := 'alter user '||a.username||' account lock'; execute immediate stmt; end loop; end; / Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, October 24, 2003 12:00 PM To: Multiple recipients of list ORACLE-L do any of you ask dbas pl/sql questions? I think its important for DBAs to be good developers as well. especially if they are part of a development team. I dont think the skill sets should be seperate. they overlap. From: Jamadagni, Rajendra [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 11:39:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: dba interview questions We prefer to ask their experiences and then throw a curve ball and ask them to defend it. Small issues like Why would/wouldn't an index help? etc ... Another question that I *always* ask is what do you or have you read in last 3 months outside of Oracle manuals? or Do you know any other sites that give you lot of oracle related information? I expect to hear at-least couple form following list ... ixora, hotsos, jlcomp, oracle-dba, oraperf, orapub. If they mention that they have read YAPP, that's a bonus too. But if someone says they haven't read anything other than manuals questions become a little steep. Raj -Original Message- Sent: Friday, October 24, 2003 9:49 AM To: Multiple recipients of list ORACLE-L The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] 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: [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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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.net -- Author: Goulet, Dick INET: [EMAIL
RE: Re: dba interview questions
Title: RE: Re: dba interview questions and at least if someone takes the time to read a book and get the whole picture, they have some kind of gumshun. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: Kirtikumar Deshpande [mailto:[EMAIL PROTECTED]] Sent: Friday, October 24, 2003 9:44 AM To: Multiple recipients of list ORACLE-L Subject: Re: Re: dba interview questions Oh! Well. I have not seen Tom's book yet. But still, when the candidate is explaining this stuff to you, there are plenty of opps to question him/her to find out if he/she really knows fundamental things.. During one phone interview, we could clearly hear the paper shuffle in the background, while the candidate asked us to repeat the question (a couple of times) to 'make sure' he understood it correctly before answering (reading?)it :) We stopped phone interview process after this!! - Kirti --- [EMAIL PROTECTED] wrote: that question is diagrammed and answered in tom kytes new book. :) im waiting to get asked it. there is a new ault book out on interview questions. I dont think they are very tough. I think situational questions are better. Have a development DB set up with things for the applicant to do. I find that most employers ask the same easy questions. Particularly developer questions From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 09:49:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: dba interview questions The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List, Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] 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: [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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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). __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] 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: [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). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged
RE: dba interview questions
Indeed. We all have our thing that we like to focus on. When I hire someone, I'm more interested in the program running in someone's head than I am in the data segment that's stored in there. The far-and-away best interviewing material I've ever seen is the Effective Interviewing! stuff written by Jim Kennedy and Anna Everest, which you can read about at http://www.interviewedge.com/. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - SQL Optimization 101: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- KENNETH JANUSZ Sent: Friday, October 24, 2003 10:09 AM To: Multiple recipients of list ORACLE-L I have had a couple of interviews for Oracle DBA jobs where they pull out a list of technical questions about the most minor items you can think of. Being able to answer them indicates how good a person's grey brain cells are at memorizing trivia. They do not measure a persons ability to problem solve which is a skill that I think a company would be interested in when hiring a DBA! My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 24, 2003 9:39 AM Pre-packaged questions are always a bad idea. When a company needs a DBA, it should know what do they need him for. Do they need them to monitor and troubleshoot production database and ensure the availability of the database, or help developers, or lead the database related projects or to help clients and install software or mop the floors and grind coffee? The abbreviation DBA can be applied to the great variety of business roles, some of which are mutually exclusive. Cary Millsap is using terms performance analyst and performance related projects. Traditionally, companies do not have performance analysts, they have DBA's performing this function. The abbreviation DBA came to mean almos anything short of performing brain surgery. To make a long story short, the company looking for a DBA should know what specific job functions are they interested in, what specific skills are needed to perform the required job functions and adjust the the interviewing process. For instance, if you need a DBA to go and help your clients, then driver's license would be a requirement. Sounds trivial, but I know a lot of folks from NYC that don't drive and don't have driver's license. Generally speaking, driver's license is not a requirement for the DBA position, but sometimes, it can be. On 10/24/2003 09:49:26 AM, Kirtikumar Deshpande wrote: The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail
Re[2]: dba interview questions
Friday, October 24, 2003, 9:49:26 AM, Kirti wrote: KD Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA KD with all it interal structures, all background processes, and explain how all this works KD together. That's not a half-bad idea. Of possibly more importance than whether they could draw that diagram perfectly might be their thought-process as they tried to fill in the pieces that they don't quite remember. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] 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: [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: dba interview questions
I'm actually appending to Kirti's answer below here. Before my students receive a passing grade in my class, they are required to do exactly what Kirti and Connor have laid out. They must each do this as part of their final exam. Most of them have no difficulty. When they ask me how they should prepare for an interview, I've often told them that if they are not asked to stand up to a white board and lay everything out, they should offer to. Most of them do, and oftentimes they get the job, or they are told that they were one of the top five candidates. And to also add to Rachel's point, I tell them to carefully listen to any technical knowledge displayed by their hiring manager (if this is the person they are interviewing with). I once interviewed with someone who asked me to solve a potential problem they were currently having with their database. He told me they had recently added several indexes to such-and-such tables for such-and-such application, and it was *still* slow. I took a brief look and saw no statistics. I asked him if he had ever analyzed his tables or indexes. He told me they created explain plans all the time and still could not locate the problem. I asked him if he was using the cost-based optimizer. He informed me that he was not. He was in fact using optimizer=CHOOSE Yeah, you see where this is going. I ended up taking a job with a different company. I tell my students, that even if they are offered a job (and this is less potent advice in a failing economy) if at all possible, try to work for a person who is just as, if not more, knowledgeable than you are. If your boss is a good mentor you have a great potential to grow and further your knowledge. And if not, well, you could end up with the situation above. So, for the system manager who originally started this thread, hopefully you are just as knowledgeable as the candidates you hope to obtain? Or, you are forwarding the candidates on to someone who is? -Original Message- Rachel Carmichael Sent: Friday, October 24, 2003 11:10 AM To: Multiple recipients of list ORACLE-L wait, the people you interview can read? :) we've had this discussion off and on on this list over the last few years. I've been on interviews where one of the questions was about what display setting I needed to make in order to do an install. This is Oracle? This is also documented in the install guide. a better question would have been what are the steps you take before doing an install? Standardized tests have standardized answers. The tests end up published (or the interviewees publish the questions) and you get OCP. I ask things like tell me the thing you've done that you are most proud of and tell me your nightmare situation and how did you recover from it --- April Wells [EMAIL PROTECTED] wrote: That's the inherent problem with using those kinds of lists and books is that both sets of people can read and glean. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- Sent: Friday, October 24, 2003 8:49 AM To: Multiple recipients of list ORACLE-L The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] 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: [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). The information contained
RE: dba interview questions
I've been in the position for over 10 years now in which this was a candidate algorithm for making decisions. It doesn't work. If you make decisions this way, you'll ultimately lose your good employees, your job, or--if it's not stopped--your whole business. It just doesn't work, because to survive in business you have to be *competitive*. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - SQL Optimization 101: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Mladen Gogala Sent: Friday, October 24, 2003 11:40 AM To: Multiple recipients of list ORACLE-L Let me continue the story. Around 11PM you want to watch a movie, so you decide to pick a few candidates, according to their letterheads, the overall outlook of the resume , resounding company names that they worked for (no matter in what capacity), the school they attended and the overall physical appearance, if such information is available. You also remember that John, the guy you play poker with has intervened in favor of one of the candidates. The short list of candidates is assembled, with your friend's candidate on top. You remember that the hiring manager owes you a favor and, voila, the fresh DBA is here! On 10/24/2003 11:54:32 AM, DENNIS WILLIAMS wrote: Bill So you are an HR person with a well-written job description in hand and a stack of resumes on the other (how may would you say a job posting would garner today -- 200?) It has been a long week of major and minor employee issues and the hiring manager has begun making ugly noises about when am I going to see some candidates?. So you stuff the whole stack in your briefcase with the illusion of a nice quiet evening to get some solitude to really go through these resumes. But there are issues with your teenage daughter and your wife's reaction to these issues, and you glance at your watch, see it is 9 pm. and realize you meant to go through those resumes. So you sit down, read the job description once, looks like Greek, read it again, no better. Now you pick up the first resume and try to relate the words on the job description to the candidate's experience. You say to yourself, hmm . . this is going to be a long evening. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 24, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Mladen Gogala scribbled on the wall in glitter crayon: Pre-packaged questions are always a bad idea. When a company needs a DBA, it should know what do they need him for. Do they need them to but that would provide that the company actually know how to define job duties and then convey them to HR who would then be able to screen applicants on actual experience and not just groups of letters. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] One had to cram all this stuff into one's mind for the examinations, whether one liked it or not. This coercion had such a deterring effect on me that, after I had passed the final examination, I found the consideration of any scientific problems distasteful to me for an entire year. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information
Re: Re: dba interview questions
sigh... add to this weekend's reading list Tom's new book (it's sitting on my dining room table, waiting) --- [EMAIL PROTECTED] wrote: that question is diagrammed and answered in tom kytes new book. :) im waiting to get asked it. there is a new ault book out on interview questions. I dont think they are very tough. I think situational questions are better. Have a development DB set up with things for the applicant to do. I find that most employers ask the same easy questions. Particularly developer questions From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 09:49:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: dba interview questions The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] 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: [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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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). __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [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[2]: dba interview questions
Being graphically challenged (my drawings without Visio(TM) or Dia are on the level of a 3 years old), I resent the idea. If I had to do drawing, I would not be a DBA today. That would be small loss for me and an enormous one for this list. Did I mention the fact that I'm very humble and modest? On 10/24/2003 11:34:26 AM, Jonathan Gennick wrote: Friday, October 24, 2003, 9:49:26 AM, Kirti wrote: KD Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA KD with all it interal structures, all background processes, and explain how all this works KD together. That's not a half-bad idea. Of possibly more importance than whether they could draw that diagram perfectly might be their thought-process as they tried to fill in the pieces that they don't quite remember. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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: dba interview questions
I usually tend to ask questions like what has been your worst disaster scenario and how did you fix it, what other options would you have had and why didn't you use these etc.. The same with performance tuning issues... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 24, 2003 5:44 PM Oh! Well. I have not seen Tom's book yet. But still, when the candidate is explaining this stuff to you, there are plenty of opps to question him/her to find out if he/she really knows fundamental things.. During one phone interview, we could clearly hear the paper shuffle in the background, while the candidate asked us to repeat the question (a couple of times) to 'make sure' he understood it correctly before answering (reading?)it :) We stopped phone interview process after this!! - Kirti --- [EMAIL PROTECTED] wrote: that question is diagrammed and answered in tom kytes new book. :) im waiting to get asked it. there is a new ault book out on interview questions. I dont think they are very tough. I think situational questions are better. Have a development DB set up with things for the applicant to do. I find that most employers ask the same easy questions. Particularly developer questions From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 09:49:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: dba interview questions The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti --- system manager [EMAIL PROTECTED] wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] 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: [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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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). __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] 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: [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.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: dba interview questions
Sysmgr -- You see now how easy it is to weed out the DBAs who are strong in book knowledge and may have certifications that are not based on real world experiencee. Now, I know Mr. M is ok, so I can vouch for him personally; but, as a general rule, these are not the types of DBAs that you want to hire. Best wishes, Bambi. -Original Message- Sent: Friday, October 24, 2003 7:44 AM To: Multiple recipients of list ORACLE-L A French or English Swallow? -Original Message- Sent: Thursday, October 23, 2003 5:39 PM To: Multiple recipients of list ORACLE-L Mladen -- I'm *stunned* you missed the most obvious of all DBA 101 questions... What is the average air velocity of an unladen swallow? Bambi. -Original Message- Sent: Thursday, October 23, 2003 4:14 PM To: Multiple recipients of list ORACLE-L 1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] 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: [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.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name
RE: RE: dba interview questions
I would have answered: I'd send the list to the help desk as they take care of logins and tell them to lock all accounts except the list I send. What is it you say?? your help desk doesn't do that? Tsk, tsk, tsk... hehehe -Original Message- Sent: Friday, October 24, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Sure do, here's my favorite: You have a database with 3000 registered users, you need to lock all accounts except for a list of 20. How would you do it? Obviously there's several correct answers. But the one I'm looking for is the anonymous PL/SQL block defined like: declare stmt varchar2(200); begin for a in (select username from dba_users where username not in ('SYS','SYSTEM',...)) loop stmt := 'alter user '||a.username||' account lock'; execute immediate stmt; end loop; end; / Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, October 24, 2003 12:00 PM To: Multiple recipients of list ORACLE-L do any of you ask dbas pl/sql questions? I think its important for DBAs to be good developers as well. especially if they are part of a development team. I dont think the skill sets should be seperate. they overlap. From: Jamadagni, Rajendra [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 11:39:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: dba interview questions We prefer to ask their experiences and then throw a curve ball and ask them to defend it. Small issues like Why would/wouldn't an index help? etc ... Another question that I *always* ask is what do you or have you read in last 3 months outside of Oracle manuals? or Do you know any other sites that give you lot of oracle related information? I expect to hear at-least couple form following list ... ixora, hotsos, jlcomp, oracle-dba, oraperf, orapub. If they mention that they have read YAPP, that's a bonus too. But if someone says they haven't read anything other than manuals questions become a little steep. Raj -Original Message- Sent: Friday, October 24, 2003 9:49 AM To: Multiple recipients of list ORACLE-L The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] 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: [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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: RE: dba interview questions
I always find syntax examples in manuals ... don't know why ... Raj -Original Message- Sent: Friday, October 24, 2003 11:59 AM To: Multiple recipients of list ORACLE-L not sure i like the 'read outside the oracle manuals'. I find that alot of people read alot of really bad books and then dont read the stuff on OTN. oracle has very good docs. I do have a beef over lack of syntax examples... From: Jamadagni, Rajendra [EMAIL PROTECTED] Date: 2003/10/24 Fri AM 11:39:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: dba interview questions We prefer to ask their experiences and then throw a curve ball and ask them to defend it. Small issues like Why would/wouldn't an index help? etc ... Another question that I *always* ask is what do you or have you read in last 3 months outside of Oracle manuals? or Do you know any other sites that give you lot of oracle related information? I expect to hear at-least couple form following list ... ixora, hotsos, jlcomp, oracle-dba, oraperf, orapub. If they mention that they have read YAPP, that's a bonus too. But if someone says they haven't read anything other than manuals questions become a little steep. Raj -Original Message- Sent: Friday, October 24, 2003 9:49 AM To: Multiple recipients of list ORACLE-L The problem with such lists is that the prospects also have those... A few years ago Mike Ault published one. We used it to screen candidates via phone interviews. Two out of four I talked to gave me perfect answers: word to word from Mike's list. Use Conner's approach: Give the candidate a white/black board, and ask him/her to draw the SGA with all it interal structures, all background processes, and explain how all this works together. - Kirti ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] 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: [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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [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). ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] 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: [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: questions regarding nologging
Mladen, Thanks for your input. Yes, I also rebuilt all relevant indexes with nologging option so no normal redo genearation either. However, the table was moved into LMT tbs from a dictionery managed tbs. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 22 Oct 2003 21:39:25 -0800 Well, Rafiq, when you move the table, indexes are marked stale, which means that you must rebuild them. Marking indexes unusable shouldn't generate any redo log, except for the dictionary block that was altered. Other then that, moving table is an opration roughly analogous to CTAS and I suspect that if the target table is NOLOGGING, that the whole operation is done in the direct fashion, with block prebuild and appended below the high watermark. I tried it and I didn't see any redo log generation either. That is probably the reason why splitting partitions also doesn't generate redo, as Arup has noted. Oracle has highly optimized many of these operations and avoding excessive redo log generarion is one of the best optimizations one can make. On 2003.10.22 23:54, M Rafiq wrote: Waleed, I agree with you as I moved a 5GB table last week with nologging option with extent size 500M and did not see any normal redo generation for that. It is 8.1.7.0 database. that table has 8 indexes for total size of almost 3GB. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 22 Oct 2003 17:14:24 -0800 Alter table ...Move TS nologging is 100% equivalent to CTAS and should generate minimal amount of logging even if it ran serially (no PQ). Actually the type of command is considered CREATE TABLE So I'm not sure how the original poster was able to determine that the operation generated huge redo logs! This could be possible if the redo logs has to do with Extents management and the needed RBS to manage it (specially if the extents are very small and the TS is dictionary based). Waleed -Original Message- Sent: Wednesday, October 22, 2003 4:54 PM To: Multiple recipients of list ORACLE-L That's because nologging attribute only affects the direct operations, i.e. the the operations that prebuild blocks and add them below the flood watermark. That includes sqlloader with direct=y, inserts with /*+ append */ hint and CTAS. Normal SQL based operations are not affected. On 10/22/2003 04:39:34 PM, Roger Xu wrote: Hi Gurus, I have a couple of questions regarding nologging. 1) alter table tabname move tablespace tbsname nologging; How come this sql still generated same amount of redo logs equal to the size of the table? 2) alter index idxname rebuild tablespace tbsname nologging; This sql only generate minimum redo logs. But the index ends up LOGGING=NO in dba_indexes view. How do I turn the logging on for this index? Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
dba interview questions
Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager INET: [EMAIL PROTECTED] 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: [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: dba interview questions
Thursday, October 23, 2003, 4:14:34 PM, you wrote: sm Dear List,Can anyone send me a list of dba interview questions? Forget the questions. Somebody send me the answers! :) Heh. Maybe you could do the interview in Jeopardy format, where you state the answer, and force the candidate to back into the question. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] 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: [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: dba interview questions
1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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: dba interview questions - Found word(s) to be removed remove free list error email e-mail in the Text body.
Actually, the only important question is How much do you want ? Oh, for the good old days ... Seriously, Mike Ault had a list of questions once which may be a little dated now but would be a good staert. Perhaps on www.tusc.com where he used to work at. Mike ? -Original Message- Sent: Thursday, October 23, 2003 2:14 PM To: Multiple recipients of list ORACLE-L be removed remove free list error email e-mail in the Text body. 1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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.net -- Author: Tony Johnson INET: [EMAIL PROTECTED] 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: [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: dba interview questions
Mladen -- I'm *stunned* you missed the most obvious of all DBA 101 questions... What is the average air velocity of an unladen swallow? Bambi. -Original Message- Sent: Thursday, October 23, 2003 4:14 PM To: Multiple recipients of list ORACLE-L 1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] 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: [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: dba interview questions
and which sql makes server HOT -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 2:14 PM 1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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.net -- Author: AK INET: [EMAIL PROTECTED] 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: [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: dba interview questions
African or European? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan Bellow, Bambi [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ech.com cc: Sent by: Subject: RE: dba interview questions [EMAIL PROTECTED] .com 10/23/2003 03:39 PM Please respond to ORACLE-L Mladen -- I'm *stunned* you missed the most obvious of all DBA 101 questions... What is the average air velocity of an unladen swallow? Bambi. -Original Message- Sent: Thursday, October 23, 2003 4:14 PM To: Multiple recipients of list ORACLE-L 1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author
RE: dba interview questions
Bambi, Be careful. Many will fall in love with you if you continue to submit such things as this to the list. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - SQL Optimization 101: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Bellow, Bambi Sent: Thursday, October 23, 2003 4:39 PM To: Multiple recipients of list ORACLE-L Mladen -- I'm *stunned* you missed the most obvious of all DBA 101 questions... What is the average air velocity of an unladen swallow? Bambi. -Original Message- Sent: Thursday, October 23, 2003 4:14 PM To: Multiple recipients of list ORACLE-L 1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] 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: [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.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] 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: [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
RE: dba interview questions
OK, Sysmgr. There you have it. Hire Ron. -Original Message- Sent: Thursday, October 23, 2003 4:54 PM To: Multiple recipients of list ORACLE-L African or European? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan Bellow, Bambi [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ech.com cc: Sent by: Subject: RE: dba interview questions [EMAIL PROTECTED] .com 10/23/2003 03:39 PM Please respond to ORACLE-L Mladen -- I'm *stunned* you missed the most obvious of all DBA 101 questions... What is the average air velocity of an unladen swallow? Bambi. -Original Message- Sent: Thursday, October 23, 2003 4:14 PM To: Multiple recipients of list ORACLE-L 1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] 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: [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.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing
RE: dba interview questions
Cary -- I'm just naturally lovable. But you they respect. Bambi. -Original Message- Sent: Thursday, October 23, 2003 5:29 PM To: Multiple recipients of list ORACLE-L Bambi, Be careful. Many will fall in love with you if you continue to submit such things as this to the list. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - SQL Optimization 101: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Bellow, Bambi Sent: Thursday, October 23, 2003 4:39 PM To: Multiple recipients of list ORACLE-L Mladen -- I'm *stunned* you missed the most obvious of all DBA 101 questions... What is the average air velocity of an unladen swallow? Bambi. -Original Message- Sent: Thursday, October 23, 2003 4:14 PM To: Multiple recipients of list ORACLE-L 1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] 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: [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.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling
RE: dba interview questions
Category: Init.ora parameters points: 1000 Answer: It depends! Category: CBO points: 1000 Answer: It depends!
RE: dba interview questions
hey! we forgot that one in the book.. DANG! --- Bellow, Bambi [EMAIL PROTECTED] wrote: Mladen -- I'm *stunned* you missed the most obvious of all DBA 101 questions... What is the average air velocity of an unladen swallow? Bambi. -Original Message- Sent: Thursday, October 23, 2003 4:14 PM To: Multiple recipients of list ORACLE-L 1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] 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: [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). __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [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: dba interview questions
there are those of us who already worship her wit :) --- Cary Millsap [EMAIL PROTECTED] wrote: Bambi, Be careful. Many will fall in love with you if you continue to submit such things as this to the list. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - SQL Optimization 101: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Bellow, Bambi Sent: Thursday, October 23, 2003 4:39 PM To: Multiple recipients of list ORACLE-L Mladen -- I'm *stunned* you missed the most obvious of all DBA 101 questions... What is the average air velocity of an unladen swallow? Bambi. -Original Message- Sent: Thursday, October 23, 2003 4:14 PM To: Multiple recipients of list ORACLE-L 1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] 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: [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.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] 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
RE: dba interview questions
Title: RE: dba interview questions 1. 40 hours a week max, right? 2. Bermuda shorts and Hawaiian shirts are considered business casual? 3. What's the daily donut allotment? 4. Health club benefits? (See #3 above) 5. Stock options? 6. Is it OK that my emergency, after-hours phone number starts with 1-900? 7. Salary? Why if you have to ask, you can't afford me. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: system manager [SMTP:[EMAIL PROTECTED] Dear List, Can anyone send me a list of dba interview questions? Thanks,
questions regarding nologging
Hi Gurus, I have a couple of questions regarding nologging. 1) alter table tabname move tablespace tbsname nologging; How come this sql still generated same amount of redo logs equal to the size of the table? 2) alter index idxname rebuild tablespace tbsname nologging; This sql only generate minimum redo logs. But the index ends up LOGGING=NO in dba_indexes view. How do I turn the logging on for this index? Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu INET: [EMAIL PROTECTED] 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: [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: questions regarding nologging
That's because nologging attribute only affects the direct operations, i.e. the the operations that prebuild blocks and add them below the flood watermark. That includes sqlloader with direct=y, inserts with /*+ append */ hint and CTAS. Normal SQL based operations are not affected. On 10/22/2003 04:39:34 PM, Roger Xu wrote: Hi Gurus, I have a couple of questions regarding nologging. 1) alter table tabname move tablespace tbsname nologging; How come this sql still generated same amount of redo logs equal to the size of the table? 2) alter index idxname rebuild tablespace tbsname nologging; This sql only generate minimum redo logs. But the index ends up LOGGING=NO in dba_indexes view. How do I turn the logging on for this index? Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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: questions regarding nologging
In addition to operations provided in Mladen's explanation, all partitioning operations such as exchange/split.. partition, etc. do not generate data related redo for segments marked nologging. HTH. Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 4:54 PM That's because nologging attribute only affects the direct operations, i.e. the the operations that prebuild blocks and add them below the flood watermark. That includes sqlloader with direct=y, inserts with /*+ append */ hint and CTAS. Normal SQL based operations are not affected. On 10/22/2003 04:39:34 PM, Roger Xu wrote: Hi Gurus, I have a couple of questions regarding nologging. 1) alter table tabname move tablespace tbsname nologging; How come this sql still generated same amount of redo logs equal to the size of the table? 2) alter index idxname rebuild tablespace tbsname nologging; This sql only generate minimum redo logs. But the index ends up LOGGING=NO in dba_indexes view. How do I turn the logging on for this index? Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] 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: [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: questions regarding nologging
So how do I turn logging to YES on the index? -Original Message- Sent: Wednesday, October 22, 2003 4:29 PM To: Multiple recipients of list ORACLE-L In addition to operations provided in Mladen's explanation, all partitioning operations such as exchange/split.. partition, etc. do not generate data related redo for segments marked nologging. HTH. Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 4:54 PM That's because nologging attribute only affects the direct operations, i.e. the the operations that prebuild blocks and add them below the flood watermark. That includes sqlloader with direct=y, inserts with /*+ append */ hint and CTAS. Normal SQL based operations are not affected. On 10/22/2003 04:39:34 PM, Roger Xu wrote: Hi Gurus, I have a couple of questions regarding nologging. 1) alter table tabname move tablespace tbsname nologging; How come this sql still generated same amount of redo logs equal to the size of the table? 2) alter index idxname rebuild tablespace tbsname nologging; This sql only generate minimum redo logs. But the index ends up LOGGING=NO in dba_indexes view. How do I turn the logging on for this index? Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] 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: [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). For technical support please email [EMAIL PROTECTED] or you can call (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu INET: [EMAIL PROTECTED] 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: [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
RE: questions regarding nologging
A quick look at the docs for 'alter index' will reveal all. Roger Xu [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/22/2003 04:05 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: questions regarding nologging So how do I turn logging to YES on the index? -Original Message- Sent: Wednesday, October 22, 2003 4:29 PM To: Multiple recipients of list ORACLE-L In addition to operations provided in Mladen's explanation, all partitioning operations such as exchange/split.. partition, etc. do not generate data related redo for segments marked nologging. HTH. Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 4:54 PM That's because nologging attribute only affects the direct operations, i.e. the the operations that prebuild blocks and add them below the flood watermark. That includes sqlloader with direct=y, inserts with /*+ append */ hint and CTAS. Normal SQL based operations are not affected. On 10/22/2003 04:39:34 PM, Roger Xu wrote: Hi Gurus, I have a couple of questions regarding nologging. 1) alter table tabname move tablespace tbsname nologging; How come this sql still generated same amount of redo logs equal to the size of the table? 2) alter index idxname rebuild tablespace tbsname nologging; This sql only generate minimum redo logs. But the index ends up LOGGING=NO in dba_indexes view. How do I turn the logging on for this index? Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] 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: [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). For technical support please email [EMAIL PROTECTED] or you can call (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: questions regarding nologging
Alter table ...Move TS nologging is 100% equivalent to CTAS and should generate minimal amount of logging even if it ran serially (no PQ). Actually the type of command is considered CREATE TABLE So I'm not sure how the original poster was able to determine that the operation generated huge redo logs! This could be possible if the redo logs has to do with Extents management and the needed RBS to manage it (specially if the extents are very small and the TS is dictionary based). Waleed -Original Message- Sent: Wednesday, October 22, 2003 4:54 PM To: Multiple recipients of list ORACLE-L That's because nologging attribute only affects the direct operations, i.e. the the operations that prebuild blocks and add them below the flood watermark. That includes sqlloader with direct=y, inserts with /*+ append */ hint and CTAS. Normal SQL based operations are not affected. On 10/22/2003 04:39:34 PM, Roger Xu wrote: Hi Gurus, I have a couple of questions regarding nologging. 1) alter table tabname move tablespace tbsname nologging; How come this sql still generated same amount of redo logs equal to the size of the table? 2) alter index idxname rebuild tablespace tbsname nologging; This sql only generate minimum redo logs. But the index ends up LOGGING=NO in dba_indexes view. How do I turn the logging on for this index? Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] 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: [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: questions regarding nologging
Waleed, I agree with you as I moved a 5GB table last week with nologging option with extent size 500M and did not see any normal redo generation for that. It is 8.1.7.0 database. that table has 8 indexes for total size of almost 3GB. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 22 Oct 2003 17:14:24 -0800 Alter table ...Move TS nologging is 100% equivalent to CTAS and should generate minimal amount of logging even if it ran serially (no PQ). Actually the type of command is considered CREATE TABLE So I'm not sure how the original poster was able to determine that the operation generated huge redo logs! This could be possible if the redo logs has to do with Extents management and the needed RBS to manage it (specially if the extents are very small and the TS is dictionary based). Waleed -Original Message- Sent: Wednesday, October 22, 2003 4:54 PM To: Multiple recipients of list ORACLE-L That's because nologging attribute only affects the direct operations, i.e. the the operations that prebuild blocks and add them below the flood watermark. That includes sqlloader with direct=y, inserts with /*+ append */ hint and CTAS. Normal SQL based operations are not affected. On 10/22/2003 04:39:34 PM, Roger Xu wrote: Hi Gurus, I have a couple of questions regarding nologging. 1) alter table tabname move tablespace tbsname nologging; How come this sql still generated same amount of redo logs equal to the size of the table? 2) alter index idxname rebuild tablespace tbsname nologging; This sql only generate minimum redo logs. But the index ends up LOGGING=NO in dba_indexes view. How do I turn the logging on for this index? Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] 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: [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). _ Concerned that messages may bounce because your Hotmail account has exceeded its 2MB storage limit? Get Hotmail Extra Storage! http://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net
RE: questions regarding nologging
No need to say yes(not a valid option either) as logging is default. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 22 Oct 2003 15:05:05 -0800 So how do I turn logging to YES on the index? -Original Message- Sent: Wednesday, October 22, 2003 4:29 PM To: Multiple recipients of list ORACLE-L In addition to operations provided in Mladen's explanation, all partitioning operations such as exchange/split.. partition, etc. do not generate data related redo for segments marked nologging. HTH. Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 4:54 PM That's because nologging attribute only affects the direct operations, i.e. the the operations that prebuild blocks and add them below the flood watermark. That includes sqlloader with direct=y, inserts with /*+ append */ hint and CTAS. Normal SQL based operations are not affected. On 10/22/2003 04:39:34 PM, Roger Xu wrote: Hi Gurus, I have a couple of questions regarding nologging. 1) alter table tabname move tablespace tbsname nologging; How come this sql still generated same amount of redo logs equal to the size of the table? 2) alter index idxname rebuild tablespace tbsname nologging; This sql only generate minimum redo logs. But the index ends up LOGGING=NO in dba_indexes view. How do I turn the logging on for this index? Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] 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: [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). For technical support please email [EMAIL PROTECTED] or you can call (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu INET: [EMAIL PROTECTED] 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
Re: questions regarding nologging
Well, Rafiq, when you move the table, indexes are marked stale, which means that you must rebuild them. Marking indexes unusable shouldn't generate any redo log, except for the dictionary block that was altered. Other then that, moving table is an opration roughly analogous to CTAS and I suspect that if the target table is NOLOGGING, that the whole operation is done in the direct fashion, with block prebuild and appended below the high watermark. I tried it and I didn't see any redo log generation either. That is probably the reason why splitting partitions also doesn't generate redo, as Arup has noted. Oracle has highly optimized many of these operations and avoding excessive redo log generarion is one of the best optimizations one can make. On 2003.10.22 23:54, M Rafiq wrote: Waleed, I agree with you as I moved a 5GB table last week with nologging option with extent size 500M and did not see any normal redo generation for that. It is 8.1.7.0 database. that table has 8 indexes for total size of almost 3GB. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 22 Oct 2003 17:14:24 -0800 Alter table ...Move TS nologging is 100% equivalent to CTAS and should generate minimal amount of logging even if it ran serially (no PQ). Actually the type of command is considered CREATE TABLE So I'm not sure how the original poster was able to determine that the operation generated huge redo logs! This could be possible if the redo logs has to do with Extents management and the needed RBS to manage it (specially if the extents are very small and the TS is dictionary based). Waleed -Original Message- Sent: Wednesday, October 22, 2003 4:54 PM To: Multiple recipients of list ORACLE-L That's because nologging attribute only affects the direct operations, i.e. the the operations that prebuild blocks and add them below the flood watermark. That includes sqlloader with direct=y, inserts with /*+ append */ hint and CTAS. Normal SQL based operations are not affected. On 10/22/2003 04:39:34 PM, Roger Xu wrote: Hi Gurus, I have a couple of questions regarding nologging. 1) alter table tabname move tablespace tbsname nologging; How come this sql still generated same amount of redo logs equal to the size of the table? 2) alter index idxname rebuild tablespace tbsname nologging; This sql only generate minimum redo logs. But the index ends up LOGGING=NO in dba_indexes view. How do I turn the logging on for this index? Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu INET: [EMAIL PROTECTED] 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: [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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538
RE: Oracle db using IBM FAStT disk storage questions
Hi Ron, We tested out a FAStT-900 a few months ago. I was happy with the performance results, although we were testing it to replace an HP AutoRAID 12H, so I'd imagine *any* other storage solution would have been better. :) Unfortunately, our test 900 wasn't able to be hooked up to an HP PA-RISC server like we have for production because of questions about a viable HBA for HP's K-series servers. So, our test box was a dual 2.4Ghz P-IV running (ugh) WinTuke with 1GB RAM. If you want a Windoze server to connect to the FAStT, be VERY certain of your logical layout BEFORE making it production, as it seemed even minor changes required at least one reboot for Windohs to recognize the new layout. Without going into detail, I found that I could expect about 4500 PIO/s aggregate thruput with a negated FAStT cache. At this point, the server's CPUs were about 40-50% loaded. While PIOs peaked at about 2/s, and were able to ride at about 6000/s for a while, when I imposed a different query in an attempt to flush the FAStT cache the PIO/s dropped to about 4500/s sustained. Additional queries did not affect the aggregate IO rate up to the point where server CPU became a bottleneck. I attributed the peaks and higher sustained rates on fewer queries to the FAStT's caching. It seems reasonable and I didn't have time to prove it (we only had the box for a week). That's the high-level view. HTH! GL! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Wednesday, October 01, 2003 9:55 AM To: Multiple recipients of list ORACLE-L Is anyone using Oracle database with IBM disk storage FAStT? I was wondering if you had any performance problems, pitfalls and any- other stories that you might want to inform me about? Before we commit ourselves in purchasing this SAN your info would be appreciated. We are a PeopleSoft shop running their Higher Education products 8. Running on RS6000 H-80 with AIX 4.3.3, soon going to 5.2. Oracle version 9.0.2.3. You can email me (address below) directly or to the list. Thanks Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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).
Oracle db using IBM FAStT disk storage questions
Is anyone using Oracle database with IBM disk storage FAStT? I was wondering if you had any performance problems, pitfalls and any- other stories that you might want to inform me about? Before we commit ourselves in purchasing this SAN your info would be appreciated. We are a PeopleSoft shop running their Higher Education products 8. Running on RS6000 H-80 with AIX 4.3.3, soon going to 5.2. Oracle version 9.0.2.3. You can email me (address below) directly or to the list. Thanks Ron *** Ron Cetnar Supervising Programmer/Analyst/Oracle DBA ITS - University Applications Development State University of New York at Albany MSC 100 1400 Washington Ave Albany, NY 1 Email: [EMAIL PROTECTED] Work: (518) 437-4535 Fax: (518) 437-4540 ***
standby questions
Hi Listers, I have few question regarding standby database. standby database created without any problem and it applied the archive logs. Question 1: I created a test table on target db. insert couple rows. switch the log. On standby db, I checked v$archived_log, the log applied and sequence # is correct. I'd like to see if the test table was created in the standby db. So I issue the alter databaser open read only; However, I can query all_tables, there is test table jj. But when I query dba_tables and select * from jj, it gave me ora-00942: table or view does not exist error. Questin 2: I changed back from read only to recover managed mode, So I issued alter database recover managed standby database disconnect from session; I switched logfile on primary db, this time standby didn't receive any log anymore. Is this normal? How can I resyn the sequence again? From primary db, no rows returned from select message from v$dataguard_status Thanks in advance! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] 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: [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: XDB,Context questions
Hi, have you considered free or commercial search engines to save you the effort of building the search capabilities into the database, it might be easier to meld an existing search and index into your oracle app? just a thought considering you want to concentrate on cost. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] 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: [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: XDB,Context questions
Not sure if this reached the list. ReSending. On Fri, 12 Sep 2003 10:15:11 , Govindan K [EMAIL PROTECTED] sent: You need to use XMLType datatype / as CLOB. Check these links: http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96620/toc.htm and within that (for storing data) refer to http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96620/xdb04cre.htm#1035571 You can use XPATH and CONTEXT searches to search. sqlldr can be used to load data. Don't know how to handle MS-Word. Becase if it is kept as BLOB or BFILE then search cannot be used. It needs to be stored as XMLTYPE/CLOB. check the link http://otn.oracle.com/sample_code/tutorials/cmsxdb/maintoc.htm for understanding Oracle XML DB. There is plenty of stuff in http://otn.oracle.com/tech/xml/content.html. HTH GovindanK On Fri, 12 Sep 2003 08:54 , [EMAIL PROTECTED] sent: Hello, We are starting to investigate different methods of searching large medical documents for key words or phrases. The documents may be text, html, xml, or MS word documents. The main idea is to search and retrieve a list of documents quickly that match a given medical key word(s) or phrase(s), similar to google or other internet search engines; this is not intended to be an internet application, but strictly an in-house application. I've been reading the Oracle Context and XDB guides, and have several questions. 1) Is XDB only for XML documents? 2) Is storing/searching a document in XDB faster than using Context and a context index? 3) Is there any Oracle tool to convert text, html, ms word documents to XML? 4) Context appears to be more flexible (handles text, html, msword and xml), but I'm guessing that XDB is faster for just XML; is that correct? 4) Are there other non-Oracle tools that are (in your humble opinion) superior to XDB and Context? Cost is a definite factor. Any other comments regarding XDB, Context or other tools are very welcome. Thanks to any responders. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] 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: [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). Message sent via Zuvio Mail Get your own FREE email account with SPAM and Antivirus protection! Message sent via Zuvio Mail Get your own FREE email account with SPAM and Antivirus protection! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Govindan K INET: [EMAIL PROTECTED] 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: [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).
XDB,Context questions
Hello, We are starting to investigate different methods of searching large medical documents for key words or phrases. The documents may be text, html, xml, or MS word documents. The main idea is to search and retrieve a list of documents quickly that match a given medical key word(s) or phrase(s), similar to google or other internet search engines; this is not intended to be an internet application, but strictly an in-house application. I've been reading the Oracle Context and XDB guides, and have several questions. 1) Is XDB only for XML documents? 2) Is storing/searching a document in XDB faster than using Context and a context index? 3) Is there any Oracle tool to convert text, html, ms word documents to XML? 4) Context appears to be more flexible (handles text, html, msword and xml), but I'm guessing that XDB is faster for just XML; is that correct? 4) Are there other non-Oracle tools that are (in your humble opinion) superior to XDB and Context? Cost is a definite factor. Any other comments regarding XDB, Context or other tools are very welcome. Thanks to any responders. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] 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: [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: more questions
Another fun fact about the OS390 port: If you set max dumb ( :) ) file size to 50 MB, then the session will write 50MB, close the file, open another one, and continue writing trace data to this one, and so one, until the session is done. Tim Gorman wrote: As an interesting side note, Oracle on MVS/OS390 offers multiplexing of datafiles, since at least Oracle v6, I believe. It's just something that never made the jump to other ports, I guess... on 9/1/03 9:09 PM, Sinardy Xing at [EMAIL PROTECTED] wrote: how to startup oracle after machine is bootup? you must configure your /etc/oratab Ans: add this line your_sid:your_oracle_home:AUTO(auto is keyword) how to shutdown oracle before Unix is shutdown? Ans: I don't think that Oracle provide such feature, but you can write OS script add to your in your init.d or simpler way replace your init binary file with your own for example # init 6 your new init /where is my shutdown script/shutdown oracle.sh /or perhaps you want to shutdown listener too or other application do it here/bla.sh sync sync original_init $1 It seems to me that I cannot multiplex data files. Is that true? Ans: Yes Oracle only allow you to multiplex your control files and redolog files but not your data files, however Oracle do recommend you to do RAID 0 + 1 if you have the $$$. Sinardy -Original Message- Sent: 02 September 2003 11:29 To: Multiple recipients of list ORACLE-L Hi Greetings, We are using solaris. I wonder how to startup oracle after machine is bootup and how to shutdown oracle before unix is shutdown? I know how to multiplex control files and redo files. It seems to me that I cannot multiplex data files. Is that true? Thanks! Jin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] 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: [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: more questions
On 2003.09.07 05:19, Mogens Nørgaard wrote: Another fun fact about the OS390 port: If you set max dumb ( :) ) file size to 50 MB, then the session will write 50MB, close the file, open another one, and continue writing trace data to this one, and so one, until the session is done. I'm not an MVS expert, as a matter of fact, I haven't worked with MVS for 15 years. Normally, when I want to have a large trace file I do oradebug unlimit. Is it available on MVS? -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [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: more questions
As an interesting side note, Oracle on MVS/OS390 offers multiplexing of datafiles, since at least Oracle v6, I believe. It's just something that never made the jump to other ports, I guess... on 9/1/03 9:09 PM, Sinardy Xing at [EMAIL PROTECTED] wrote: how to startup oracle after machine is bootup? you must configure your /etc/oratab Ans: add this line your_sid:your_oracle_home:AUTO(auto is keyword) how to shutdown oracle before Unix is shutdown? Ans: I don't think that Oracle provide such feature, but you can write OS script add to your in your init.d or simpler way replace your init binary file with your own for example # init 6 your new init /where is my shutdown script/shutdown oracle.sh /or perhaps you want to shutdown listener too or other application do it here/bla.sh sync sync original_init $1 It seems to me that I cannot multiplex data files. Is that true? Ans: Yes Oracle only allow you to multiplex your control files and redolog files but not your data files, however Oracle do recommend you to do RAID 0 + 1 if you have the $$$. Sinardy -Original Message- Sent: 02 September 2003 11:29 To: Multiple recipients of list ORACLE-L Hi Greetings, We are using solaris. I wonder how to startup oracle after machine is bootup and how to shutdown oracle before unix is shutdown? I know how to multiplex control files and redo files. It seems to me that I cannot multiplex data files. Is that true? Thanks! Jin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] 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: [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: more questions -- multiplexing of datafiles
See the ASM feature of Oracle 10g. http://otn.oracle.com/oramag/oracle/03-sep/o5310gcover_storage.html Oracle handles virtualisation and redistribution of datafiles and also provides mirroring of datafiles. Hemant At 07:59 AM 04-09-03 -0800, you wrote: As an interesting side note, Oracle on MVS/OS390 offers multiplexing of datafiles, since at least Oracle v6, I believe. It's just something that never made the jump to other ports, I guess... on 9/1/03 9:09 PM, Sinardy Xing at [EMAIL PROTECTED] wrote: how to startup oracle after machine is bootup? you must configure your /etc/oratab Ans: add this line your_sid:your_oracle_home:AUTO(auto is keyword) how to shutdown oracle before Unix is shutdown? Ans: I don't think that Oracle provide such feature, but you can write OS script add to your in your init.d or simpler way replace your init binary file with your own for example # init 6 your new init /where is my shutdown script/shutdown oracle.sh /or perhaps you want to shutdown listener too or other application do it here/bla.sh sync sync original_init $1 It seems to me that I cannot multiplex data files. Is that true? Ans: Yes Oracle only allow you to multiplex your control files and redolog files but not your data files, however Oracle do recommend you to do RAID 0 + 1 if you have the $$$. Sinardy -Original Message- Sent: 02 September 2003 11:29 To: Multiple recipients of list ORACLE-L Hi Greetings, We are using solaris. I wonder how to startup oracle after machine is bootup and how to shutdown oracle before unix is shutdown? I know how to multiplex control files and redo files. It seems to me that I cannot multiplex data files. Is that true? Thanks! Jin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] 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: [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). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] 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: [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: more questions
Check with http://download-west.oracle.com/docs/html/A96167_01/post-inst.htm#sthref548 Make sure to shutdown/start related stuff (viz OAS) that might have been installed too. Also, on some UNIX systems, NFS file system from Server A might have been mounted on Server B. If so, you need to shutdown the database first, umount the file system, then shutdown. Upon starting Server, the bootstrap script to mount the file system (share it), followed by starting of the database. You can modify the script in such a way that, if the FS is not mounted, page the DBA, donot start the Database. Also, the shutdown script normaly has SHUTDOWN ; change it to SHUTDOWN IMMEDIATE / SHUTDOWN ABORT depending on what you prefer. HTH GovindanK Hi Greetings, We are using solaris. I wonder how to startup oracle after machine is bootup and how to shutdown oracle before unix is shutdown? I know how to multiplex control files and redo files. It seems to me that I cannot multiplex data files. Is that true? Thanks! Jin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: CHEN,JIN INET: [EMAIL PROTECTED] 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: [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.net -- Author: INET: [EMAIL PROTECTED] 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: [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).