Hi all,
I've created this table:
CREATE TABLE MISURA_BYTE (
KEY_ID_EVENTO VARCHAR2(5),
CAMPO VARCHAR2(2)
)
try to see how bytes has been allocated to it:
select * from USER_SEGMENTS where segment_name='MISURA_BYTE'
getting:
SQL> select tablespace_name,bytes,blocks from USER_SEGMENTS where segment_name='MISURA_BYTE';
TABLESPACE_NAME BYTES BLOCKS
------------------------------ ---------- ----------
USERS 65536 8
insert some row:
INSERT INTO MISURA_BYTE VALUES ('12345','1')
INSERT INTO MISURA_BYTE VALUES ('12345','1')
INSERT INTO MISURA_BYTE VALUES ('12345','1')
INSERT INTO MISURA_BYTE VALUES ('12345','1')
INSERT INTO MISURA_BYTE VALUES ('12345','1')
INSERT INTO MISURA_BYTE VALUES ('12345','1')
INSERT INTO MISURA_BYTE VALUES ('12345','1')
but the byte indicated are the same:
SQL> select tablespace_name,bytes,blocks from USER_SEGMENTS where segment_name='MISURA_BYTE';
TABLESPACE_NAME BYTES BLOCKS
------------------------------ ---------- ----------
USERS 65536 8
why this happen, i need to know the really byte allocated, and how it grows when some row are inserted. It is possible?
thanks
F.