Oracle-L: optimal settings for a table creation

From: <rgaffuri_at_cox.net>
Date: Mon, 12 May 2003 04:31:39 -0800
Message-ID: <F001.0059683E.20030512043139@fatcity.com>

We have a tablespace that we transport to a production system. It is currently dictionary managed. Yes I know that locally managed is preferabe, but changing right now is not an option.

I recenlty ran a report I got off of Steve Adams site and found that one of our tables is only is 9.5% of its allocated blocks. This table is inserted and updated nightly.

It has about 20 million records. What are the optimal settings for it?

This is what we are using now. I know this is basic, but Im a developer and not a DBA. Trying to pick up the material as quick as possible, but its a long learning curve.

Im thinking I should turn on no logging also in order to speed up the scrubbing process. We can afford to lose the data and it does not need to be archived. Its possible to turn on 'no logging' for session or transaction correct?

     TABLESPACE TEST PCTFREE 10
     STORAGE ( INITIAL 671375360 NEXT 73859072 PCTINCREASE 10 ))

   TABLESPACE TEST
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE (
   INITIAL 524288000
   NEXT 2147483648
   PCTINCREASE 100
   MINEXTENTS 1
   MAXEXTENTS 505
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE;
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.net

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: 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 Mon May 12 2003 - 07:31:39 CDT