drop synonym taking too long in 10.2.0.3.0

  • From: Maureen English <sxmte@xxxxxxxxxxxxxxxx>
  • To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 27 Mar 2008 10:31:26 -0800

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: