Connect Oracle Server for performance data

  1. Create a new Visual Expert project with Oracle code.
  2. Select your code from the database - NOT folders/files.

Connect Oracle Server for performance data

Which database will you analyze?

The choice of the database analyzed will determine from where you will collect performance statistics. Ideally, you would analyze a production database. If you don’t have the proper access rights for production, then a test or development database might work, as long as it is enough used to generate relevant performance statistics.

  • Specify and test your database connection.
  • Start the code analysis.
  • Activate the code performance features.

When the analysis is completed, open the tab "Performance" in the Ribbon menu and click on "Activate".

Connect Oracle Server for performance data

This will configure Visual Expert to collect automatically some performance statistics, each time a new code analysis is starting.

After clicking on "Activate", Visual Expert will check it can access the required views and data in your Oracle database. An error message will pop up if an issue is detected.

Refresh your code analysis (Ctrl+F5) once, to fetch the performance statistics from your Oracle database.

You can stop collecting execution statistics anytime: Simply open the performance tab and click on "Deactivate"