Monitor the two databases - native PostgreSQL/Oracle and the embedded cdb.
PostgreSQL and Oracle
Page:
Vacuum process for PostgreSQL databases— Database vacuuming is a way to increase the table and database performance of a PostgreSQL database. Learn how to use the vacuum process to clean the database.
Optimize CDB - fast index rebuilding— The censhare embedded database (CDB) saves resources through compression and fast rebuilding of the index. In addition, find comprehensive statistics to evaluate the data structure.