HomeOracleOracle Error ORA-13707: Either the start snapshot string or the end snapshot string is incomplete or missing key statistics.

Oracle Error ORA-13707: Either the start snapshot string or the end snapshot string is incomplete or missing key statistics.

Oracle Error Message

ORA-13707: Either the start snapshot string or the end snapshot string is incomplete or missing key statistics.

Reason for the Error

Either the start or the end snaphots was missing or purged or had encountered errors while creating them.

Solution

Verify that AWR is done taking these two snapshots, or Look in DBA_HIST_SNAP_ERROR to find what tables are missing in the start/end snapshots. Use the ERROR_NUMBER column in that view together with the alert log to identify the reason for failure and take necessary action to prevent such failures in the future. Try running ADDM on a different snapshot range that has valid start and end snapshots.

Share:

Leave a Reply

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...