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@xxxxxxxxx> 
Enviado por: oracle-l-bounce@xxxxxxxxxxxxx
03/10/2006 09:42
Por favor, responda a
sacrophyte@xxxxxxxxx


Para
crcbedoy@xxxxxxxxxxxxxxxxx
cc
oracle-l <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxxxxxx <crcbedoy@xxxxxxxxxxxxxxxxx > 
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

Other related posts: