And 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.
Regards
Rafiq
> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
Send e-mail anywhere. No map, no compass. Get your Hotmail® account now.
--
//www.freelists.org/webpage/oracle-l
|