Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

index rebuild with parallel

867656Aug 24 2011 — edited Aug 24 2011
hi,

I am rebuilding an index with 7billion records using the parallel option, for the last couple of hours the tables full scan is going on but i think its not parallelised, is it how its supposed to work or can this initial task be also run in parallel .

my sql statement
alter index VBOX~0 rebuild online parallel 4

SQL> select * from v$pq_sesstat;

STATISTIC LAST_QUERY SESSION_TOTAL
------------------------------ ---------- -------------
Queries Parallelized 0 0
DML Parallelized 0 0
DDL Parallelized 0 0
DFO Trees 0 0
Server Threads 0 0
Allocation Height 0 0
Allocation Width 0 0
Local Msgs Sent 0 0
Distr Msgs Sent 0 0
Local Msgs Recv'd 0 0
Distr Msgs Recv'd 0 0

11 rows selected.

SQL> select dfo_number, tq_id, server_type, num_rows, process from v$pq_tqstat order by tq_id, server_type, process;

no rows selected

SQL> select SLAVE_NAME,STATUS,SESSIONS from v$pq_slave;

SLAV STAT SESSIONS
---- ---- ----------
PZ99 IDLE 67867

Thank you
Jonu
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 21 2011
Added on Aug 24 2011
4 comments
1,020 views