2

We are planning to run DB maintenance scripts on our Oracle Database.

From documentation I came to know that we need to run the following scripts.

AnalyzeStats.sql
ShowTableStats.sql
ShowColumnStats.sql
ShowIndexStats.sql
RebuildIndexes.sql
PrepareAnalyzeStatsEx.sql
AnalyzeStatsEx.sql

Do we need to follow any sequence?

Is it enough if we run these scripts as username mentioned below in image or as DBA?

enter image description here

5

Doesn't that same documentation explain what these scripts do? (It does, AFAIK)

Only AnalyzeStats.sql and RebuildIndexes.sql are intended for regular maintenance; the other scripts are analytical -- to get insight in the state of the DB and whether maintenance is needed.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.