Re: Performance Degradation as table grows...Insert slows down

Hi,

    What version of Oracle are you running?

    If you are running 8.0 or later have you considered partitioning your big table?

regards

Jerry

kasthuri_at_viisage.com wrote in message <71skg2$ink$1_at_nnrp1.dejanews.com>...
>hi,
>
>I have a database of size around 132 GB. I have
>a table with two Image columns.The primary key
>includes 4 fields (char(4), char(8), char(9) and
>char(14)) The data, index and image columns are
>placed in different tablespaces. the physical
>memory of the system is 1GB and has 4
>processors.It is a Dell Server 6100.
>
>Insertion of a record into this table which now has 4.3 million records
takes
>around 350 millisecs. Most of the time is spent in blob data write only. I
>need to insert another 6 million records into this table. With this
>calculation it will take me another 32 days to insert these records into
the
>table. It will further slow down and will take around 2 secs to insert a
>single record as the table grows to 6 million records. (i had this table
>dropped and recreated because of some other problems too)
>
> I have some statistics too
>
>total sga : 62089900 bytes
>
>lib cache: .999998198
>row cache: .991865393
>free memory: 8921196 bytes.
>The ratio of execution:misses::4995938:9
>I tried increasing the SGA too. It didnt help
>improve the performance.
>
>The insertion was instantaneous if i create another table. My requirement
is
>to have a single table.
>
>Please suggest me as to what i should to do to
>improve performance.The Index tablespace is rapidly growing.
>
>I did contact oracle support also - and they are trying to help too. If any
>of you have come across this problem and have a solution for it, please do
>suggest.
>
>Thanks
>kasthuri
>
>
>--
>Kasthuri Jegatheesan
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Nov 05 1998 - 13:23:26 CST