Skip to Main Content

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!

Why Oracle 11.2.0.3.0(Single Instance) For Linux x64 has not generated AWR data?

Quanwen ZhaoNov 3 2017 — edited Nov 8 2017

Hello,experts

Recently,i found a strange situation about not generating AWR data in my Oracle 11.2.0.3.0(Production System),

At the same time, considering about whether the size of tablespace 'SYSAUX' is used to 100% approximately first,

My check process as follow,

1509690914(1).png

And it's only used to 8.2%,

Secondly,continue to check VIEW dba_hist_snapshot and found that there has no snapshot records.

SYS@resbak> select count(*) from dba_hist_snapshot;

COUNT(*)

----------

     0

At this very moment,how to troubleshooting this issue for me ?

I hope experts to help me analyze,thanks a lot.

Best Regards,

Quanwen Zhao

This post has been answered by Quanwen Zhao on Nov 6 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 5 2017
Added on Nov 3 2017
24 comments
1,039 views