We run the top SQL report every day. It no longer shows the actual sql although the stats are there.
The Top SQL text depends on the Retention Policy. The default is two weeks, hence the Top SQL text will be pushed every two weeks. If the customer had changed the Retention Policy time period, its reasonable they will not see all the Top SQL texts. It’s the same behavior in the Database dashboard and Top SQL reports.
In the current version of the DBO cartridge, the clean up mechanism of the Top SQL objects has been enhanced and it can prevent issues existing in the former version of the cartridge (the customer used 5.5.8143).
Customer upgraded to the latest version of the Oracle cartridge (220.127.116.110).