Mark D Powell wrote:
> 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
Alternatively the number of rows can be determined using the built-in
DBMS_ROWID package.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sat Sep 24 2005 - 22:07:26 CDT
