RE: No stats, why the heck is CBO running???
- From: "Singer, Phillip (P.W.)" <psinger1@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 20 Jul 2004 10:52:19 -0400
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Grabowy, Chris
> Sent: Tuesday, July 20, 2004 10:40 AM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: No stats, why the heck is CBO running???
>=20
>=20
> Hello All,
>=20
> We have NO stats on all the tables/indexes in SYS. Parallel=20
> and instances for all tables/indexes in SYS is set to 0 or 1.=20
> The optimizer mode is set to CHOOSE. We are not using any=20
> new features that requires the CBO. =20
>=20
> Yet a simple query to find the "next extext that wont fit" is=20
> always using the CBO??? =20
>=20
> This SQL queries DBA_TABLES and DBA_FREE_SPACE. There are NO=20
> hints in the SQL. =20
>=20
But there _is_ a hint in the view definition for DBA_FREE_SPACE.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
