Your estimate comes to around 1 row per block.
What is the average row lenght once data is in the db
? Do you have row chaining ?
What is your block size ? Can you increase it ?
If a lot of queries do not need the long raw column
you can put it in another table with a 1 to 1
relationship with the parent table.
If your planning to have 200 rows of 1 block each, I
do not understand why you are adding datafiles as the
data should not occupied more than 3200K if you
blocksize is 16K. Increase the size of the initial
datafile instead of adding new ones.
--- Sanjay Kumar <[EMAIL PROTECTED]> a écrit : >
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
>
>
>
=====
Stephane Paquette
DBA Oracle
[EMAIL PROTECTED]
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
