Discussion :

[Celestos]

Bonjour à tous,

question de newbie aux grands gurus que vous êtes.

D'avance merci

Celestos

[SheikYerbouti]

http://download-east.oracle.com/docs...s.htm#ARPLS059

[Celestos]

Cool ! Merci.

Je viens de lire la doc en question. Cependant, je ne trouve pas comment via DBMS_STAT, faire un équivalent de (si cela est possible) :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

analyze index <nom index> validate structure

[Wurlitzer]

http://http://download-uk.oracle.com...htm#SQLRF01105

Note:
Do not use the COMPUTE and ESTIMATE clauses of ANALYZE to collect optimizer statistics. These clauses are supported for backward compatibility. Instead, use the DBMS_STATS package, which lets you collect statistics in parallel, collect global statistics for partitioned objects, and fine tune your statistics collection in other ways. The cost-based optimizer, which depends upon statistics, will eventually use only statistics that have been collected by DBMS_STATS. See PL/SQL Packages and Types Reference for more information on the DBMS_STATS package.

You must use the ANALYZE statement (rather than DBMS_STATS) for statistics collection not related to the cost-based optimizer, such as:
* To use the VALIDATE or LIST CHAINED ROWS clauses
* To collect information on freelist blocks

[Celestos]

Encore merci de vos réponses