RE: Should percent increase higher than 0 in 817?

From: Guang Mei <gmei_at_incyte.com>
Date: Wed, 02 Jul 2003 12:12:56 -0700
Message-ID: <F001.005C0A1C.20030702115043@fatcity.com>

What are the things that we should be monitoring in ROLLBACK or TEMP tablespace? So far I don't have any script to monitor ROLLBACK or TEMP (havn't had any problem though). I too thought Oracle would take care of rollback and temp ts space management. Right or wrong?

Guang

-----Original Message-----
Kirtikumar Deshpande
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: Guang Mei
  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 - 14:12:56 CDT