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

Home -> Community -> Usenet -> c.d.o.server -> Re: Locks

Re: Locks

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Wed, 27 Oct 1999 12:39:58 -0400
Message-ID: <7v7acc$t7b$1@autumn.news.rcn.net>


Have you analyzed the table either estimating or computing statistics since the index was dropped? I prefer to compute rather than estimate, but that is personal preference. Run

    ANALYZE TABLE <big_table> COMPUTE STATISTICS;

hth
jerry gitomer

amerar_at_ci.chi.il.us wrote in message
<7v71r1$vbl$1_at_nnrp1.deja.com>...
>
>
>Hello,
>
>Perhaps this post is worthless, but what is a good way to try
and find
>out why a database starts running slowly. I take a look at the
the
>locks view and see about 40 locks on a certain table. It is
possible
>that many users are updating this table and creating a bottle
neck. I
>also see tons of updates happening in the v$session view.
>
>My question is, how do I actually pin point the problem?
Everything was
>running fine yesterday. Then, some jerk accidentally dropped a
promary
>key index on a major table. It took 45 minutes to re-create
this index,
>and everything has been going slow since.
>
>I am guessing that all users are on re-entering their work, but
how can
>I be sure that this is what is causing the problems??
>
>Arthur
>amerar_at_ci.chi.il.us
>
>ps. Send a copy to e-mail please.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Wed Oct 27 1999 - 11:39:58 CDT

Original text of this message

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