Re: Using DBMS_JOB and DBMS_PIPE to mimic multithreaded PL/SQL application

Pete Finnigan <plsql_at_petefinnigan.com> wrote in message news:<8I2$qRB6J2u$QxbT_at_peterfinnigan.demon.co.uk>...
> Hi Paul,
>
> without seeing your complex logic I have to say 5 hours for 5000 records
> does not sound very good. I fixed a PL/SQL batch process a few years ago
> that processed millions (7-10 million) of financial transactions per
> night in 18 hours to process them in approx 2 or less. This process
> loaded data using sql*loader and used complex pl/sql (few thousand
> lines) and many different processes depending on transaction types to
> populate a lot of tables. We did parallel up some of the processing
> where possible but also tuned the bad SQL and PL/SQL. The tuning and
> sorting out badly laid out tablespaces/datafiles on disk fixed most of
> it. The i/o was all over the place and it didn't use RAID.
>
> Maybe you should consider tracing profiling and tuning the SQL and
> PL/SQL first?
>
> kind regards
>
> Pete

Why would anyone solve a problem, when you can 'workaround' it and make yourself indispensable by creating your own mess?

Sybrand Bakker
Senior Oracle DBA Received on Thu Nov 20 2003 - 15:17:54 CET