Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

analyzing table

user454189Jun 10 2006 — edited Jun 10 2006
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 8 2006
Added on Jun 10 2006
5 comments
788 views