Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 12c selecting cdb users is returning different results

Neo-bMar 14 2017 — edited Mar 16 2017

Dears,

I am using Oracle 12cR1 on Linux.

I am connecting to CDB$ROOT as sys.

When I:

select * from cdb_users;

sometimes (on different sessions) it returns info for all the users (including all PDBs) and sometimes it returns only users for con_id 1

I am not able to identify when this behavior is happening sometimes I exit the sqlplus sessions and log in again, it will give results from all PDBs and sometimes only from con_id=1 only!

Any one else is facing this?

This post has been answered by Markus Flechtner on Mar 16 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 20 2023

Added on Mar 14 2017

#database-key-features, #multitenant

15 comments

1,574 views