FCBAsyp is a software providing possibility to run Oracle PL/SQL code in simultaneous asynchro-parallel mode on Oracle 11g, 12c, 18c or 19c 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

      

    •  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
        • 

      

      • 

    

    • 



How it works


Customer Oracle PL/SQL program calls FCBAsyp package’s procedure and passes unlimited count of parameters to it. Parameters are any PL/SQL units to run. FCBAsyp package’s procedure initiates FCBAsyp’s Java module to call Oracle SQL*Plus external utility to connect to the database and to run passed PL/SQL units in parallel way. Once PL/SQL units are started they work asynchronously.


License


FCBAsyp is a try-and-buy software. Trial period is 30 days.


Price


50 USD or 40 EUR per 1 license.


Payment




What’s new


    

  • Sep 21, 2018.

      

    • Initial 78 build released. 32 parallel execution tasks set up by default
      • 

    

    • 

  • May 14, 2019.


    • 



Downloads


    

  • Unix

      

    • version: 2.1.78 size: 41 Kbytes md5: 980673e198b1f7d3cbbf37649124017b 
      Download
      • 

    

    • 



Found a bug? Please use this link to report.


Questions? Propositions? Comments? Let me know what you think via email