analyzing table
hi,
i am using oracle8i in solaris.
i am analyzing the table while i am analyzing the one table but i am getting two rows when i query dba_tables i dont know..... this is the first time i am analyzing the table...... plz tell me why it happens........ and which row we hav to look into... i got confused which row to read...
here i given what i did.........
SQL> select num_rows,blocks,avg_row_len,empty_blocks,avg_space,chain_cnt,avg_sp
ace_freelist_blocks from dba_tables where table_name='T_MASTER_GROUP_USERS';
NUM_ROWS BLOCKS AVG_ROW_LEN EMPTY_BLOCKS AVG_SPACE CHAIN_CNT
---------- ---------- ----------- ------------ ---------- ----------
AVG_SPACE_FREELIST_BLOCKS
-------------------------
3928 255 108 64 281 0
1810 ---------->row1
3579 235 109 84 274 0
1548 ----------->row2
SQL> analyze table KESDEE.T_MASTER_GROUP_USERS compute statistics;
Table analyzed.
SQL> select num_rows,blocks,avg_row_len,empty_blocks,avg_space,chain_cnt,avg_spa
ce_freelist_blocks from dba_tables where table_name='T_MASTER_GROUP_USERS';
NUM_ROWS BLOCKS AVG_ROW_LEN EMPTY_BLOCKS AVG_SPACE CHAIN_CNT
---------- ---------- ----------- ------------ ---------- ----------
AVG_SPACE_FREELIST_BLOCKS
-------------------------
3935 255 105 64 278 0
1665
3579 235 109 84 274 0
1548
can any one help me plz?
With Regards
Boo