Life Sciences

Improving the Performance of Oracle InForm Reports

InForm

I recently shared a project in which we helped a pharmaceutical company build studies in Oracle InForm. Today, I want to share a project that has to do with the length of time it took for a major pharmaceutical company to run Oracle InForm reports, which caused significant problems, including delays in being able to lock clinical studies. In some cases, key reports were killed after six hours of execution. Our client needed to optimize its InForm reports through performance tuning, and we did just that. The runtime for some reports went from 360+ minutes down to 2-4 minutes.

Solution Highlights

  • We met with key stakeholders to understand the challenges they faced

  • Analyzed several mega trials and the corresponding data

  • Reviewed custom reports (e.g., performance analysis on queries), the report’s requirements, and the systems the reports relied upon

  • Diagnosed, monitored, and identified which reports were problematic

  • Restructured queries to perform more efficiently and in an acceptable timeframe

Oracle - Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud
Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud

Explore key considerations, integrating the cloud with legacy applications and challenges of current cloud implementations.

Get the Guide

Key Benefits

  • 60+ reports tuned in two InForm environments

  • Running time from some reports went from 360+ minutes down to 2-4 minutes

  • Previously canceled reports were optimized to run in less than 30 minutes

  • The project was completed on time and under budget

Oracle InForm Performance Tuning Jump Start

Our Oracle InForm Performance Tuning Jump Start helps you understand the issues behind your most problematic queries and database issues.

Our seasoned life sciences team can:

  • Analyze your environment and identify problem areas

  • Provide a detailed analysis of performance bottlenecks

  • Develop an action plan to stabilize your environment

  • Tune and improve your top three most-pressing and troublesome queries

This jump start can be completed within ~5 weeks.

Does your organization face similar performance challenges? Do you have any other Oracle InForm initiatives that are coming up for which you may need to rely on an experienced team of clinical data management and IT subject matter experts? If yes, please reach out to me for more information.

About the Author

Sr. Marketing Manager, Industries, Perficient

More from this Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to the Weekly Blog Digest:

Sign Up
Categories