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: Extent sizes

Re: Extent sizes

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 24 Sep 2005 20:07:26 -0700
Message-ID: <1127617583.358570@yasure>


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

Original text of this message

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