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!

cannot generate AWR/ADDM reports in Oracle 10g

627703Apr 8 2008 — edited Apr 23 2008

Hi,

We are running 10.2.0.3.0 and troublshooted the performance problem for some queries. But when tried to run AWR/ADDM reports from OEM and got the following messages:

Insufficient Data in Interval. For displaying data on this page, two historical snapshots are needed. Make sure that two snapshots are present in the target database instance. In addition modify the interval so that it is contained within two available snapshots

I checked the scheduled jobs in this DB,

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Oracle Label Security and Data Mining options

SQL> select JOB_NAME from dba_scheduler_jobs;

JOB_NAME
------------------------------
PURGE_LOG
FGR$AUTOPURGE_JOB
GATHER_STATS_JOB
AUTO_SPACE_ADVISOR_JOB

Has anyone anyidea why AWR/ADDM reports cannot be run? Thanks

Liz

Locked Post

New comments cannot be posted to this locked post.

Locked on May 21 2008

Added on Apr 8 2008

#general-database-discussions

10 comments

4,763 views