RE: Should percent increase higher than 0 in 817?

From: Kirtikumar Deshpande <kirtikumar_deshpande_at_yahoo.com>
Date: Wed, 02 Jul 2003 14:37:36 -0700
Message-ID: <F001.005C25A8.20030702142420@fatcity.com>

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).

Received on Wed Jul 02 2003 - 16:37:36 CDT