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

Home -> Community -> Usenet -> c.d.o.server -> Re: Pct Free, Pct Used.

Re: Pct Free, Pct Used.

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 19 Apr 2006 08:22:58 -0700
Message-ID: <1145460178.832175.154970@u72g2000cwu.googlegroups.com>


Yes, you probably want to have a small pctfree setting because

1- the possibility exists that one day you may add a col3 2- just because you only insert and delete today does not mean that tomorrow an update will not be used
3- there are multiple concurrent inserters so the initrans work area, ITL, space will have to come from somewhere else a wait conditon will be created

Still, you might just be able to just rebuild the table when a new column is added and populated so this may not be an issue and the liklihood of ever updating may be next to nil and finally you may not have concurrent DML. But if it was me I would leave a couple of percent because somehow these things happen.

HTH -- Mark D Powell -- Received on Wed Apr 19 2006 - 10:22:58 CDT

Original text of this message

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