Re: Gathering statistics for a specific schema

Hi Charles,

Well, this schema owns the core business aplication and we are migrating it from 9i to 10g, the problem is that this application presents problems after migrating it to 10g, problems with most of the queries it does, that's why the application provider and we want to follow the whole schema performance in 10g to be able to take decisions about what we should tune in the database or the application itself, because this is not the only schema we have, we have about 15 other different schemas being migrated to 10g.

Regards,

Isabel Bedoya Gómez
Gestión de Tecnología
Tel. 2307500 ext: 4077

"Charles Schultz" <sacrophyte_at_gmail.com> Enviado por: oracle-l-bounce_at_freelists.org 03/10/2006 09:42
Por favor, responda a
sacrophyte_at_gmail.com

Para
crcbedoy_at_proteccion.com.co
cc
oracle-l <oracle-l_at_freelists.org>
Asunto
Re: Gathering statistics for a specific schema

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