Capture Oracle Reports queue data to help migration analysis.
This is a copy of
$ORACLE_HOME/reports/admin/sql/rw_server.sql
Following the instructions in this blog, we can record the Oracle Report requests in a table. This means we can analyse who is running which reports how often, which will help drive a migration plan to declarative APEX solutions, or perhaps integrate something like AOP.
- Create schema
- Create tables in schema
- Add configuration to WLS, restart
- Bathe in delicious log data (who, what, when, how long)
Identify those poorly performing reports by comparing the start and finish time.
I also raved about this on #ThanksOGB day.