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

ORA-30484: missing window specification for this function

1 Answers  


SQL*Loader-00487: COUNT clause required for collection string

1 Answers  


ORA-26667: invalid STREAMS parameter string

1 Answers  


ORA-26079: file "string" is not part of table string.string

0 Answers   Cisco,


PCC-00135: Result Set Cursor usage is not standard SQL

1 Answers  






ORA-17612: Failed to discover Oracle Disk Manager library, return value string

1 Answers  


TNS-12200: TNS:could not allocate memory

1 Answers  


NZE-28758: memory release failure

1 Answers  


ORA-22980: must specify a set of attributes for the WITH OBJECT OID clause

1 Answers  


PCC-02424: The number of values and host variables does not match

1 Answers  


KUP-04067: internal error allocating handle type string

1 Answers  


ORA-13373: element of type extent is not supported for geodetic data

1 Answers  


Categories