Message-Id: <10724.125397@fatcity.com> From: jared still Date: Thu, 28 Dec 2000 08:54:50 -0800 (PST) Subject: Re: Patch 8.1.6.1 -> 8.1.6.3 - any problems? In addtion to what I've asked for, were any of you using Parallel Query options and or Partitions? Thanks Jared On Thu, 28 Dec 2000, jared still wrote: > > Hi all, > > > We have a database here that is at version 8.1.6.1. > > Have any of you experienced problems in upgrading from > 8.1.6.1 to 8.1.6.3? > > 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 8.1.6.3. > > 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 8.1.6.2 (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 8.1.6.3 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 8.1.6.3 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 ;) > jkstill@teleport.com > jared_still@enron.net > > > -------- > Think you know someone who can answer the above question? Forward it to them! > to unsubscribe, send a blank email to oracledba-unsubscribe@LAZYDBA.com > to subscribe send a blank email to oracledba-subscribe@LAZYDBA.com > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > Jared Still Certified Oracle DBA and Part Time Perl Evangelist ;)