Oracle Database Enterprise (11g R1 or later)
Strong hardware (more that 1 CPU, minimum 1G memory)
Complex processing like (e.g. billing task, contract processing, …)
Maximize using power of your hardware
Minimize time of processing
Minimize effort to rewrite existing batch application to parallel
It can be used like First Aid
When is useful to use Transactional Parallel Processing?
Takes time of processing your PL/SQL too long even if you have strong Hardware?
You don’t have time to rewrite PL/SQL sources to optimize them?
If your answer is yes, then our product Transactional Parallel Processing for Oracle is exactly for you.
How does it works?
The Transactional Parallel Processing package is useful primary in tasks where is required parallel processing to use maximal CPU with minimal effort to rewrite current applications.
It can be also used like first aid in case of low performance PL/SQL code.
The most interesting benefit is transactional behavior. It allows you rewrite only part where is required to use parallel processing without rewriting rest of the code. There’s detection of COMMIT operation.
When is after the part of parallel processing in the main session COMMIT, then is while finalization provided COMMIT in all parallel processed sessions.
Otherwise is proceed after processing in all parallel sessions to execute ROLLBACK operation.
The transactional behavior minimize effort to rewrite current PL/SQL code.