Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: CBO question ?
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/opti
mops.htm#PFGRF001
This is a good place to start. Tahiti appears to be up now.
Ric Van Dyke
Hotsos Enterprises
Hotsos Symposium, be there:
http://www.hotsos.com/portal/events/SYM06
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andem, Venu
Sent: Thursday, March 02, 2006 11:37 AM
To: oracle-l_at_freelists.org
Subject: RE: CBO question ?
You will have to look into DBA_TABLES (LAST_ANALYZED column), i would want to point you to the exact location where you can read some info inside http://tahiti.oracle.com but somehow strangely the site is down.
If the site comes up, make sure you check the performance tuning guide, a chapter on CBO, can't remember the exact name (might be just CBO).
-Venu
-----Original Message----- From: oracle-l-bounce_at_freelists.orgstored for a particular table in the data dictionary ?
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Savio Pinto (s)
Sent: 02 March 2006 16:32 To: paul.baumgartel_at_credit-suisse.com; oracle-l_at_freelists.org Subject: RE: CBO question ? Thanks, but how can i check/verify that the statistics are
-----Original Message----- From: oracle-l-bounce_at_freelists.orgstored in the data dictionary, Oracle will use the CBO.
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Baumgartel, Paul
Sent: Thursday, March 02, 2006 9:31 AM To: oracle-l_at_freelists.org Subject: RE: CBO question ? If any table mentioned in the query has statistics
Paul Baumgartel paul.baumgartel_at_credit-suisse.com 212.538.1143 -----Original Message----- From: oracle-l-bounce_at_freelists.orgshows "Optimizer= CHOOSE", how can i force the DB engine to use the COST based optimization for a query ?
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Savio Pinto (s)
Sent: Thursday, March 02, 2006 10:28 AM To: oracle-l_at_freelists.org Subject: CBO question ? Hi, The execution plan for a query in oracle 9i
Oracle version is 9.2.0.4.0
Thanks Savio Pinto ======================================================================== ====== Please access the attached hyperlink for an importantelectronic communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
PLEASE NOTE: THE ABOVE MESSAGE WAS RECEIVED FROM THE INTERNET. On entering the GSi, this email was scanned for viruses by the Government Secure Intranet (GSi) virus scanning service supplied exclusively by Cable & Wireless in partnership with MessageLabs.
Please see
http://www.gsi.gov.uk/main/notices/information/gsi-003-2002.pdf for
further details.
In case of problems, please call your organisational IT helpdesk
Land Registry at Homebuyer Show, 17-19 March, ExCeL London
If you have received this e-mail and it was not intended for you, please let us know, and then delete it. Please treat our information in confidence, as you would expect us to treat yours.The Land Registry checks all mail and attachments for known viruses, however, you are advised that you open any attachments at your own risk.
The original of this email was scanned for viruses by the Government Secure Intranet (GSi) virus scanning service supplied exclusively by Cable & Wireless in partnership with MessageLabs.
On leaving the GSi this email was certified virus-free
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 02 2006 - 10:43:42 CST
![]() |
![]() |