Database Administration (MOSC)

MOSC Banner

Different rows on v$views with different users

edited Mar 9, 2020 5:10AM in Database Administration (MOSC) 7 commentsAnswered

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(*)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center