RE: No stats, why the heck is CBO running???

From: Singer, Phillip (P.W.) <psinger1_at_ford.com>
Date: Tue, 20 Jul 2004 10:52:19 -0400
Message-ID: <A45063A7D336504580F0161CEB7FEBE201AE796B@na1fcm60.dearborn.ford.com>

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Grabowy, Chris
> Sent: Tuesday, July 20, 2004 10:40 AM
> To: oracle-l_at_freelists.org
> 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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Jul 20 2004 - 09:49:54 CDT