Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Patch -> - any problems?

Re: Patch -> - any problems?

From: jared still <>
Date: Thu, 28 Dec 2000 08:54:50 -0800 (PST)
Message-Id: <>

In addtion to what I've asked for, were any of you using Parallel Query options and or Partitions?



On Thu, 28 Dec 2000, jared still wrote:

> Hi all,
> We have a database here that is at version
> Have any of you experienced problems in upgrading from
> to
> The problem we have is that this database is used in
> production, and for some strange reason, there is no
> corresponding development or test databases. ( I've
> only been here a month, gimme a break! :)
> We are hesitant to upgrade until we feel some level
> of confidence in going to
> Among the version specific problems it has:
> ( written up by a fellow DBA )
> Histograms (analyze column) on partition tables with any empty partitions
> causes the optimizer to crash on any query for the affected table.
> Workaround is to drop statistics and rebuild them without using histograms.
> Problem caused by Bug # 962964 which is fixed in (or 8.1.7).
> Rebuild partitioned index (happened on more than one index build) in
> parallel mode crashed about 3/4 of the way through with ORA-12801 and
> ORA-27062 errors. The analyst handling this strongly suggested upgrading
> to because of multiple bugs in the Parallel Query Option --
> he included a list of about 30 PQO bugs, none of them an exact match
> with my problem. Pull up the TAR if you want to review this. Workaround
> was to drop the PARALLEL clause on the index builds.
> Weekly structure only exp has been failing with ORA 1000 (too many open
> cursors). I looked this up on Metalink and got an exact hit in a
> Forum thread. Apparently, this is caused by Bug # 1244182 and
> occurs on full exports of databases that use locally managed tablespaces.
> The problem is supposedly fixed in but may need an additional
> patch also. Workaround is to increase the open_cursors parameter to a
> larger value (I suppose I could open a TAR to get something a bit more
> specific than "larger").
> Thanks,
> Jared Still
> Certified Oracle DBA and Part Time Perl Evangelist ;)
> --------
> Think you know someone who can answer the above question? Forward it to them!
> to unsubscribe, send a blank email to
> to subscribe send a blank email to
> Visit the list archive:

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;) Received on Thu Dec 28 2000 - 10:54:50 CST

Original text of this message