Re: Oracle 9i Latching Issue

From: <sybrandb_at_hccnet.nl>
Date: Fri, 28 Mar 2008 20:12:41 +0100
Message-ID: <kngqu3t2crac56jgjqnmbbc7158hu5kq5n@4ax.com>


On Fri, 28 Mar 2008 06:44:14 -0700 (PDT), Johne_uk <edgarj_at_tiscali.co.uk> wrote:

>
>The bulk of apps on the server are 3rd party and I do not have the
>ability to rewrite the sql as its embedded into the actual
>applications

Check out the dbms_advanced_rewrite package. Probably won't help when they are not using bind variables.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Fri Mar 28 2008 - 14:12:41 CDT

Original text of this message