RE: dbms package? - analyze table validate structure

Tim,
 
It was working with parallel clause but corrupting indexes if having mutiple 
keys. Jon has index corruption problem so I suggested to look into that aspect. 
I hope it clarifes.
 
Regards
Rafiq
 



Date: Wed, 31 Dec 2008 15:46:55 -0700From: tim@xxxxxxxxxxx: 
rafiq9857@xxxxxxxxxxxxx: oracle-l@xxxxxxxxxxxxxxxxxxxx: Re: dbms package? - 
analyze table validate structureAnd what exactly is the issue or problem you 
keep referring to?  Doesn't the PARALLEL clause work on indexes with only one 
column or expression?  Or is there some other issue I'm missing?Thanks...M 
Rafiq wrote: 


Tim, Yes, That I what I meant. However, my this experience was with (alter 
)rebuidling of indexes using parallel clause. However, I did not use with 
CREATE INDEX this clause but I think the problem was with alter index only. It 
was originally with 7.3.4.3 version as I did not had any bad experience with 
7.3.4.4. But again it came up in 7.3.4.5 which needed it to patch again. If I 
remember correctly it was year 2001/2. I was supporting Oracle Finacial 
databases and I have to rebuilt indexes after reorg of tables (after yearly 
data purging)  with large undexes and I got this issue with 7.3.4.3. I had done 
similar excercise with other client with 7.3.4.4 but no issue with that 
version.  Later I observed that this issue is with indexes having multiple 
keys. For both versions patch was available to fix that issue. One year back 
one of my collegue had similar type of issue with 9.X version. I don't know 
exact version but she has to drop and recreate index again and the issue was 
resolved. She then upgraded her database to 9.2.0.8 later and did not observe 
such issue. RegardsRafiq      > Date: Wed, 31 Dec 2008 14:47:08 -0700> From: 
tim@xxxxxxxxx> To: rafiq9857@xxxxxxxxxxx> CC: jkstill@xxxxxxxxx; 
jon.crisler@xxxxxxx; oracle-l@xxxxxxxxxxxxx> Subject: Re: dbms package? - 
analyze table validate structure> > Rafiq,> > Regarding your comment...> > The 
issue is always using parallel caluse on a index with multiple > > keys. Single 
key indexses has no issues.> Do you mean to say that the PARALLEL clause in 
CREATE | ALTER INDEX is > somehow affected by the number of columns or 
expressions specified in > the index? Can you elaborate or substantiate?> > 
Thanks!> > -Tim> --> http://www.freelists.org/webpage/oracle-l> > 

Send e-mail anywhere. No map, no compass. Get your Hotmail® account now.
_________________________________________________________________
It’s the same Hotmail®. If by “same” you mean up to 70% faster.
http://windowslive.com/online/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_broad1_122008

Other related posts: