普通用户访问X$BH视图

sys@ORADB> create or replace view bh as select * from sys.x$bh;

View created.

sys@ORADB> create or replace public synonym x$bh for bh;

Synonym created.

sys@ORADB> conn scott/tiger
Connected.
scott@ORADB> select count(*) from x$bh;

  COUNT(*)
----------
      9698

scott@ORADB>