Hi,
I have a table which has a structure similar to the
following.
<FONT face=Arial
size=2>MID
NOT NULL
VARCHAR2(24)NAME
VARCHAR2(512)PRIORITY
NUMBER(38)PERSISTENT
CHAR(1)EXP_DATE
DATEBODY
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
Received on Tue Feb 27 2001 - 18:46:00 CST
