Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Dataware hosue table storage help ..?
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