DBA Tools

How to perform bulk delete in PL/SQL for better performance?

    In Pro*C or OCI, we can use an host array as a bind value to submit array operations, it will reduce the network round trips, user calls and execute count, it can greatly improve the performance. In Java...

Posted on October 10, 2007 5:34 PM

Write Windows batch script to load the data for AUL (MyDUL)

    When recovery with AUL (MyDUL) in text mode (default mode), it will generate three files for each table (Recovery Example), then we need to execute the SQL file to create the table, and then load the data by...

Posted on September 19, 2007 7:17 PM