Re: 8i Concept PCTFREE & PCTUSED are 0

2002-02-24 Thread Don Granaman
I don't think this is true anymore. At one time, PCTUSED had to be set to "1", but as of 8i, at least, it will be put back on the freelist when empty if PCTUSED=0. (I haven't tested it myself, but I believe Dave Ensor.) -Don Granaman [OraSaurus] - Original Message - To: "Multiple recip

RE: 8i Concept PCTFREE & PCTUSED are 0

2002-02-18 Thread Sinard Xing
Hi Long, Do you mean Oracle should come with AI capability ? then Oracle will be very buggy and Oracle Concept Doc will be the last SOS. With current version I think Oracle is good in general but certainly not ready for AI. Sinardy -Original Message- [EMAIL PROTECTED] Sent: 19 Februar

RE: 8i Concept PCTFREE & PCTUSED are 0

2002-02-18 Thread Long . Nguyen
Hi, This is an offside comment rather than a direct reply to Sinard's question. Oracle has made many config parameters tuneable and this makes the software both flexible and complex. On the other hand MS's SQLServer only has a small number of config parameters that could be changed by DBA (abou

RE: 8i Concept PCTFREE & PCTUSED are 0

2002-02-18 Thread אדר יחיאל
Hello Sinardy PCTUSED means that: After a block was filled with records and the free space in the block is less then pctfree the block is no longer available for further inserts. If however, the data falls beneath PCTUSED the block became again available for inserts. In your example, block will