I have this query which I have to run on the DB:

SELECT 'ALTER TABLE '

|| table_name

|| CASE WHEN num_rows > 100000 THEN ' PARALLEL ( DEGREE Default INSTANCES Default );' ELSE ' noparallel;' END

FROM user_tables

UNION ALL

SELECT 'ALTER INDEX '

|| index_name

|| CASE WHEN num_rows > 100000 THEN ' PARALLEL ( DEGREE Default INSTANCES Default );' ELSE ' noparallel;' END

FROM user_indexes;

but in a case of a "rollback" I wanted to know, which table (over 413 at the moment) already have (if so) already parallel activ....

do you have a faster method to find it out?