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

Hi,
I have a composite primary key of four columns. I tried recreating the indexes after dropping them. it did not fasten up things. this was a suggestion from oracle. i cannot drop the indexes, insert records and then create the index because of the validity of the data.
The lob data is placed on a separate tablespace. image col 1 in tbspace1 and image col 2 in tbspace2. The entire database resides in the RAID. There are no other transactions going on and it is just the insert that is being attempted now.

 right now i have split the table to 10 different tables based on some categorisation. it seems to be okay as there will be about a max of 4 million records in the individual table.

Thanks,
Kasthuri.J

In article <AD1geGsK42_at_protasov.kiev.ua>,   oracle_at_protasov.kiev.ua wrote:
>
> Hi,
>
> Can you drop your indexes, insert data and then recreate indexes?
> Where did you place your lob columns' segments? In what tablespace?
> Maybe this disk is too busy?
>
> Andrew Protasov
>
> > 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
> >
> >
>

--
Kasthuri Jegatheesan

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Nov 14 1998 - 18:52:38 CST