Re: Partitioning with merge statement

Sherrie,

I fould separate your issue into 2 (i do not know - they might be related):

1. ORA-600 [kokbcvb1] 
2. updates that used to take seconds now take 20 minutes or longer.

For #1 I would suggest to look into Bug #3646263  (which suggests a workaround
set star_transformation_enabled=temp_disable )

For #2 looking into what session waiting on might help to come to resolution. If you have access to old environment (9.2.0.5), you can verify what execution path was and how it differ from current.

I did not experienced this issue myself, however I came across this bug description when I was evaluating migration impact from 9.2.0.5 to 9.2.0.8.

Regards
Mindaugas Navickas

----- Original Message ----
From: "Sherrie.Kubis@swfwmd.state.fl.us" <Sherrie.Kubis@swfwmd.state.fl.us>
To: oracle-l@freelists.org
Sent: Thursday, February 22, 2007 9:32:04 AM
Subject: Partitioning with merge statement


OS:  HP-UX 11.11
Oracle 9.2.0.8 (recently upgraded from 9.2.0.5)

Partitioned table: approx. 72 million rows
19 range partitions,
76 has subpartitions

Our partitioned table is updated nightly with a MERGE/UPDATE statement, and
this always
worked well in 9.2.0.5.   When we went to 9.2.0.8 we sometimes (not
consistently) got a
ORA-600 [kokbcvb1].  The consistent part is that updates that used to take
seconds now take
20 minutes or longer.  Recently, the ORA-00600 became consistent.

We're working (since November!) with Oracle support on this, but it seems
to be going nowhere.

Has anyone else had any problems with Partitioned tables in 9.2.0.8?




------------------------------------------------------------------------
Sherrie Kubis
Oracle DBA Supervisor
Information Resources Department
Application Systems Section
Southwest Florida Water Management District
352-796-7211 x4033
mailto:Sherrie.Kubis@watermatters.org
http://www.watermatters.org
-------------------------------------------------------------------------

-----------------------------------------
IMPORTANT NOTICE:  All E-mail sent to this address are public
record and archived.  The Southwest Florida Water Management
District does not allow use of District equipment and E-mail
facilities for non-District business purposes.
--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l