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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Dataware hosue table storage help ..?

Re: Dataware hosue table storage help ..?

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: 2000/04/13
Message-ID: <20000413.4590500@noname.nodomain.nowhere>#1/1

PCTFREE 10 and PCTUSED 80 is a good starting point for a data warehouse. If disk space is tight you might want to consider cutting PCTFREE to 5 and bumping PCTUSED to 90 (or even 95)

You should also consider making PCTINCREASE 0 with initial and next the same size so that when you start purging old data in a year or two you wont wind up with a fragmented database. (I shudder to thing of reorganizing a big data warehouse in order to reclaim disk space and improve efficiency.)

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 4/12/00, 4:14:03 PM, "Mujahid Hamid" <mujahid_at_pharmco.demon.co.uk> wrote regarding Dataware hosue table storage help ..?:

> Hi All,
 

> I need some help in setting the storage parameters for table in a data
 

> warehouse.
 

> I have set the value for PCTFREE to '10' and PCTUSED to be '80', is
 this
> correct, is there any performance implications/degradation or
advantages.

> There will be mostly inserts into the warehouse at about 95% of the
 time and
> hardly any updates/deletes, like any typical data warehouse.
 

> Please advise me on the setting of these storage parameters, If anyone
 

is
> working on a warehouse and has the storage settings please do let me
know.

> This data warehouse is appended to every month and the initial load is
 

> likely to contain 2 million rows in a typical target table and
 subsequent
> loads are likely to be about 10 thousand rows every month, which are
 above
> 95% inserts.
 

> I very much appreciate you help.
 

> With thanks
 

> Mujahid
Received on Thu Apr 13 2000 - 00:00:00 CDT

Original text of this message

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