Re: PCTFREE & PCTUSED

Hi,

In real life, know your tables/indexes. I took a 10 day snap shot of all my tables (byte amounts), divided by 10, and got the average daily byte growth rate. One other thing to consider, when sizing NEXT extents is how long will it take to allocate the space? You could put in a next extent size of 100M, but how long will it take the OS to allocated that space to the datafile? I like to limit myself to 5M for big tables.

I took the 5 OCP tests, in 5 weeks. One week to prepare for each. They weren't that hard. Althought the performance one had a LOT of information!!!

-Jerry

dgpare wrote:

> I am not sure about this, can't really remember, but I think Oracles answer
> for rapidly growing tables is to increase the PCTINCREASE, although DBA's
> would not agree, myself included. However for the purposes of the exam,
> which is what I am assuming this is for the answer might be, increase
> PCTINCREASE. It might be worth checking out.
> DNP <High.Flight_at_btinternet.com> wrote in message
> news:38C7FB39.3D78_at_btinternet.com...
> > I think you're getting PCTUSED and PCTFREE mixed up.
> >
> > David P.
Received on Thu Mar 16 2000 - 00:00:00 CST