Hi,
We are about to start testing upgrade scripts (thousands) which contain A LOT of SQLs, DMLs and DDLs.
There are a lot of FTS (DMLs /SQLs) on hundreds of millions rows, e.g "update table set column1=(subselect by id) where column1 is null;", which CTAS will be preferred but there are too many like this and not enough time to do them all.
During this phase only the tool that runs the script is going to be connected to the server.
I'm in charge of tuning the process and the first thing that pops to my mind is enable parallel at the database level (both SQLs & DMLs).
I wanted to ask you:
1. How do I enable parallel query in the database level so I'll not need to use hints for parallel?
2. How can I enable parallel DML at the database level (I only saw at the session level e.g. "ALTER SESSION ENABLE PARALLEL DML;" ) ?
3. if there is command for question 2, does it requires me to change the DMLs?
And any other feedback from you guys will be welcomed...
Thanks