Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Index getting "old" fast

Re: Index getting "old" fast

From: Bricklen <bricklenREMOVETHIS_at_shaw.ca>
Date: Tue, 19 Feb 2002 19:59:35 GMT
Message-ID: <3C72AE2A.F75A26A9@shaw.ca>


and to add to Daniel's questions, why are you dropping your index? why not just rebuild it and analyze it at the same time?

damorgan wrote:
>
> 2880 inserts are making your indexes go bad or requiring new statistics? I don't buy it.
>
> Something else must be going on. Go back to basics. What operating system? What version of
> Oracle? Any missing patches? Auditing? whatever.
>
> Daniel Morgan
>
> Stan Brown wrote:
>
> > In <3C713A5D.108FB148_at_ci.seattle.wa.us> damorgan <dan.morgan_at_ci.seattle.wa.us> writes:
> >
> > >I can't remember that far back. But if the functionality is there use DBMS_JOB with
> > >DBMS_SQL.
> >
> > >But somehow I find it hard to believe that this is really your problem. What is
> > >happening to this table during the 24 hours? How many inserts? How many updates?
> > >How many deletes? Is the table being emptied?
> >
> > about 60 x 24 x 2 inserts.
> >
> > It's _very_ repatable. Every morning, the queries are back to 20 to 30
> > seconds, and droping the index, and recreating it gets them back to 2
> > seconds.
> >
> > Very puzzling.
> >
> > --
> > "They that would give up essential liberty for temporary safety deserve
> > neither liberty nor safety."
> > -- Benjamin Franklin
Received on Tue Feb 19 2002 - 13:59:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US