There are two Oracle bugs which could cause the issue:
To get an exact analysis which bug is affecting you, please contact the Oracle support.
A SQL query issued by PI may cause a ORA-00600 733 error because the query uses "OR" to query "V$SQL_PLAN" which can cause performance issue.
RESOLUTION 1 * This is the preferred option *
If the problematic Oracle database is still on version 126.96.36.199/3 please upgrade to 188.8.131.52 or 12c.
If an upgrade it not possible or if the database has already version 184.108.40.206, there are 2 options you can do in Foglight to avoid the ORA-600:
To disable SQL PI go to Database Overview dashboard and select the problematic agent. Click on "Settings | Administration" and select "SQL Performance Investigator" on the left hand side. Now disable the PI Extension.
NOTE: If the SQL plan collection will be disabled, you will miss metrics about executions plans.
To disable the plan collection download the attached script and unzip it. Before you run it change the first line and enter the agent name there, not the SQL PI agent name, the actual monitored instance name:
agentName = "
Now follow the steps below:
Once Oracle fixed bug 19846328 you can use the script to enable the plan collection again. To do so, you need to change the third line
aspValue = "0";
aspValue = "5";
Again run the script in the Script Console as described above.
The SQL query used to collect Oracle plans have been enhanced as CR FOM-298 in the 220.127.116.11 and higher releases of the Oracle cartridge. Please upgrade to the latest release of the Oracle cartridge.
An additional enhancement to the query has been included in the 18.104.22.168 and higher releases of the Oracle cartridge.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz