Re: Gathering of Statistics

I sort of disagree with Jack and Mark. I'd say that if the application had
specific design requirements (i.e.the designers understood Oracle and
performance optimisation) then it would be reasonable to expect the vendor
to supply detailed scripts and/or a supported method of gathering optimizer
stats. In any case I would expect the vendor to be aware of the need to
supply a modern RDBMS with appropriate stats and to have a view on what was
appropriate for their application - even if only "you should/should not
collect optimizer stats ".



On Jan 25, 2008 2:20 PM, Powell, Mark D <mark.powell@xxxxxxx> wrote:

>
> I agree with Jack.  Also with 10g plus the Oracle provided statistics
> gathering script is going to make the decision when to update the schema
> statistics unless you disable or otherwise modify it.
>
>
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Jack van Zanen
> Sent: Fri 1/25/2008 7:10 AM
> To: ronnie_doggart@xxxxxxxxx
> Cc: oracle-l@xxxxxxxxxxxxx
> Subject: Re: Gathering of Statistics
>
> I do not expect them to supply the scripts, however I do expect them to be
> able to supply the information needed for proper statistics.
>
> It often is a futile expectation though.
>
>
> Jack
>
>
> On 25/01/2008, Ronnie Doggart <ronnie_doggart@xxxxxxxxx> wrote:
> >
> > Hi All,
> >
> > If you purchase an application from a supplier would you expect them to
> > supply a script for gathering statistics on their schema and to make
> > recommendations on how frequently the statistics should be gathered ?
> >
> > Ronnie
> >
> >
> >
> > The information in this message is confidential and may be legally
> > privileged. It is intended solely for the addressee. Access to this
> message
> > by anyone else is unauthorised. If you are not the intended recipient,
> any
> > disclosure, copying, or distribution of the message, or any action or
> > omission taken by you in reliance on it, is prohibited and may be
> unlawful.
> > Please immediately contact the sender if you have received this message
> in
> > error.
> >
> > The views and opinions expressed in this email may not reflect the views
> > and opinions of any member of Lagan Technologies Limited, or any of its
> > subsidiaries.
> >
> > Lagan Technologies Limited is a company registered in Northern Ireland
> > with registration number NI 28773. The registered office of Lagan
> > Technologies Limited is 209 Airport Road West, Belfast, Co. Antrim, BT3
> 9EZ.
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
> --
> J.A. van Zanen
>
>


-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

Other related posts: