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

Hi,
I am using Oracle 8.0.4 and i cannot partition this table since it has got two blob columns

Thanks,
kasthuri.J

In article <71sttc$670$1_at_client2.news.psi.net>,   "Jerry Gitomer" <jgitomer_at_ictgroup.com> wrote:
> 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
>
>

--
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:47:25 CST