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



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

Answer / guest

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

Action: 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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-00080: * force_log - ask process_name to dump its state

1 Answers  


ORA-14150: missing SUBPARTITION keyword

1 Answers  


ORA-37044: (XSACQUIRE_OLDGEN) Cannot acquire object workspace object without resync.

1 Answers  


ORA-00061: another instance has a different DML_LOCKS setting

1 Answers  


ORA-01978: Missing sequence number

1 Answers  






ORA-27413: repeat interval is too long

1 Answers  


ORA-21701: attempt to flush objects to different servers

1 Answers  


ORA-27012: skgfrd: read from file failed

1 Answers  


ORA-22053: overflow error

1 Answers  


NNF-04009: Usage: tns2nis <filename>

1 Answers  


ORA-02313: object type contains non-queryable type string attribute

1 Answers  


PCC-01200: You are not authorized to run Pro*C

1 Answers  


Categories