On IBM-AIX Oracle - there is a known issue that any queries against this table can lead to a myriad of issues.
Is the Oracle Table X$KSMSP used by Foglight?
As of the 5.7.5.37 version of the Oracle cartridge, the Foglight cartridge for Oracle does not use direct access to the Oracle X$KSMSP table as referenced by the lack of a permission to do so in the Oracle cartridge permissions script.
Please refer to the most recent permissions script for the Oracle cartridge to identify the objects used by the Oracle cartridge for monitoring instances.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center