Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: drop tablespace including contents

RE: drop tablespace including contents

From: Brooks, Russ <Russ.Brooks_at_dayzim.com>
Date: Wed, 21 Aug 2002 11:48:47 -0800
Message-ID: <F001.004BBAB0.20020821114847@fatcity.com>


Yeah, that's what I do too. I just wish it wouldn't clobber the stats on the indices after I've so carefully gathered them. We have the 6.2 sapdba, so I don't think it's using dbastatc as much to control when and how it does the stats.

Russ

-----Original Message-----
Sent: Wednesday, August 21, 2002 1:59 PM To: Multiple recipients of list ORACLE-L

Ironically, analyzing tables is one of the jobs I leave up to SAPDBA.

There are a number of tables that shouldn't be analyzed, ( ~150 on my system ) and the system knows which ones they are.

Just schedule the job through transaction DB13 and forget about it.

Jared

paquette stephane <stephane_paquette_at_YAHOO.COM> Sent by: root_at_fatcity.com
08/20/2002 09:48 PM
Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Re:drop tablespace including contents


At one client, one team was using SAP without a DBA, only the SAP administrator using SAPDBA. They were having poor performance.

After 2-3 days they came to see me, after 5 minutes I told them that 4000 tables out of 16 000 were having no statistics at all. They analyzed during the weekend and performance was pretty good ....


Stéphane Paquette
DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant
stephane_paquette_at_yahoo.com

Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: stephane_paquette_at_yahoo.com

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: ListGuru_at_fatcity.com (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: Jared.Still_at_radisys.com

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: ListGuru_at_fatcity.com (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: Brooks, Russ
  INET: Russ.Brooks_at_dayzim.com

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: ListGuru_at_fatcity.com (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 Aug 21 2002 - 14:48:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US