Perform the massive DELETE operation as a swap delete with parallel execution. This technique can offer significant performance gains over a straight or in-place delete operation.
By performing DELETEs as INSERTs, you can complete massive DELETE operations in your Oracle database without having to pay the heavy performance overhead.
The usual method for extracting DDL commands from objects (such as database tables, indexes, constraints, triggers, etc.) involves extracting the metadata from those objects and storing it in memory. While there are many scripts capable of doing this, they are usually incomplete and out-of-date. Luckily, Oracle 9.2 provides an API that does the trick: the DBMS_METADATA package.
If you need a solution for running Oracle stored procedures in parallel, don't reinvent the wheel with solutions that run outside the database. Execute stored procedures in parallel inside the database using Oracle's native APIs and PL/SQL.
Today's enterprise-level applications usually work on multiple database platforms, which makes code portability and maintainability increasingly important. However, porting code from one database platform to another is complex and time-consuming because database vendors use their own proprietary procedural languages.
Author Bio
