WRM$_SNAPSHOT_DETAILS Table is Not Purged
Last updated on SEPTEMBER 19, 2016
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.2 to 12.1]
Information in this document applies to any platform.
The following symptoms are observed:
- AWR purge code is not automatically purging WRM$_SNAPSHOT_DETAILS, as expected
- Even after dropping a range of snap id's using dbms_workload_repository.drop_snapshot_range(), the table is not purged.
- Table WRM$_SNAPSHOT_DETAILS grows indefinitely.
- There are many orphaned entries in the table WRM$_SNAPSHOT_DETAILS.
The number of orphaned rows for the table WRM$_SNAPSHOT_DETAILS can be found by running the following sql:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms