RE: DBA Weakest Link
At parties we try and limit work related topics to things like That person is such an a**! You get the idea, not to technical. My climbing buddies are my coworkers at well and its a rule that we all pretty much like. For example, going snowboarding today and I bet the only work related topics that come up are So where are you going to work next? OK so we no longer have anything technical to talk about -Original Message- Sent: Friday, December 07, 2001 9:10 PM To: Multiple recipients of list ORACLE-L Q: Why does Larry Ellison keeps asking for bigger and bigger rollback segments ? A: Because he never commits ! Anyway I don't mean to rain on your parade but i think this game your scheming is kinda dumb. Personally at Christmas party (heck or any partyesp. when there's alcohol) I DO NOT want to hear NOTHING about Oracle, or MS...NADA ! And with dutch courage I'd probably poison anyone who gets into it and gets technical. Robert - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 07, 2001 9:20 AM Hello DBAs, I'm having a company holiday party today, and as you all may know my company employs mostly DBAs. (Pythian is an Oracle DBA Outsourcing shop.) I'm thinking of having a DBA Weakest Link game for fun at some point of the evening. Yes, I know, the partners/husbands/wives will think it's a bit of a bore, but imagine the fun for us DBAs! :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA Weakest Link
Man, that is fairly easy to fix. I would make it a priority. Unless you like the torture that is. -Original Message- Sent: Friday, December 07, 2001 8:45 PM To: Multiple recipients of list ORACLE-L Uhm..Mike, you mean you've come across the *references* to it in prints/chat often, and not in your production db in your role as DBA, right ? Robert - Original Message - You gotta be kidding! I see this so often I see it in my sleep! Snapshot too old: rollback segment...too small Are you getting this error a lot? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBA Weakest Link
SNOWBOARDING? Today I'm heading to the beach to soak up some warm SoCal sun since we are having a mild Santa Ana now! Kimberly Smith wrote: At parties we try and limit work related topics to things like That person is such an a**! You get the idea, not to technical. My climbing buddies are my coworkers at well and its a rule that we all pretty much like. For example, going snowboarding today and I bet the only work related topics that come up are So where are you going to work next? OK so we no longer have anything technical to talk about -Original Message- Sent: Friday, December 07, 2001 9:10 PM To: Multiple recipients of list ORACLE-L Q: Why does Larry Ellison keeps asking for bigger and bigger rollback segments ? A: Because he never commits ! Anyway I don't mean to rain on your parade but i think this game your scheming is kinda dumb. Personally at Christmas party (heck or any partyesp. when there's alcohol) I DO NOT want to hear NOTHING about Oracle, or MS...NADA ! And with dutch courage I'd probably poison anyone who gets into it and gets technical. Robert - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 07, 2001 9:20 AM Hello DBAs, I'm having a company holiday party today, and as you all may know my company employs mostly DBAs. (Pythian is an Oracle DBA Outsourcing shop.) I'm thinking of having a DBA Weakest Link game for fun at some point of the evening. Yes, I know, the partners/husbands/wives will think it's a bit of a bore, but imagine the fun for us DBAs! :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DBA Weakest Link
Hello DBAs, I'm having a company holiday party today, and as you all may know my company employs mostly DBAs. (Pythian is an Oracle DBA Outsourcing shop.) I'm thinking of having a DBA Weakest Link game for fun at some point of the evening. Yes, I know, the partners/husbands/wives will think it's a bit of a bore, but imagine the fun for us DBAs! :-) So what I'm trying to do is get many, many weakest link-style questions (with answers) ready. I want them mostly to be easy, but with the odd hard one snuck in for unfairness. Please help out by submitting your questions, and I'll summarize and post the complete list back to the list when I'm done! Sound like fun? I'll get us started with a format. Q: Name the Oracle error for Table or view does not exist? A: Ora-00942, 942 Q: Which of the following return a value? Procedure, Function, Package, Index? A: Function Q: In what version of Oracle did the cursor sharing feature become available? 7.3, 8.0, or 8.1? A: 8.1 Q: In Oracle, the function that averages values is called: Average, or AVG? A: AVG. Q: The structure Oracle uses to protect a region from memory from concurrent access is called: Lock, Latch, or Library Catch? Q: Latch Q: Larger block sizes make more efficient use of the buffer cache, or less efficient? A: Less efficient. I'd like to get at least a hundred ready for the game, preferably more. Thanks for your help! Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBA Weakest Link
Q: In what version of Oracle did the cursor sharing feature become available? 7.3, 8.0, or 8.1? Q: In what version of Oracle did the 'cursor sharing' feature stopped producing ORA-0600? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 07, 2001 9:20 AM Hello DBAs, I'm having a company holiday party today, and as you all may know my company employs mostly DBAs. (Pythian is an Oracle DBA Outsourcing shop.) I'm thinking of having a DBA Weakest Link game for fun at some point of the evening. Yes, I know, the partners/husbands/wives will think it's a bit of a bore, but imagine the fun for us DBAs! :-) So what I'm trying to do is get many, many weakest link-style questions (with answers) ready. I want them mostly to be easy, but with the odd hard one snuck in for unfairness. Please help out by submitting your questions, and I'll summarize and post the complete list back to the list when I'm done! Sound like fun? I'll get us started with a format. Q: Name the Oracle error for Table or view does not exist? A: Ora-00942, 942 Q: Which of the following return a value? Procedure, Function, Package, Index? A: Function Q: In what version of Oracle did the cursor sharing feature become available? 7.3, 8.0, or 8.1? A: 8.1 Q: In Oracle, the function that averages values is called: Average, or AVG? A: AVG. Q: The structure Oracle uses to protect a region from memory from concurrent access is called: Lock, Latch, or Library Catch? Q: Latch Q: Larger block sizes make more efficient use of the buffer cache, or less efficient? A: Less efficient. I'd like to get at least a hundred ready for the game, preferably more. Thanks for your help! Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBA Weakest Link
What is the error message associated with the often seen ORA-01555 error? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA Weakest Link
Paul, It's very thoughful of you to pre-plan an activity during your party, but, with all due respect, YOU'VE GOT TO BE KIDDING! Sound like fun? NOO!! DBA trivia at a Chrismas party?!?!? Come on, think of something EVERYONE (significant others included) can enjoy! DBAs have a bad enough reputation for not having a life - you don't need to reinforce it. IMHO, shop talk should be strictly banned at parties. Think of something a bit more fun - movie trivia, music lyrics, the best jokes I've ever heard. There should be plenty of internet sites at which you could find lots of info. for topics such as these. Or - my favorite - have anyone who knows how to dance teach the others a step or two of Swing, Salsa, etc. Get those normally sedentary DBAs off their duffs and on their feet! Have a dance contest! Jokes could have the party-goers rolling on the floor - DBA trivia absolutely WON'T. Respectfully, Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Friday, December 07, 2001 8:20 AM To: Multiple recipients of list ORACLE-L Hello DBAs, I'm having a company holiday party today, and as you all may know my company employs mostly DBAs. (Pythian is an Oracle DBA Outsourcing shop.) I'm thinking of having a DBA Weakest Link game for fun at some point of the evening. Yes, I know, the partners/husbands/wives will think it's a bit of a bore, but imagine the fun for us DBAs! :-) So what I'm trying to do is get many, many weakest link-style questions (with answers) ready. I want them mostly to be easy, but with the odd hard one snuck in for unfairness. Please help out by submitting your questions, and I'll summarize and post the complete list back to the list when I'm done! Sound like fun? I'll get us started with a format. ... Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA Weakest Link
You gotta be kidding! I see this so often I see it in my sleep! Snapshot too old: rollback segment...too small Are you getting this error a lot? --- === Michael P. Vergara Oracle DBA Guidant Corporation (909) 914-2304 -Original Message- Sent: Friday, December 07, 2001 7:45 AM To: Multiple recipients of list ORACLE-L What is the error message associated with the often seen ORA-01555 error? -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA Weakest Link
LMAO.. ;o) -Original Message- Sent: 07 December 2001 15:05 To: Multiple recipients of list ORACLE-L Q: In what version of Oracle did the cursor sharing feature become available? 7.3, 8.0, or 8.1? Q: In what version of Oracle did the 'cursor sharing' feature stopped producing ORA-0600? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 07, 2001 9:20 AM Hello DBAs, I'm having a company holiday party today, and as you all may know my company employs mostly DBAs. (Pythian is an Oracle DBA Outsourcing shop.) I'm thinking of having a DBA Weakest Link game for fun at some point of the evening. Yes, I know, the partners/husbands/wives will think it's a bit of a bore, but imagine the fun for us DBAs! :-) So what I'm trying to do is get many, many weakest link-style questions (with answers) ready. I want them mostly to be easy, but with the odd hard one snuck in for unfairness. Please help out by submitting your questions, and I'll summarize and post the complete list back to the list when I'm done! Sound like fun? I'll get us started with a format. Q: Name the Oracle error for Table or view does not exist? A: Ora-00942, 942 Q: Which of the following return a value? Procedure, Function, Package, Index? A: Function Q: In what version of Oracle did the cursor sharing feature become available? 7.3, 8.0, or 8.1? A: 8.1 Q: In Oracle, the function that averages values is called: Average, or AVG? A: AVG. Q: The structure Oracle uses to protect a region from memory from concurrent access is called: Lock, Latch, or Library Catch? Q: Latch Q: Larger block sizes make more efficient use of the buffer cache, or less efficient? A: Less efficient. I'd like to get at least a hundred ready for the game, preferably more. Thanks for your help! Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA Weakest Link
I dunno, but it's not 8.1.7.2 on HP sigh Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Friday, December 07, 2001 09:05 To: Multiple recipients of list ORACLE-L Q: In what version of Oracle did the cursor sharing feature become available? 7.3, 8.0, or 8.1? Q: In what version of Oracle did the 'cursor sharing' feature stopped producing ORA-0600? Igor Neyman, OCP DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA Weakest Link
Paul, Seriously think about obtaining professional help . -Original Message- Sent: Friday, December 07, 2001 8:20 AM To: Multiple recipients of list ORACLE-L Hello DBAs, I'm having a company holiday party today, and as you all may know my company employs mostly DBAs. (Pythian is an Oracle DBA Outsourcing shop.) I'm thinking of having a DBA Weakest Link game for fun at some point of the evening. Yes, I know, the partners/husbands/wives will think it's a bit of a bore, but imagine the fun for us DBAs! :-) So what I'm trying to do is get many, many weakest link-style questions (with answers) ready. I want them mostly to be easy, but with the odd hard one snuck in for unfairness. Please help out by submitting your questions, and I'll summarize and post the complete list back to the list when I'm done! Sound like fun? I'll get us started with a format. Q: Name the Oracle error for Table or view does not exist? A: Ora-00942, 942 Q: Which of the following return a value? Procedure, Function, Package, Index? A: Function Q: In what version of Oracle did the cursor sharing feature become available? 7.3, 8.0, or 8.1? A: 8.1 Q: In Oracle, the function that averages values is called: Average, or AVG? A: AVG. Q: The structure Oracle uses to protect a region from memory from concurrent access is called: Lock, Latch, or Library Catch? Q: Latch Q: Larger block sizes make more efficient use of the buffer cache, or less efficient? A: Less efficient. I'd like to get at least a hundred ready for the game, preferably more. Thanks for your help! Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA Weakest Link
Q: In what year did Oracles Pricing Scheem become reasonable and affordable to smaller companies ?? A: Uhhh. in Two Thousand and One Alex ??? I am sorry . Trick Question .. The answer is NEVER !!! -Original Message- Sent: Friday, December 07, 2001 9:55 AM To: Multiple recipients of list ORACLE-L LMAO.. ;o) -Original Message- Sent: 07 December 2001 15:05 To: Multiple recipients of list ORACLE-L Q: In what version of Oracle did the cursor sharing feature become available? 7.3, 8.0, or 8.1? Q: In what version of Oracle did the 'cursor sharing' feature stopped producing ORA-0600? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 07, 2001 9:20 AM Hello DBAs, I'm having a company holiday party today, and as you all may know my company employs mostly DBAs. (Pythian is an Oracle DBA Outsourcing shop.) I'm thinking of having a DBA Weakest Link game for fun at some point of the evening. Yes, I know, the partners/husbands/wives will think it's a bit of a bore, but imagine the fun for us DBAs! :-) So what I'm trying to do is get many, many weakest link-style questions (with answers) ready. I want them mostly to be easy, but with the odd hard one snuck in for unfairness. Please help out by submitting your questions, and I'll summarize and post the complete list back to the list when I'm done! Sound like fun? I'll get us started with a format. Q: Name the Oracle error for Table or view does not exist? A: Ora-00942, 942 Q: Which of the following return a value? Procedure, Function, Package, Index? A: Function Q: In what version of Oracle did the cursor sharing feature become available? 7.3, 8.0, or 8.1? A: 8.1 Q: In Oracle, the function that averages values is called: Average, or AVG? A: AVG. Q: The structure Oracle uses to protect a region from memory from concurrent access is called: Lock, Latch, or Library Catch? Q: Latch Q: Larger block sizes make more efficient use of the buffer cache, or less efficient? A: Less efficient. I'd like to get at least a hundred ready for the game, preferably more. Thanks for your help! Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name
RE: DBA Weakest Link
Rich, Have you zeroed in on the exact circumstance(s) causing your ora-00600 error? If so, I would be interested in hearing about it just so I can watch out for it. For example, I encountered a reproducible 600 error when you had a leading or trailing space in a literal -- e.g. ' This is it'. It varied on different environments, and versions, some would see the error others wouldn't. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jesse, Rich Sent: Friday, December 07, 2001 9:35 AM To: Multiple recipients of list ORACLE-L Subject: RE: DBA Weakest Link I dunno, but it's not 8.1.7.2 on HP sigh Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Friday, December 07, 2001 09:05 To: Multiple recipients of list ORACLE-L Q: In what version of Oracle did the cursor sharing feature become available? 7.3, 8.0, or 8.1? Q: In what version of Oracle did the 'cursor sharing' feature stopped producing ORA-0600? Igor Neyman, OCP DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA Weakest Link
Q: On what platform does Oracle perform the best? A: 16mm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBA Weakest Link
Q: Why does Larry Ellison keeps asking for bigger and bigger rollback segments ? A: Because he never commits ! Anyway I don't mean to rain on your parade but i think this game your scheming is kinda dumb. Personally at Christmas party (heck or any partyesp. when there's alcohol) I DO NOT want to hear NOTHING about Oracle, or MS...NADA ! And with dutch courage I'd probably poison anyone who gets into it and gets technical. Robert - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 07, 2001 9:20 AM Hello DBAs, I'm having a company holiday party today, and as you all may know my company employs mostly DBAs. (Pythian is an Oracle DBA Outsourcing shop.) I'm thinking of having a DBA Weakest Link game for fun at some point of the evening. Yes, I know, the partners/husbands/wives will think it's a bit of a bore, but imagine the fun for us DBAs! :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBA Weakest Link
Uhm..Mike, you mean you've come across the *references* to it in prints/chat often, and not in your production db in your role as DBA, right ? Robert - Original Message - You gotta be kidding! I see this so often I see it in my sleep! Snapshot too old: rollback segment...too small Are you getting this error a lot? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).