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

Hi,

Do you use software RAID? What is your RAID controller? Did you enable write cache in it?

Andrew Protasov

> 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 Sun Nov 15 1998 - 02:04:00 CST