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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
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@xxxxxxxxx<mailto:christopherdtaylor1994@xxxxxxxxx>>
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?
Thanks,
Chris
--
//www.freelists.org/webpage/oracle-l