RE: performance in 10g

What, exactly, is "the latest stat"? Do you have histograms, did you collect system statistics, are you problems related to only few SQL statements or a large part of them? Do you have plans from the previous version? Have you tested it, prior to doing upgrade?

Mladen Gogala
Sr. Oracle DBA
1500 Broadway, 6th floor
New York, NY 10036
(212) 329-5201
www.vmsinfo.com

The Leader in Integrated Media Intelligence Solutions

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-
> bounce_at_freelists.org] On Behalf Of David Boyd
> Sent: Thursday, January 25, 2007 9:10 AM
> To: Riazouddine.Rahamathullah_at_brooks.com; oracle-l_at_freelists.org
> Subject: RE: performance in 10g
>
> Riaz,
>
> Thanks for your quick response. We do have the latest stats in
> place.
>
> Dave
>
> >Gather the objects statistics first using DBMS_STATS which will
> help you
> >to improve the performance a lot. Because, no RBO in oracle 10g
> and the
> >optimizer will give you the optimized plan if your db should have
> the
> >latest stats.
>
> _________________________________________________________________
> Search for grocery stores. Find gratitude. Turn a simple search into
> something more.
> http://click4thecause.live.com/search/charity/default.aspx?source=hm
> emtagline_gratitude&FORM=WLMTAG
>
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l