I can not understand how to issue a grant to select from x $ mutex_sleep. Tried to issue a grant select any table and grant select any dictionaries , did not help. Grant clearly does not work out as well. How to be?

    1 answer 1

    In my opinion, the only option to give direct access to x$... tables is to create a view and give access to it:

     create view sys.my_x$mutex_sleep as select * from sys.x$mutex_sleep; grant select on sys.my_x$mutex_sleep to username;

    PS only sysdba can do this