The main new feature of Query Performance v1.6 is that we have introduced the possibility to execute queries that we have collected from an Oracle environment in another PostgreSQL environment. This allows us in a simple and fast way to see the behavior of these queries in the new environment and anticipate problems of query execution, as well as possible degradations after their execution. It is also very useful in Oracle environment migrations. Either between Oracle’s own versions. Or migrate from Oracle to PostgreSQL. This way you can compare the result of the queries before the migration. And correct errors before they occur in production. Query Performance allows you to run, measure, and compare queries, from your current Oracle environment, in another environment.
To do this, during the Replay process it is possible to create a connection to PostgreSQL that will allow us to launch the Queries: