Home » Other » Marketplace » PL/SQL parallel execution tool (Oracle database, from 11g to 18c, Unix)
PL/SQL parallel execution tool [message #671874] Fri, 21 September 2018 05:01
Olexandr Siroklyn
Messages: 2
Registered: September 2018
Junior 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.
  • It works
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
Previous Topic: Encryption tool
Next Topic: Take Database Development to the Enterprise Level with dbForge Studio for Oracle
Goto Forum:
  


Current Time: Sat Oct 20 01:05:32 CDT 2018