Share:|

BMC Support or R&D might have asked for a "slow" SQL's Execution Plan and it is possible that the SQL might have aged out of Oracle's Library Cache or MSSQL's Procedure cache and hence no Execution Plan is available.

 

That would then necessitate generating an Estimated Execution Plan ("Estimated Plan" in MSSQL's SQL Management Studio or "Explain Plan" in Oracle) on the SQL extracted from AR log file.

 

The SQL does need to be complete and not truncated in order for an Estimated Plan to be generated.

 

To get the complete SQL as it was sent to the database put the following AR parameter in your ar.cfg/ar.conf file(s) and restart the AR Server(s).

 

Enable-Unlimited-Log-Line-Length: T

 

Remedy documentation - https://docs.bmc.com/docs/ars91/en/configuration-settings-e-m-609074231.html

 

Some of you already know this so it may be old news for you! :-)