The knowledge base has an article on checking/verifying the data_engine is deleting raw and historic QoS from the RN_ and HN_ DB tables. However, the query assumes the DB is MS SQL (see attached). How could this same query be run against an Oracle DB (taking into account the syntax differences between MS SQL and Oracle?
A KB was written for this.
UIM - How to verify data_engine maintenance for Or - CA Knowledge