I can't use it.
Daniel Ramos, March 07, 2017 - 9:12 am UTC
I has given you incomplete information, I apologize.
I have standard license. I can't use parallel features.
I'm looking for a solution compatible with standard license.
Sorry to make you lost time.
Regards.
March 07, 2017 - 3:10 pm UTC
Dbms_parallel_execute is available in Standard Edition!
Alex, March 07, 2017 - 4:49 pm UTC
I remember back in older releases Tom mentioned to use parallelism with caution, because it is basically telling Oracle to use as much of the server's resources as it feels like to accomplish the task. So in theory one session could bring everything to it's knees. Is this still true on 12c?
March 07, 2017 - 11:44 pm UTC
Every serial query tells the database - you can use my session to work the server as hard as you can to get the result. But its only one process, so its pretty much going to consume 1 core at most.
parallel 'n' is telling the database "you can use up to 2n processes to work as hard as they can to get the result". So this could consume up to 2n cores on your server. It's not a great deal different to that many individual processes running flat out - but of course, it would be unwise to set no limits on what 'n' could be.