| PL/SQL parallel execution tool [message #671874] |
Fri, 21 September 2018 05:01  |
 |
Olexandr Siroklyn
Messages: 42
Registered: September 2018
Location: USA
|
Member |
|
|
http://www.oracleongpu.com/fcbasyp/
FCBAsyp is a software providing possibility to run Oracle PL/SQL code in simultaneous asynchro-parallel mode on Oracle 11g, 12c and 18c databases where standard Oracle database parallel execution ways aren't fast or restricted or just unacceptable.
Why FCBAsyp?
A few ways exist to execute PL/SQL code in parallel mode in Oracle database:
via DBMS_SCHEDULER package
Pros. - A standard package for any Oracle editions starting from 10g version
- A minimal latency to commit (one-by-one) PL/SQL units to launch them in parallel mode
Cons.
- Fast commit doesn't mean fast launch
- Dependence on JOB_QUEUE_PROCESSES parameter, i.e. 1000 pcs. for 10g, 11g, 12c and 4000 pcs. for 18c database versions
- The actual number of parallel processes created by DBMS_SCHEDULER is auto-tuned by the Oracle database scheduler depending on several factors, including available resources, resource manager settings, and currently running processes*, thus
- Unpredictable count of simultaneously running parallel processes is guaranteed
via DBMS_PARALLEL_EXECUTE package
Pros.
- A standard package for any Oracle edition starting from 10g version
Cons.
- Too complicated (a lot of preliminary steps) and therefore too slow, i.e. create chunk table, create task, split the workload into chunks, run the task etc.
a William Robertson's way http://www.williamrobertson.net/documents/parallel-plsql-launcher.html
Pros.
Cons.
- Oracle Enterprise Editions only
- Too complicated usage
via FCBAsyp software
Pros.
- All editions of Oracle database (excluding XE edition) are supported for 11g, 12c and 18c versions
- All kinds of PL/SQL program units supported
- No any dependence on JOB_QUEUE_PROCESSES parameter
- Adjustable CPU's utilization from low to extreme high value
- Recursive launch possibility
- Up to 15% faster than DBMS_SCHEDULER way
- Due to "external nature" of FCBAsyp software you can run it on one host and distribute code execution to the different hosts
- No named user license nor license per processor required. Only license per database instance
Cons.
- Java database component should be loaded and valid
- Windows support is experimental
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
