Brian, I read this as 'all the SQLs are unique, and really big' - am I right? if they are unique, they MUST be hard parsed every time. In such a case, it might be worth reducing the Library Cache, to reduce the time every process needs to search through it until it does not find a preparsed object and parses itselve. just an idea, totally untested, still without enough understanding of the setup. br Martin On Fri, Jun 12, 2009 at 15:37, Zelli, Brian <Brian.Zelli@xxxxxxxxxxxxxxx>wrote: > The form for the application does build some really crappy dynamic sql, 2 > pages worth. The vendor said "oh you have to add some indexes" but that > doesn't look to be the case. I seem to be leaning toward the cursor issue > myself. I'll see what it is set to. > > >