Thanks for all the replies (to the list and some private..) All that was done by the script was to send an e-mail to the VSDBA, when TS usage crossed some percentage, set by the VSDBA for those databases (they wanted almost everything that Patrol did).
The only difference now is that the scripts are run via cron, at a frequency set by the VSDBA. The scripts do not have 'Patrol Intelligence' to send e-mails only once after detecting some TS crossed the threshold. THAT is the real rub. They were used to ignore such notification from Patrol. The script sends them e-mails until they fix the problem. Auto extension of datafiles was not the solution in the VSDBA's mind. My suggestion to set datafiles to use auto extension was rejected (for whatever reasons). I am still waiting to hear how rollback/temp space issues in VSDBAs resolve automagically, other than after the jobs got terminated... - Kirti --- Kirtikumar Deshpande <[EMAIL PROTECTED]> wrote: > 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).