There are many things you can do with stats, and some of them are downright
really cool. But taking a step back from the syntax, let me ask, why or how
do you know you "need" the stats for a specific schema? Have you identified
a query and/or a column that is/are performing poorly because of missing or
inaccurate stats (or even accurate stats for that matter)? Once you answer
these questions, you can then proceed to answer other questions like "What
kind of stats do you need, in particular?"
On 10/3/06, crcbedoy_at_proteccion.com.co <crcbedoy_at_proteccion.com.co> wrote:
>
>
> Hi,
>
>
> I need your help, I am new to the usage of statistics and I need to get
> the statistics for a specific schema. I know that by using the package
> DBMS_STATS.GATHER_SCHEMA_STATS I can the statistics, but I don't know how to
> manipulate them. Could you guys give me a clue about what should I do or
> where can I find information about using this packege and manipulating
> information given by it?
>
>
> Thanks a lot for your help:)
>
> Isabel Bedoya Gómez
> Gestión de Tecnología
> Tel. 2307500 ext: 4077
--
Charles Schultz
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 03 2006 - 09:42:11 CDT
