Does your query select any clob or blob data? On 7/9/05, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > Ian Skinner wrote: > > Well we have more information on the problem. The query that was running > > fairly well at 30 seconds or so was being run against a validation database > > where the data is static. > > > > The query that was performing poorly at 18 minutes was being run against > > the production server where the data is very active. Apparently every time > > data was being added to the main tables, this query would be started over. > > So depending on the traffic sometime it performs relatively well other > > times it performs very poorly. > > That sounds rather vague. Does the DBA mean the database was > running out of rollback segments and instead of just returning an > error was somehow retrying the query? > > Jochem > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211507 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54