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?