Improved Resource Usage During Compliance Checking

Oracle Orachk and Oracle Exachk use database connection pooling to optimize resource usage during compliance checks.

By default, Oracle Orachk and Oracle Exachk use a dedicated daemon process called the SQL Agent. The SQL Agent maintains a pool of database connections, enabling queries to reuse existing connections instead of establishing a new database connection for each query.

If Oracle Orachk or Oracle Exachk encounters a problem with the SQL Agent, the tool automatically falls back to SQL_Plus. When SQL_Plus is used, a new database connection is established for each query execution.

If you encounter database connection issues, errors, unexpected results, or possible false positives or false negatives associated with the SQL Agent during discovery or check execution, use the -use_sqlplus option to bypass the SQL Agent.

For Oracle Orachk:

orachk -use_sqlplus

For Oracle Exachk:

exachk -use_sqlplus

The -use_sqlplus option instructs Oracle Orachk or Oracle Exachk to use SQL*Plus for database query execution instead of the SQL Agent.

If the issue persists, contact My Oracle Support and provide the relevant Oracle Orachk or Oracle Exachk logs and output for further investigation.