My Oracle Support Banner

Attempting SQL Tuning Advisor Using Historical SQL (AWR) Presents Insufficient Data In Interval. (Doc ID 2894283.1)

Last updated on DECEMBER 10, 2022

Applies to:

Enterprise Manager for Oracle Database - Version and later
Information in this document applies to any platform.


SQL Tuning Advisor using Historical SQL (AWR) presents the following error:
Insufficient Data in Interval. For displaying data on this page, two historical snapshots are needed. Make sure that two snapshots are present in the target database instance. 



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.