Re: Oracle 9i Latching Issue
From: <sybrandb_at_hccnet.nl>
Date: Fri, 28 Mar 2008 20:12:41 +0100
Message-ID: <kngqu3t2crac56jgjqnmbbc7158hu5kq5n@4ax.com>
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 DBAReceived on Fri Mar 28 2008 - 14:12:41 CDT
