Dear all



Something rather peculiar is happening within our database. A script
(which writes a file to the UTL directory of the Oracle database) is
taking 10+ hours to execute at various times during the day. When the
script was executed this morning (around 8am GMT) it completed in 20
minutes! Immediately after that, it was back to taking ages to complete.



The script itself selects from 4 or 5 tables within our database. Each
of the tables had between 50 - 150 million records in them (not all of
which were required), so now each time the script executes, the tables
are truncated, prior to having only relevant data inserted into them.
Apart from the issue with the number of rows, has anyone got any
suggestions as to why the execution time for the script is so long? Or,
where I should be looking in terms of trying to come up with an
explanation?



Thanks in advance



Paul






______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________

Oracle LazyDBA home page