Different rows on v$views with different users
Hi,
I have Oracle database 12c with multitenant option (12.2.0.1.0), i have create a user in root container
create user c##test identified by tiger;
grant connect to c##test container=all;
grant set container to c##test container=all;
grant select_catalog_role to c##test;
Now i connect with user sys and execute:
SQL> select count(*) from v$waitstat;
COUNT(*)
----------
72
SQL> select count(*) from dba_hist_active_sess_history;
COUNT(*)
----------
3797
In another session connected with c##test i get:
SQL> select count(*) from v$waitstat;
COUNT(*)
----------
18
SQL> select count(*) from dba_hist_active_sess_history;
COUNT(*)