Skip to content
Capture Oracle Reports queue data to help migration analysis
PLSQL
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
LICENSE
README.md
rw-server.sql

README.md

orclapex-rw-server

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.

You can’t perform that action at this time.