Spotlight on Oracle/RAC are creating X$ views in the SYS schema.
Can I run into any conflict with the Oracle support due to this objects in the SYS schema?
Spotlight requires access to the X$ views in order to gather certain performance information about the database.
According to Oracle this is the correct way to allow a non-sys user to have access to these views, please see Metalink note 453076.1.
Please also note that Oracle uses a similar technique itself: for example, by the statspack install scripts. So what Spotlight does should not create an issue with Oracle support.
To get a list of the Oracle database objects please go tohttp://support.quest.comand download the documentation Spotlight on Oracle v5.0 Databases Objects and Privileges.
This document listed all Spotlight objects (version 5.0 and higher).
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center