Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to start AWR gather stats?

Beauty_and_dBestNov 28 2018 — edited Dec 3 2018

12c

OL6

Hi ALL,

I check the statistics history table using:

SQL> select min(SAVTIME), max(SAVTIME) from wri$_optstat_tab_history;

MIN(SAVTIME)

---------------------------------------------------------------------------

MAX(SAVTIME)

---------------------------------------------------------------------------

03-OCT-18 01.28.08.135820 PM +08:00

SQL>

SQL> show parameter statistics_level

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

statistics_level string TYPICAL

I can see above that I have only 1 day statistics? and no data gathered upto date?

Please help how to continuously gather stats and have rentention of 1 week only.

Kind regards,

This post has been answered by Mark D Powell on Nov 29 2018

Jump to Answer

Added on Nov 28 2018

#general-database-discussions

12 comments

639 views