ORA-13711: Some snapshots in the range [string, string] are
missing key statistics.



ORA-13711: Some snapshots in the range [string, string] are missing key statistics...

Answer / guest

Cause: Some AWR tables encountered errors while taking one
ore more snapshots in the given range. The missing table,
being one of the key tables that ADDM looks at, renders ADDM
unable to run.

Action: Look in DBA_HIST_SNAP_ERROR to find what tables are
missing in the given snapshot range. 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 doesn't include any incomplete snapshots.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16011: Archivelog Remote File Server process in Error state

1 Answers  


ORA-09978: skxfqhdel: Error Disconnecting from another endpoint.

1 Answers  


ORA-24790: cannot mix OCI_TRANS_RESUME and transaction isolation flags

1 Answers  


ORA-33267: (DBERRRLS) Analytic workspace string cannot be accessed because it has fine-grained access control applied to it

1 Answers  


ORA-01967: invalid option for CREATE CONTROLFILE

3 Answers   Oracle,


ORA-29382: validation of pending area failed

1 Answers  


PCC-02446: FOR clause not allowed in a DEALLOCATE statement

1 Answers  


ORA-12415: A column of another datatype exists on the specified table

1 Answers  


ORA-27491: repeat_interval and start_date cannot both be NULL

1 Answers  


ORA-00382: %s not a valid block size, valid range [string..string]

1 Answers  


QSM-01049: semi-join check failed for materialized view, string

1 Answers  


ORA-31040: Property string: XML type (string) not compatible with internal memory type (string)

1 Answers  


Categories