That seems to be the case. There's no degree or instances column on indpart$ or indsubpart$, only on ind$.
For testing purposes:
If you do an explicit parallel , then query v$pq_tqstat you'll see the parallelism used
Then reconnect and do a rebuild with no specification for parallelism then the degree for the previous rebuild won't re-appear.
Regards
Jonathan Lewis
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Chris Taylor <christopherdtaylor1994_at_gmail.com>
Sent: 26 February 2020 17:50
To: ORACLE-L
Subject: Re: Q: Modify Index Subpartition NOPARALLEL ? (Drawing a blank)
I realize now, that I think I made an assumption that rebuilding an index partition in parallel kept the parallel clause on the index partition.
But I'm betting that isn't true is it? Rebuilding the partition in parallel probably doesn't flip the degree/instances bit as that's on the index itself and not on the partition?
Thanks,
Chris
On Wed, Feb 26, 2020 at 10:50 AM Chris Taylor <christopherdtaylor1994_at_gmail.com<mailto:christopherdtaylor1994_at_gmail.com>> wrote:
DB: 12.1.0.2
I have a need to rebuild a bunch of indexes (partition and subpartitions) into a new tablespace.
I have the rebuild working fine for subpartitions like so:
alter index CTAYLOR.MY_INDEX01 rebuild subpartition SYS_SUBP42599 tablespace USERS online parallel 8;
What I cannot figure out is how to modify the subpartition back to NOPARALLEL.
I've tried:
alter index CTAYLOR.MY_INDEX01 modify subpartition SYS_SUBP42599 NOPARALLEL;
alter index CTAYLOR.MY_INDEX01 subpartition SYS_SUBP42599 NOPARALLEL;
I know I can issue another rebuild stmt NOPARALLEL but that seems crazy. There has to be a simple way to modify the subpartition back to noparallel and I can't figure out from manuals how to get to it (sheepish).
Any help?
