drop synonym taking too long in 10.2.0.3.0

From: Maureen English <sxmte_at_email.alaska.edu>
Date: Thu, 27 Mar 2008 10:31:26 -0800
Message-ID: <47EBE7FE.5020603@email.alaska.edu>


Has anyone found a reasonable solution to this problem?

I've found information on Metalink that it's due to a bug, but the suggestions either don't help (alter session commands) or are unreasonable (alter system set optimizer_features_enable='9.2.0').

We're finally getting a handle on the 10g optimizer and don't really want to set the features to 9.2.

Received on Thu Mar 27 2008 - 13:31:26 CDT

Original text of this message