Re: plan_table?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 27 Feb 2006 08:14:22 -0800
Message-ID: <1141056862.625848.237230@v46g2000cwv.googlegroups.com>

Analyzed means that statistics exist on the table.

The Oracle version# Reference manual contains information on the optimizer_mode settings.

You should always include the Oracle edition and version number in a Oracle newsgroup post. The plan table has changed several times between major releases so it is wise to always recreate it, if you use a common plan table or have one allocated, with every major upgrade.

HTH -- Mark D Powell -- Received on Mon Feb 27 2006 - 10:14:22 CST