From: Andy Klock <>
Date: Wed, 21 Nov 2012 11:30:41 -0500
Message-ID: <>

+1 on the benefits of force_matching_signature when cursor_sharing is used (though I have a love/hate, mostly hate with FORCE) Just note that it loses some of its usefulness when SQL has both binds and literals. You can also do some pretty fancy stuff with DBMS_TUNE.SQLTEXT_TO_SIGNATURE (requires tuning pack) if you want to compare SQL and not have to worry about case, whitespace, literals, etc):


On Wed, Nov 21, 2012 at 11:00 AM, <> wrote:

> Dom,
> Thanks for the tips - I think force_matching_signature may be the way to
> go as that makes the analysis SQL easier to manage to gather the data I'm
> looking for.
> Thanks again.
> Chris

Received on Wed Nov 21 2012 - 17:30:41 CET

Original text of this message