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 Go to next message
Olexandr Siroklyn
Messages: 27
Registered: September 2018
Location: USA
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
Re: PL/SQL parallel execution tool [message #676091 is a reply to message #671874] Tue, 14 May 2019 04:38 Go to previous message
Olexandr Siroklyn
Messages: 27
Registered: September 2018
Location: USA
Junior Member
Update. 78 build was successfully validated on Oracle 19c database and found as compatible.
Previous Topic: McTns: a lsnrctl-like program for Windows
Next Topic: What Tool is used for Oracle Database to MySQL Migration
Goto Forum:
  


Current Time: Mon Aug 10 03:28:30 CDT 2020