Re: What does Oracle do with an INSERT statement?

Hi,

 There is excellent treatment regarding your question is in Oracle Concept Manual. Here it is...

"For each data and index segment, Oracle maintains one or more free lists—lists of data blocks that have been allocated for that segment’s extents and have free space greater than PCTFREE; these blocks are available for inserts. When you issue an INSERT statement, Oracle checks a free list of the table for the first available data block and uses it if possible. If the free space in that block is not large enough to accommodate the INSERT statement, and the block is at least PCTUSED, Oracle takes the block off the free list. Multiple free lists per segment can reduce contention for free lists when concurrent inserts take place."

Chirag Shah

Oracle Administrator Received on Tue Jun 05 2001 - 04:28:00 CDT