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.
Printable View
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.
use dbms_stats
go tahiti.oracle.com
Using this package I haven´t to delete last analyzed of partitions???
Se puede continuar en español?
dbms_stats lets you to analyze in parallel
of coz notQuote:
Originally posted by salvareztur
Se puede continuar en español?
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??
sorry this is an English forum as you might have noticed from my previous reply
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.
well if you looked my thread and go to tahiti.oracle.com you would see how this package works