Database Usage Tracking Summary report hangs and it generates huge temporary files
Last updated on AUGUST 04, 2015
Applies to:Enterprise Manager Base Platform - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
The query underlying the Database Usage Tracking Summary Report hangs and large temporary files are created.
The collection frequency has been changed from Weekly to Hourly, to get fast feedback, hence, the data collected was huge and the SYSMAN.EM_LMS_DBA_FEATU_USAGE_STAT table size was growing.
See the following reference for the report generating procedure:
Enterprise Manager Cloud Control Administrator's Guide
12c Release 5
Chapter 28 Creating Usage Tracking Reports
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms