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-01286: start interval required

1 Answers  


RMAN-10033: error during compilation of job step number: string

1 Answers  


ORA-23538: cannot explicitly refresh a NEVER REFRESH materialized view ("string")

1 Answers  


ORA-27089: unable to release advisory lock

1 Answers  


ORA-07218: slkhst: could not perform host operation

1 Answers  






EXP-00050: Cannot perform Partition Export "string" on non-partitioned table "string"

1 Answers  


ORA-03203: concurrent update activity makes space analysis impossible

1 Answers  


PCB-00502: This statement can only be used with THREADS=YES

1 Answers  


SQL*Loader-00423: element count is greater than maximum allowed for the column

1 Answers  


ORA-13234: failed to access R-tree-index table [string]

1 Answers  


ORA-00330: archived log ends at change string, need change string

1 Answers  


TNS-01106: Listener using listener name string has already been started

1 Answers  


Categories