Sonarcanner for plsqlopen take longer time as expected

Essential information:

SonarScanner →
Sonarqube → 7.9 community
SonarQube deployed → Kubernetes


We’re trying to scan a sql repository which is taking between 1hr and 45 minutes for complete the scan.

I’ve seen one file have an average of 92 line of code which take like 45 minutes and we want decrease this scanner time.

these are the approach taken:

  1. Update SONAR_SCANNER_OPT with -Xmx4056m
  2. Execute in difference SO (unix, Windows)
  3. Use parameters such as: -D"sonar.language=plsqlopen" -D"sonar.lang.patterns.plsqlopen=**/*.sql to avoid other plugins


Considering that you’re using SonarQube Community and you mentioned “plsqlopen”, I guess you’re using my plugin.

However, I noticed that you’re using SonarQube 7.9, which is a deprecated version that I no longer support. I recommend that you upgrade to the latest version of SonarQube, upgrade to the latest release of the plugin and see if that solves your problem. Also, please note that this is not the right forum to ask for support for it, please use the GitHub issues instead.