Re: CDB_USERS

From: Franck Pachot <franck_at_pachot.net>
Date: Thu, 18 Feb 2016 21:48:59 +0000
Message-ID: <CAK6ito3u1hv36rMXX2HmuuvbLOXy2r7jfY=Laop2LQHXrG4bMQ_at_mail.gmail.com>

Hi,
You understand the concept correctly, if count(*) is 44 you should see 44 rows ;)
Can you run the select * with set autotrace on and check Pstart/Pstop Regards,
Franck.

On Thu, Feb 18, 2016 at 9:20 PM Seth Miller <sethmiller.sm_at_gmail.com> wrote:

> Can you verify the version of sqlplus you are using?
>
>
> Seth Miller
>
> On Thu, Feb 18, 2016 at 12:35 PM, Charlotte Hammond <
> dmarc-noreply_at_freelists.org> wrote:
>
>> Hi All,
>>
>> I'm just doing a bit of self study on CDBs (no current plans to use this
>> for real) and can't understand why, when connected to CDB$ROOT as SYS I can
>> count the users in CDB_USERS but can't select them. I'm not sure if this
>> is a bug or, being new to all this, I'm just not understanding the concept
>> properly. I'd appreciate any enlightenment! (Please see my sqlplus spool
>> below)
>>
>> Many thanks,
>> Charlotte
>>
>> SQL> select version from v$instance;
>>
>> VERSION
>> -----------------
>> 12.1.0.1.0
>>
>> SQL> show user
>> USER is "SYS"
>> SQL> show con_id
>>
>> CON_ID
>> ------------------------------
>> 1
>>
>> SQL> select con_id,open_mode from v$pdbs;
>>
>> CON_ID OPEN_MODE
>> ---------- ----------
>> 2 READ ONLY
>> 3 READ WRITE
>> 4 READ WRITE
>> 5 READ WRITE
>> 6 READ WRITE
>>
>> SQL> select count(*) from cdb_users where con_id=4;
>>
>> COUNT(*)
>> ----------
>> 44
>>
>> SQL> select * from cdb_users where con_id=4;
>>
>> no rows selected
>>
>>
>>
>>
>>
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 18 2016 - 22:48:59 CET