Re: Extent sizes

Pk, because of overhead especially the amount of space being held for updates (pctfree) it is likely that only 1 row can be inserted into each block. You can dump the blocks to see how many rows Oracle actually inserted into each block.

set echo off
--

• Oracle command to dump range of Oracle data blocks
• This will not dump file headers, only data.
  --
  
• select header_file, header_block from sys.dba_segments
• where segment_name = 'TABLE_NAME';
  --
  
• -------------------------------------------------------------------
• 20000620 Mark D Powell Save command in usable form.
  --
  set verify off accept fileno prompt "Enter File number to dump " accept blkstrt prompt "Enter starting block number " accept blkend prompt "Enter last block "

alter system dump datafile &fileno block min &blkstrt block max &blkend /
undefine fileno
undefine blkstrt
undefine blkend Received on Sat Sep 24 2005 - 20:01:47 CDT