Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: 9.2.0.6 Optimizer issue

RE: 9.2.0.6 Optimizer issue

From: Ken Naim <kennaim_at_gmail.com>
Date: Tue, 24 May 2005 16:58:07 -0500
Message-ID: <4293a36f.6099545f.4293.26c9@mx.gmail.com>


I am developing a new application and wanted to know if someone could refer me to document or web page that shows the proper method(s) of backing up statistics.

Thanks,
Ken

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wolfgang Breitling
Sent: Friday, May 06, 2005 10:52 AM
To: Ignizio, Richard
Cc: oracle-l_at_freelists.org
Subject: Re: 9.2.0.6 Optimizer issue

responses inline

Ignizio, Richard wrote:

> As of right now I do not back up old statistics, but I might make it a
practice now.

DO, not might

> The database was shutdown before the application upgrade for backups,
would that erase the contents of the sys.col_usage$ table?

Not normally

> Would histograms affect whether Oracle chose to do a NL or a HJ?

Histograms can affect not only the choice of join method but other plan particulars as well. So can any number of statistics.

--
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 24 2005 - 18:02:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US