Database Usage Tracking Summary report hangs and it generates huge temporary files

(Doc ID 2039335.1)

Last updated on AUGUST 04, 2015

Applies to:

Enterprise Manager Base Platform - Version 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