index rebuild with parallel
867656Aug 24 2011 — edited Aug 24 2011hi,
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