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>
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.
- Maureen English University of Alaska Fairbanks, AK -- http://www.freelists.org/webpage/oracle-l