How to make x$view available to user?
Is it possible to make x$views such as x$kcbcbh, x$kccts available
to other user than sys. I tried to do grant and got ora 2030 (grant
must be from a fixed view problem).
Ans:
As SYS ...
create view x_$kcbcbh as select * from x$kcbcbh;
grant select on x_$kcbcbh to public;
create public synonym x$kcbcbh for x_$kcbcbh;