Table Storage Estimates

[Sanjay Kumar]

Hi,   I have a table which has a structure similar to the following.   MID                                 NOT NULL VARCHAR2(24) NAME                                               VARCHAR2(512) PRIORITY                                           NUMBER(38) PERSISTENT                                         CHAR(1) EXP_DATE                                            DATE BODY                                                LONG RAW     I estimated the table storage for this table using the formula given in the Oracle documentation. It comes to around 1 rows per block.   It is estimated that the number of rows for this table will not exceed 200.   My questions are   1. Doesnt this lead to fragmentation.? 2. I have added three datafiles to this tablespace as of now and it seems like this might require more space!!!!!!!!. How do I effectively redesign this table to avoid contention and chaining?   3. Moreover, initially when there were 105 rows inserted, I issued a count(*) and it took about 5 minutes? How do I reduce the time taken to execute the query?     I would highly appreciate if someone comes forward to help me on this.   I am using Oracle 8.1.6 on Solaris   Sanjay