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 -> Strange result of select

Strange result of select

From: Andrea <no_at_tin.it>
Date: Mon, 09 Apr 2007 18:54:24 +0200
Message-ID: <evdr5f$n1j$1@nnrp.ngi.it>


Hi,
i do this select joined in 2 tables for have number of block and byte from user_tables and user_segment.

SELECT A.BYTES,A.BLOCKS,B.BLOCKS

     FROM USER_EXTENTS A, USER_TABLES B
     WHERE B.TABLE_NAME = 'PROVA'
     AND A.SEGMENT_NAME='PROVA';


BYTES     BLOCKS      BLOCKS
-----  ---------    --------
65536         16          13

the same table have 16 blocks in user_extents and 13 in user_tables, why??

THANKS!
andrew Received on Mon Apr 09 2007 - 11:54:24 CDT

Original text of this message

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