Not certain that this is the case, but could it be that statistics are missing for one partition, thus occulting (as in 'undefined and something is undefined') statistics for the other partitions and the table ? Not necessarily for the table you are trying to insert into.
Not sure that it is a good idea but I have a knack for picking up customers where air conditioning is out of order and above 25C I work at 50% of my capacity with an exponential decrease.
As the temperature stands, if anybody is willing to water me from time to time, I'll appreciate.
>----- ------- Original Message ------- -----
>From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Wed, 06 Aug 2003 07:39:36
>
>
>We have a situation where a process can't insert
>into a partition of a
>partitioned table. The process just keeps running.
>
>- A stored procedure executes a SQL insert
>statement (listing below).
>- It normally completes in 30 minutes, but now just
>runs for hours.
>- Oracle 8.1.6 on Dec/Compaq/HP Alpha
>- In tracing the process, it is waiting on "db file
>scattered read".
>- This is a relatively new process, but it has
>completed successfully twice
>in production and numerous times in test.
>- I was able to perform a simple insert into the
>partition.
>- I created a test table (non-partitioned) and the
>process worked fine
>there, completing in the normal 30 minutes.
>- I rebuilt the partition (drop partition and
>create partition), to no
>effect.
>I'm stumped and looking for any suggestions:
>
>Dennis Williams
>DBA, 80%OCP, 100% DBA
>Lifetouch, Inc.
>dwilliams_at_lifetouch.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: sfaroult_at_oriolecorp.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Aug 06 2003 - 11:14:23 CDT
