|
-
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?
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|