Rafiq, If we had a slot for you I'd probably recommend you submitting a resume. As it is we're full up on DBA's. I have not had a major, or minor problem for that matter, in years. In this company keeping things running smoothly is a recipe for success. And proactive monitoring is the key.
Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- Sent: Wednesday, July 02, 2003 5:01 PM To: Multiple recipients of list ORACLE-L I totally agree with Dick...The person who si saying not to bother these two ,must be a sleeping DBA waiting for trouble to come and then jump and this is the right strategy in US market. I lost my job because I kept my production databases so smooth and trouble free (with proactive monitoring)that gave impression to my management that I am totally free all day. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Wed, 02 Jul 2003 10:36:16 -0800 Kirti, I will kinda agree with your Very Senior DBA. Make TEMP an LMT with uniform extents, of type temp and with a tempfile & your most likely not to have a problem there that will have any lasting effect. It's one of those things that you have to accept end user complaints on to determine if there has been a problem, otherwise the problem clears as fast as it happens. Now RollBack can get top be a problem if & when you run out of space due to some LONG running transaction that should have been killed 2 days ago. Consequently I watch rollback. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- Sent: Wednesday, July 02, 2003 2:16 PM To: Multiple recipients of list ORACLE-L After we rolled out our own scripts to monitor TS usage (de-Installing BMC Patrol) following is a line from a Very Senior DBA's email sent to us (not-so-senior-DBA-team-members) yesterday: "I don't think the script should monitor ROLLBACK or TEMP tablespace for space issues - these normally resolve themselves" (I will surely get in trouble when my co-workers see this post, but what the heck.. We will get outsourced soon anyway);) BTW, the VSDBA supports 8.1.7.4 databases. - Kirti --- "Goulet, Dick" <[EMAIL PROTECTED]> wrote: > That's OK, I know a couple who never heard of optimal and/or "organization index" either. > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -----Original Message----- > Sent: Tuesday, July 01, 2003 7:14 PM > To: Multiple recipients of list ORACLE-L > > > I saw a "Sr. DBA" few years ago, who claimed he had worked with Oracle since > V4.0, and he didn't have a clue what PCTINCREASE is... > > Tanel. > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Tuesday, July 01, 2003 11:51 PM > > > > What about ones that you don't know? > > > > Mladen Gogala > > Oracle DBA > > Phone:(203) 459-6855 > > Email:[EMAIL PROTECTED] > > > > > > -----Original Message----- > > Sent: Tuesday, July 01, 2003 4:11 PM > > To: Multiple recipients of list ORACLE-L > > > > > > PCTINCREASE is a bad good thing. Every DBA that I know of hunts down > > objects with a pctincrease other than 0 and resets them. > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Gogala, Mladen > > INET: [EMAIL PROTECTED] > > __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.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: 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 subscribing). _________________________________________________________________ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq 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 subscribing).