Jay In addition to the other comments you have, I have in the past met an application that used a scrollable cursor for all resultsets. This turned out to result in a query with the rowid column prepended, the initial parse however was of the desired SQL On Tue, Sep 20, 2011 at 7:31 AM, Dunbar, Norman (Capgemini) < norman.dunbar.capgemini@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote: > Morning Jay, > > >> ....So I have a bunch > >> of parsed, but > >> unexecuted queries. Seems like a waste of CPU time. > > Not to mention that fact that each and every parse, whether eventually > causing an execution or not, takes out a latch (like Highlanders, there > can be only one!) and causes a bottleneck. > > I suspect the developers and/or vendor be treated to the "big stick" and > educated in the errors of their ways. > > Good luck on that score though. > > > Cheers, > Norm. > > Norman Dunbar > Contract Senior Oracle DBA > Capgemini Database Build Team > Internal : 7 28 2051 > External : 0113 231 2051 > > > Information in this message may be confidential and may be legally > privileged. If you have received this message by mistake, please notify the > sender immediately, delete it and do not copy it to anyone else. > > We have checked this email and its attachments for viruses. But you should > still check any attachment before opening it. > We may have to make this message and any reply to it public if asked to > under the Freedom of Information Act, Data Protection Act or for litigation. > Email messages and attachments sent to or from any Environment Agency > address may also be accessed by someone other than the sender or recipient, > for business purposes. > > If we have sent you information and you wish to use it please read our > terms and conditions which you can get by calling us on 08708 506 506. Find > out more about the Environment Agency at www.environment-agency.gov.uk > -- > //www.freelists.org/webpage/oracle-l > > > -- Niall Litchfield Oracle DBA http://www.orawin.info -- //www.freelists.org/webpage/oracle-l