RE: 10046 / wait events question

From: <darrell_at_landrum.com>
Date: Mon, 09 Aug 2004 13:51:09 -0700 (PDT)
Message-Id: <20040809135110.2298.h012.c000.wm@mail.landrum.com.criticalpath.net>

Yes. The event timings, etc. show up as expected. The only thing that seems to be missing is the wait events for this one table of the four.
I found yesterday that by dropping the constraint which uses the sa_unq_idx1 and rebuilding sa_unq_idx1 as a unique index, that the query goes back to using sales_trans_date_idx and runs well. However, after a batch cycle last night which added maybe 90,000 rows to the current partition, the query is running poorly again (and worse, stats gathering hasn't helped). I'm considering rebuilding that index again (perhaps starting with just the current partition as it is the only one to have changed), but this shouldn't be necessary every day.
Either way, I still wonder about those missing wait events.

Thanks!

On Mon, 9 Aug 2004 15:12:48 -0400, "Ruth Gramolini" wrote:

>
> This is just a shot in the dark but do have timed
> statistics set to true?
>
> Ruth
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Aug 09 2004 - 15:46:52 CDT