How can I monitor the progress of an update statistics

[former_member261388]

Hi all

Rigth now, i´m implementing note 424239, with parameter stats_dbms_stats and I´m trying to compare the execution without applyning this parameter.

So please, let me know How can I monitor the progress of the execution of an update statistics on Oracle 10.2.0.2.0

Regards

[stefan_koehler]

Hello Oliver,

as you told you are using Oracle 10g, you can use the AWR / ASH report to compare the two "different" statistic collections.

1) Create an AWR report for the whole database and hope that the statistic statement is one of the expensive ones

2) You can grep the SQL-ID via V$SESSION and get the statement details through a report out of the AWR

The scripts are under "/oracle/<SID>/102_64/rdbms/admin/":

• awrrpt.sql => Whole database

• awrsqrpt.sql => SQL statement report

Regards

Stefan