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!

Snapshot List For Generating AWR Report Displaying a Blank/empty Page

2723794Nov 20 2014

Hi All,

I am using Oracle database version 11.2.0.3.0 Enterprise Edition. This is new environment setup hosted on Linux. I have noticed there is no snapshot generated in this database. I have verified DBA_HIST_WR_control and see the snap_interval which is set on default only ( 1 hr). Also DB parameters like statistics_level=typical, times_statistics set to true and control_management_pack_access= DIAGNOSTIC+TUNING. I tried to generate snapshot manually but failed with below error. Parent key not found, how this possible? there is no change done after configure this environment. Can any one help me how to fix this ?

SQL> exec DBMS_WORKLOAD_REPOSITORY.create_snapshot();

BEGIN DBMS_WORKLOAD_REPOSITORY.create_snapshot(); END;

ERROR at line 1:

ORA-13509: error encountered during updates to a AWR table

ORA-02291: integrity constraint (ORA-02291: integrity constraint

(SYS.WRM$_SNAPSHOT_FK) violated - parent key not found

.) violated - parent key not found

ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 99

ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 122

ORA-06512: at line 1

Thanks,

Suchi

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 18 2014

Added on Nov 20 2014

#general-database-discussions

0 comments

618 views