RE: Off topic: Need ideas for 'Take your child to work' day 4/25
We had once a class visiting us, We asked the school to give us the names of the students with a little personal information like class, teacher's name, parent's name, address, phone, likes and dislikes, and picture. We created a small application, single database and encouraged the children to use it and find about their friends, add/edit what they like to. Not all but most of the students enjoyed it. Aleem -Original Message- Sent: Friday, April 05, 2002 7:18 PM To: Multiple recipients of list ORACLE-L Subject: Re: Off topic: Need ideas for 'Take your child to work' day 4/25 [EMAIL PROTECTED] wrote: > Our office is doing 'Take your child to work' day and the plan is for an > older child to shadow me for a little while as we do some simple Oracle dba > or development work. > > I'd really like to make this meaningful by having the child do a task that's > simpler (than optimizing all our procedures) but realistic (instead of being > relegated to the lunchroom to watch tv) with me for an hour or so. > > Has anyone ever done this? I'd appreciate any lessons learned or > suggestions. > > Thanks! > > Barbara > can you create a test db? if you've got the space on a test server it would be ideal. have them do the typing, and explain what each parameter is for and what it does. then have them sign on and run catalog and catproc and watch all the stuff stream by. -- -- Bill "Shrek" Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Murphy's Third Law: In any field of scientific endeavor, anything that can go wrong will go wrong. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater 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: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Off topic: Need ideas for 'Take your child to work' day 4/25
Do not let the kiddo hit until you've reviewed what is typed on each line. Kudos for making the effort, although a DBA's day would probably create emotional scarring in young children... Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: Dungey, Barbara [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, April 04, 2002 8:13 PM > To: Multiple recipients of list ORACLE-L > Subject: Off topic: Need ideas for 'Take your child to work' day > 4/25 > > Our office is doing 'Take your child to work' day and the plan is for an > older child to shadow me for a little while as we do some simple Oracle > dba > or development work. > > I'd really like to make this meaningful by having the child do a task > that's > simpler (than optimizing all our procedures) but realistic (instead of > being > relegated to the lunchroom to watch tv) with me for an hour or so. > > Has anyone ever done this? I'd appreciate any lessons learned or > suggestions. > -- 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: Off topic: Need ideas for 'Take your child to work' day 4/25
> Give them root access and let them have at it!! No... Just give them OEM and let them point and click to their hearts desire so they can be just as dangerous as a real JUNIOR DBA. -Original Message- Sent: Friday, April 05, 2002 5:08 AM To: Multiple recipients of list ORACLE-L 4/25 Give them root access and let them have at it!! Remember, it's a learning experience. Actually I have done this with my kids and I had then go on a tour with someone that knows that manufacturing facility, and then had them spend time in order entry, and the some time in the distribution center. They also had some time in the IS department but by showing them the whole facility they can see that what you do effects everything. They can only sit and watch you type for so long. Oh yea, I also let them spend some time with the PC techs and they got to "fix" some PC's. Dave -Original Message- Sent: Thursday, April 04, 2002 8:13 PM To: Multiple recipients of list ORACLE-L Our office is doing 'Take your child to work' day and the plan is for an older child to shadow me for a little while as we do some simple Oracle dba or development work. I'd really like to make this meaningful by having the child do a task that's simpler (than optimizing all our procedures) but realistic (instead of being relegated to the lunchroom to watch tv) with me for an hour or so. Has anyone ever done this? I'd appreciate any lessons learned or suggestions. Thanks! Barbara -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Off topic: Need ideas for 'Take your child to work' day 4/25
Yeah, and create a tablespace, with datafile - then create a table in that tablespace (with PK etc.) and create an index for the PK and any other fields that would warrant an index.. -Original Message- Sent: 05 April 2002 15:18 To: Multiple recipients of list ORACLE-L 4/25 [EMAIL PROTECTED] wrote: > Our office is doing 'Take your child to work' day and the plan is for an > older child to shadow me for a little while as we do some simple Oracle dba > or development work. > > I'd really like to make this meaningful by having the child do a task that's > simpler (than optimizing all our procedures) but realistic (instead of being > relegated to the lunchroom to watch tv) with me for an hour or so. > > Has anyone ever done this? I'd appreciate any lessons learned or > suggestions. > > Thanks! > > Barbara > can you create a test db? if you've got the space on a test server it would be ideal. have them do the typing, and explain what each parameter is for and what it does. then have them sign on and run catalog and catproc and watch all the stuff stream by. -- -- Bill "Shrek" Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Murphy's Third Law: In any field of scientific endeavor, anything that can go wrong will go wrong. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater 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: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Off topic: Need ideas for 'Take your child to work' day 4/25
[EMAIL PROTECTED] wrote: > Our office is doing 'Take your child to work' day and the plan is for an > older child to shadow me for a little while as we do some simple Oracle dba > or development work. > > I'd really like to make this meaningful by having the child do a task that's > simpler (than optimizing all our procedures) but realistic (instead of being > relegated to the lunchroom to watch tv) with me for an hour or so. > > Has anyone ever done this? I'd appreciate any lessons learned or > suggestions. > > Thanks! > > Barbara > can you create a test db? if you've got the space on a test server it would be ideal. have them do the typing, and explain what each parameter is for and what it does. then have them sign on and run catalog and catproc and watch all the stuff stream by. -- -- Bill "Shrek" Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Murphy's Third Law: In any field of scientific endeavor, anything that can go wrong will go wrong. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Off topic: Need ideas for 'Take your child to work' day 4/25
Give them root access and let them have at it!! Remember, it's a learning experience. Actually I have done this with my kids and I had then go on a tour with someone that knows that manufacturing facility, and then had them spend time in order entry, and the some time in the distribution center. They also had some time in the IS department but by showing them the whole facility they can see that what you do effects everything. They can only sit and watch you type for so long. Oh yea, I also let them spend some time with the PC techs and they got to "fix" some PC's. Dave -Original Message- Sent: Thursday, April 04, 2002 8:13 PM To: Multiple recipients of list ORACLE-L Our office is doing 'Take your child to work' day and the plan is for an older child to shadow me for a little while as we do some simple Oracle dba or development work. I'd really like to make this meaningful by having the child do a task that's simpler (than optimizing all our procedures) but realistic (instead of being relegated to the lunchroom to watch tv) with me for an hour or so. Has anyone ever done this? I'd appreciate any lessons learned or suggestions. Thanks! Barbara -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dungey, Barbara 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: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Off topic: Need ideas for 'Take your child to work' day 4/25
What about blocking locks use utllockt to show a "graphical" output of the waiters building up And you get to show the fun of alter system kill session to get rid of the blockers ! And get a demo of spotlight and show how much data goes back and forth or in the database for 2 different queries that bring back the same answer ie demonstrate efficient SQL Bruce Reardon -Original Message- Sent: Friday, 5 April 2002 14:58 To: Multiple recipients of list ORACLE-L 4/25 What about some simple SQL statements? That might be fun. Especially if you create a table "family" and enter in names, birthdates, etc. --JoJo - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, April 04, 2002 6:13 PM Our office is doing 'Take your child to work' day and the plan is for an older child to shadow me for a little while as we do some simple Oracle dba or development work. I'd really like to make this meaningful by having the child do a task that's simpler (than optimizing all our procedures) but realistic (instead of being relegated to the lunchroom to watch tv) with me for an hour or so. Has anyone ever done this? I'd appreciate any lessons learned or suggestions. Thanks! Barbara -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dungey, Barbara 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: JoJo Zawawi 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: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Off topic: Need ideas for 'Take your child to work' day 4/25
What about some simple SQL statements? That might be fun. Especially if you create a table "family" and enter in names, birthdates, etc. --JoJo - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, April 04, 2002 6:13 PM Our office is doing 'Take your child to work' day and the plan is for an older child to shadow me for a little while as we do some simple Oracle dba or development work. I'd really like to make this meaningful by having the child do a task that's simpler (than optimizing all our procedures) but realistic (instead of being relegated to the lunchroom to watch tv) with me for an hour or so. Has anyone ever done this? I'd appreciate any lessons learned or suggestions. Thanks! Barbara -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dungey, Barbara 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: JoJo Zawawi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Off topic: Need ideas for 'Take your child to work' day 4/25
"Point-and-Click" GUI tools (like OEM) would be attractive but dangerous. How about showing them OEM on a Test Server (and ensure that OEM CANNOT connect to any other database) ? Show them the Tablespace Layout and draw an analogy with their cupboards/shelves at home. Show them the Instance Startup and Shutdown "traffic signal". Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd "Dungey, Barbara" <[EMAIL PROTECTED]>05/04/2002 10:13 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Off topic: Need ideas for 'Take your child to work' day 4/25 Our office is doing 'Take your child to work' day and the plan is for an older child to shadow me for a little while as we do some simple Oracle dba or development work. I'd really like to make this meaningful by having the child do a task that's simpler (than optimizing all our procedures) but realistic (instead of being relegated to the lunchroom to watch tv) with me for an hour or so. Has anyone ever done this? I'd appreciate any lessons learned or suggestions. Thanks! Barbara -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dungey, Barbara 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Off topic: Need ideas for 'Take your child to work' day 4/25
Our office is doing 'Take your child to work' day and the plan is for an older child to shadow me for a little while as we do some simple Oracle dba or development work. I'd really like to make this meaningful by having the child do a task that's simpler (than optimizing all our procedures) but realistic (instead of being relegated to the lunchroom to watch tv) with me for an hour or so. Has anyone ever done this? I'd appreciate any lessons learned or suggestions. Thanks! Barbara -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dungey, Barbara 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).