Reviewing SQL query performance
If response times have degraded as your study database accumulates data, you can use the Oracle InForm Performance Monitor utility to isolate long-running SQL queries. If you find long-running SQL queries, perform any of the following:
- Distribute tablespaces differently.
- Improve indexing on certain database tables.
- Run update statistics on the database.
Note:
The Oracle InForm Performance Monitor utility is not intended for extended use in a production environment because it can impact server performance over time. Oracle suggests running the Oracle InForm Performance Monitor utility at 5 to 10 minute intervals.