In Oracle 7.3.4.5, if I run this command, will it run
it in parallel?

create table test_ben parallel (degree 2)
unrecoverable as select * from user_tables;

create unique index test_ben_u1 on test_ben
(table_name) parallel (degree 2) unrecoverable;

How do I check this? I see I have 'Parallel query
option' when I logging useing 'svrmgrl'.

Anyone knows how to check whether the query is really
running in parallel ?

thanks,

benny

__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
Oracle LazyDBA home page