Analyze oracle 9i

[salvareztur]

Hi everione, In my bd I have 3 partitioned tables, I try to analyze them and it takes a long time for each partition , more than 20 minutes.
Can anybody help me??
Thank you
Sonia.

[pando]

use dbms_stats

go tahiti.oracle.com

[salvareztur]

Using this package I haven´t to delete last analyzed of partitions???

[salvareztur]

Se puede continuar en español?

[pando]

dbms_stats lets you to analyze in parallel

[pando]

Originally posted by salvareztur
Se puede continuar en español?

of coz not

[salvareztur]

Este pl analiza tablas enteras no?? yo sólo quiero analizar algunas particiones de mis tablas, se le pasa el nombre de la partición como parámetro y ya o hay que pasarle otros parámetros??

[pando]

sorry this is an English forum as you might have noticed from my previous reply

[salvareztur]

Sorry, I don´t understand you, sorry sorry.
Well I try to continue in English.
This PL analyze full tables or also can analyze partitions of one table.
I only want to analyze some partitions of my partitionated tables.

[pando]

well if you looked my thread and go to tahiti.oracle.com you would see how this package works