Forum Stats

  • 3,855,210 Users
  • 2,264,475 Discussions
  • 7,905,930 Comments

Discussions

PDBSS showing false size of the PDB

User_HCU9J
User_HCU9J Member Posts: 19 Blue Ribbon
edited Aug 4, 2017 2:50PM in Multitenant

Hi,

In the PDBSS console the size of the PDBs is false. Is this a BUG? Or is it possible to open a Service Request for that?

I think the total size is the sum of the system and sysaux tablespace file sizes.

Thanks in advance for your help and regards,

Gabor

Answers

  • Unknown
    edited Jul 26, 2017 12:27PM
    In the PDBSS console the size of the PDBs is false.

    You haven't posted ANYTHING that supports that statement.

    Is this a BUG? Or is it possible to open a Service Request for that?

    Submit an SR via your MOS account.

  • Markus Flechtner
    Markus Flechtner Member Posts: 503 Bronze Trophy
    edited Jul 26, 2017 4:00PM

    Hi,

    AFAIK, PDBSS is an APEX application, so you should be able to check the source code.

    And - as the software is provided "as is" - I don't think, that Oracle Support will accept an SR on PDBSS.

    Regards

    Markus

  • User_HCU9J
    User_HCU9J Member Posts: 19 Blue Ribbon
    edited Jul 27, 2017 9:44AM

    pdbss_size.png

    pdbss_size2.png

    SQL> alter session set container=PDB_311;

    Session altered.

    SQL>  select sum(bytes)/1024/1024 from dba_data_files;

    SUM(BYTES)/1024/1024

    --------------------

                    7745

  • Unknown
    edited Jul 27, 2017 12:23PM

    Thanks for the info.

    Are you connected to the root/cdb as SYS for ALL of the info you just posted?

    If not it could be a privilege issue. There can even be differences in the root/cdb SYS accounts and the pdb SYS account in terms of privileges.

    If possible do additional testing by:

    1. shutting down the instance and all PDBs

    2. restart the instance and the same PDBs

    3. connect to the root/CDB as SYS

    4. rerun the numbers

    Only Oracle knows what the app numbers represent and what queries are used to produce them.

    Since the size has a value but the max size does not it could represent:

    1. that the datafiles exist but no allocations have been made yet (unlikely since the system and aux tablespaces would use space by default). But the MAX size is the anomaly so  it could be that the query used excludes Oracle spaces.

    2. that the PDB can't be written to; almost as if it were READ ONLY or not available for actual use.

    Which raises some questions and suggests some more tests you might do:

    1. have you connected manually to that PDB?

    2. are there local users that have been created in that PDB? are they useable?

    3. can you connect manually as a local user to that PDB? what privileges exist for that local user? can you create tables and populate them?

    4. do the numbers you see change if you actually use a lot of space for table data for that local user?

    If the above tests show the same difference you will have to log an SR and ask Oracle to explain it.

  • Markus Flechtner
    Markus Flechtner Member Posts: 503 Bronze Trophy
    edited Jul 27, 2017 1:10PM

    Hi,

    please share the results of the following queries (on PDB level and on CDB$ROOT level):

    set linesize 100

    name format a60

    column file_name format a60

    select con_id,file_name,bytes/1024/1024 size_mb from cdb_data_files order by con_id;

    select con_id,file_name,bytes/1024/1024 size_mb from cdb_temp_files order by con_id;

    select con_id,name,bytes/1024/1024 size_mb from v$datafile order by con_id;

    select con_id,name,bytes/1024/1024 size_mb from v$tempfile order by con_id;

    Regards

    Markus

  • User_HCU9J
    User_HCU9J Member Posts: 19 Blue Ribbon
    edited Aug 4, 2017 10:43AM

    Hi,

    In the meantime I have 4 PDBs. I checked it in one of them:

    SQL> alter session set container=pdb_311;

    Session altered.

    SQL> col name format a150

    column file_name format a120

    SQL> SQL> select con_id,file_name,bytes/1024/1024 size_mb from cdb_data_files order by con_id;

    select con_id,file_name,bytes/1024/1024 size_mb from cdb_temp_files order by con_id;

    select con_id,name,bytes/1024/1024 size_mb from v$datafile order by con_id;

    select con_id,name,bytes/1024/1024 size_mb from v$tempfile order by con_id;

        CON_ID FILE_NAME                                                                                                                   SIZE_MB

    ---------- ------------------------------------------------------------------------------------------------------------------------ ----------

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_users_dqcrlvh4_.dbf                       20

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_sysaux_dqcrlvh3_.dbf                     885

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_pm1e_dat_dqcvzb9v_.dbf                   600

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_system_dqcrlvh2_.dbf                     440

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_pm1e_ind_dqcvzzr3_.dbf                  1200

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_rtw_data_dqcw00v0_.dbf                    50

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_rtw_inde_dqcw01yz_.dbf                    50

    7 rows selected.

    SQL>

        CON_ID FILE_NAME                                                                                                                   SIZE_MB

    ---------- ------------------------------------------------------------------------------------------------------------------------ ----------

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_temp_dqcrlvh4_.dbf                        43

    SQL>

        CON_ID NAME                                                                                                                                                      SIZE_MB

    ---------- ------------------------------------------------------------------------------------------------------------------------------------------------------ ----------

             0 /u02/oracle/oradata/CDBREP/data/undotbs01.dbf                                                                                                                3535

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_sysaux_dqcrlvh3_.dbf                                                   885

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_rtw_inde_dqcw01yz_.dbf                                                  50

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_pm1e_dat_dqcvzb9v_.dbf                                                 600

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_pm1e_ind_dqcvzzr3_.dbf                                                1200

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_rtw_data_dqcw00v0_.dbf                                                  50

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_system_dqcrlvh2_.dbf                                                   440

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_users_dqcrlvh4_.dbf                                                     20

    8 rows selected.

    SQL>

        CON_ID NAME                                                                                                                                                      SIZE_MB

    ---------- ------------------------------------------------------------------------------------------------------------------------------------------------------ ----------

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_temp_dqcrlvh4_.dbf                                                      43

    SQL>

    SQL> alter session set container=cdb$root;

    Session altered.

    SQL>

    SQL>

    SQL> col name format a150

    column file_name format a120

    select con_id,file_name,bytes/1024/1024 size_mb from cdb_data_files order by con_id;

    select con_id,file_name,bytes/1024/1024 size_mb from cdb_temp_files order by con_id;

    SQL> SQL> select con_id,name,bytes/1024/1024 size_mb from v$datafile order by con_id;

    select con_id,name,bytes/1024/1024 size_mb from v$tempfile order by con_id;

        CON_ID FILE_NAME                                                                                                                   SIZE_MB

    ---------- ------------------------------------------------------------------------------------------------------------------------ ----------

             1 /u02/oracle/oradata/CDBREP/data/system01.dbf                                                                                    820

             1 /u02/oracle/oradata/CDBREP/data/sysaux01.dbf                                                                                   1500

             1 /u02/oracle/oradata/CDBREP/data/undotbs01.dbf                                                                                  3535

             1 /u02/oracle/oradata/CDBREP/data/users01.dbf                                                                                       5

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_users_dqcrlvh4_.dbf                       20

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_rtw_inde_dqcw01yz_.dbf                    50

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_rtw_data_dqcw00v0_.dbf                    50

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_sysaux_dqcrlvh3_.dbf                     885

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_system_dqcrlvh2_.dbf                     440

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_pm1e_dat_dqcvzb9v_.dbf                   600

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_pm1e_ind_dqcvzzr3_.dbf                  1200

             4 /u02/oracle/oradata/CDBREP/data/CDBREP/5512F0D7ABD21883E053380614AC1E4E/datafile/o1_mf_system_dqd4vs6v_.dbf                     460

             4 /u02/oracle/oradata/CDBREP/data/CDBREP/5512F0D7ABD21883E053380614AC1E4E/datafile/o1_mf_rtw_inde_dqd4vs7c_.dbf                    50

             4 /u02/oracle/oradata/CDBREP/data/CDBREP/5512F0D7ABD21883E053380614AC1E4E/datafile/o1_mf_rtw_data_dqd4vs7b_.dbf                    50

             4 /u02/oracle/oradata/CDBREP/data/CDBREP/5512F0D7ABD21883E053380614AC1E4E/datafile/o1_mf_sysaux_dqd4vs75_.dbf                     915

             4 /u02/oracle/oradata/CDBREP/data/CDBREP/5512F0D7ABD21883E053380614AC1E4E/datafile/o1_mf_pm1e_dat_dqd4vs77_.dbf                   600

             4 /u02/oracle/oradata/CDBREP/data/CDBREP/5512F0D7ABD21883E053380614AC1E4E/datafile/o1_mf_users_dqd4vs76_.dbf                       20

             4 /u02/oracle/oradata/CDBREP/data/CDBREP/5512F0D7ABD21883E053380614AC1E4E/datafile/o1_mf_pm1e_ind_dqd4vs79_.dbf                  1700

             5 /u02/oracle/oradata/CDBREP/data/CDBREP/554E113ACD8776BCE053380614ACFFDA/datafile/o1_mf_system_dqmxg8o0_.dbf                     460

             5 /u02/oracle/oradata/CDBREP/data/CDBREP/554E113ACD8776BCE053380614ACFFDA/datafile/o1_mf_rtw_inde_dqmxg8om_.dbf                    50

             5 /u02/oracle/oradata/CDBREP/data/CDBREP/554E113ACD8776BCE053380614ACFFDA/datafile/o1_mf_rtw_data_dqmxg8ol_.dbf                    50

             5 /u02/oracle/oradata/CDBREP/data/CDBREP/554E113ACD8776BCE053380614ACFFDA/datafile/o1_mf_sysaux_dqmxg8oj_.dbf                     945

             5 /u02/oracle/oradata/CDBREP/data/CDBREP/554E113ACD8776BCE053380614ACFFDA/datafile/o1_mf_pm1e_dat_dqmxg8ok_.dbf                   600

             5 /u02/oracle/oradata/CDBREP/data/CDBREP/554E113ACD8776BCE053380614ACFFDA/datafile/o1_mf_users_dqmxg8ok_.dbf                       20

             5 /u02/oracle/oradata/CDBREP/data/CDBREP/554E113ACD8776BCE053380614ACFFDA/datafile/o1_mf_pm1e_ind_dqmxg8ol_.dbf                  1700

             6 /u02/oracle/oradata/CDBREP/data/CDBREP/554F1505B34B7C23E053380614ACE8BD/datafile/o1_mf_system_dqn169hw_.dbf                     460

             6 /u02/oracle/oradata/CDBREP/data/CDBREP/554F1505B34B7C23E053380614ACE8BD/datafile/o1_mf_sysaux_dqn169j4_.dbf                     975

             6 /u02/oracle/oradata/CDBREP/data/CDBREP/554F1505B34B7C23E053380614ACE8BD/datafile/o1_mf_users_dqn169j5_.dbf                       20

             6 /u02/oracle/oradata/CDBREP/data/CDBREP/554F1505B34B7C23E053380614ACE8BD/datafile/o1_mf_rtw_inde_dqn169j8_.dbf                    50

             6 /u02/oracle/oradata/CDBREP/data/CDBREP/554F1505B34B7C23E053380614ACE8BD/datafile/o1_mf_pm1e_ind_dqn169j6_.dbf                  1700

             6 /u02/oracle/oradata/CDBREP/data/CDBREP/554F1505B34B7C23E053380614ACE8BD/datafile/o1_mf_rtw_data_dqn169j7_.dbf                    50

             6 /u02/oracle/oradata/CDBREP/data/CDBREP/554F1505B34B7C23E053380614ACE8BD/datafile/o1_mf_pm1e_dat_dqn169j6_.dbf                   600

    32 rows selected.

    SQL>

        CON_ID FILE_NAME                                                                                                                   SIZE_MB

    ---------- ------------------------------------------------------------------------------------------------------------------------ ----------

             1 /u02/oracle/oradata/CDBREP/data/temp01.dbf                                                                                       71

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_temp_dqcrlvh4_.dbf                        43

             4 /u02/oracle/oradata/CDBREP/data/CDBREP/5512F0D7ABD21883E053380614AC1E4E/datafile/o1_mf_temp_dqd4vs76_.dbf                        26

             5 /u02/oracle/oradata/CDBREP/data/CDBREP/554E113ACD8776BCE053380614ACFFDA/datafile/o1_mf_temp_dqmxg8ok_.dbf                        25

             6 /u02/oracle/oradata/CDBREP/data/CDBREP/554F1505B34B7C23E053380614ACE8BD/datafile/o1_mf_temp_dqn169j5_.dbf                        26

    SQL>

        CON_ID NAME                                                                                                                                                      SIZE_MB

    ---------- ------------------------------------------------------------------------------------------------------------------------------------------------------ ----------

             1 /u02/oracle/oradata/CDBREP/data/users01.dbf                                                                                                                     5

             1 /u02/oracle/oradata/CDBREP/data/undotbs01.dbf                                                                                                                3535

             1 /u02/oracle/oradata/CDBREP/data/system01.dbf                                                                                                                  820

             1 /u02/oracle/oradata/CDBREP/data/sysaux01.dbf                                                                                                                 1500

             2 /u02/oracle/oradata/CDBREP/data/pdbseed/sysaux01.dbf                                                                                                          775

             2 /u02/oracle/oradata/CDBREP/data/pdbseed/system01.dbf                                                                                                          270

             2 /u02/oracle/oradata/CDBREP/data/CDBREP/540D840E590A7964E053380614AC7BF0/datafile/o1_mf_users_dq19qtc3_.dbf                                                     20

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_system_dqcrlvh2_.dbf                                                   440

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_sysaux_dqcrlvh3_.dbf                                                   885

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_users_dqcrlvh4_.dbf                                                     20

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_pm1e_dat_dqcvzb9v_.dbf                                                 600

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_pm1e_ind_dqcvzzr3_.dbf                                                1200

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_rtw_data_dqcw00v0_.dbf                                                  50

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_rtw_inde_dqcw01yz_.dbf                                                  50

             4 /u02/oracle/oradata/CDBREP/data/CDBREP/5512F0D7ABD21883E053380614AC1E4E/datafile/o1_mf_users_dqd4vs76_.dbf                                                     20

             4 /u02/oracle/oradata/CDBREP/data/CDBREP/5512F0D7ABD21883E053380614AC1E4E/datafile/o1_mf_sysaux_dqd4vs75_.dbf                                                   915

             4 /u02/oracle/oradata/CDBREP/data/CDBREP/5512F0D7ABD21883E053380614AC1E4E/datafile/o1_mf_system_dqd4vs6v_.dbf                                                   460

             4 /u02/oracle/oradata/CDBREP/data/CDBREP/5512F0D7ABD21883E053380614AC1E4E/datafile/o1_mf_pm1e_dat_dqd4vs77_.dbf                                                 600

             4 /u02/oracle/oradata/CDBREP/data/CDBREP/5512F0D7ABD21883E053380614AC1E4E/datafile/o1_mf_rtw_inde_dqd4vs7c_.dbf                                                  50

             4 /u02/oracle/oradata/CDBREP/data/CDBREP/5512F0D7ABD21883E053380614AC1E4E/datafile/o1_mf_rtw_data_dqd4vs7b_.dbf                                                  50

             4 /u02/oracle/oradata/CDBREP/data/CDBREP/5512F0D7ABD21883E053380614AC1E4E/datafile/o1_mf_pm1e_ind_dqd4vs79_.dbf                                                1700

             5 /u02/oracle/oradata/CDBREP/data/CDBREP/554E113ACD8776BCE053380614ACFFDA/datafile/o1_mf_system_dqmxg8o0_.dbf                                                   460

             5 /u02/oracle/oradata/CDBREP/data/CDBREP/554E113ACD8776BCE053380614ACFFDA/datafile/o1_mf_sysaux_dqmxg8oj_.dbf                                                   945

             5 /u02/oracle/oradata/CDBREP/data/CDBREP/554E113ACD8776BCE053380614ACFFDA/datafile/o1_mf_users_dqmxg8ok_.dbf                                                     20

             5 /u02/oracle/oradata/CDBREP/data/CDBREP/554E113ACD8776BCE053380614ACFFDA/datafile/o1_mf_pm1e_dat_dqmxg8ok_.dbf                                                 600

             5 /u02/oracle/oradata/CDBREP/data/CDBREP/554E113ACD8776BCE053380614ACFFDA/datafile/o1_mf_pm1e_ind_dqmxg8ol_.dbf                                                1700

             5 /u02/oracle/oradata/CDBREP/data/CDBREP/554E113ACD8776BCE053380614ACFFDA/datafile/o1_mf_rtw_data_dqmxg8ol_.dbf                                                  50

             5 /u02/oracle/oradata/CDBREP/data/CDBREP/554E113ACD8776BCE053380614ACFFDA/datafile/o1_mf_rtw_inde_dqmxg8om_.dbf                                                  50

             6 /u02/oracle/oradata/CDBREP/data/CDBREP/554F1505B34B7C23E053380614ACE8BD/datafile/o1_mf_system_dqn169hw_.dbf                                                   460

             6 /u02/oracle/oradata/CDBREP/data/CDBREP/554F1505B34B7C23E053380614ACE8BD/datafile/o1_mf_sysaux_dqn169j4_.dbf                                                   975

             6 /u02/oracle/oradata/CDBREP/data/CDBREP/554F1505B34B7C23E053380614ACE8BD/datafile/o1_mf_users_dqn169j5_.dbf                                                     20

             6 /u02/oracle/oradata/CDBREP/data/CDBREP/554F1505B34B7C23E053380614ACE8BD/datafile/o1_mf_rtw_data_dqn169j7_.dbf                                                  50

             6 /u02/oracle/oradata/CDBREP/data/CDBREP/554F1505B34B7C23E053380614ACE8BD/datafile/o1_mf_pm1e_ind_dqn169j6_.dbf                                                1700

             6 /u02/oracle/oradata/CDBREP/data/CDBREP/554F1505B34B7C23E053380614ACE8BD/datafile/o1_mf_pm1e_dat_dqn169j6_.dbf                                                 600

             6 /u02/oracle/oradata/CDBREP/data/CDBREP/554F1505B34B7C23E053380614ACE8BD/datafile/o1_mf_rtw_inde_dqn169j8_.dbf                                                  50

    35 rows selected.

    SQL>

        CON_ID NAME                                                                                                                                                      SIZE_MB

    ---------- ------------------------------------------------------------------------------------------------------------------------------------------------------ ----------

             1 /u02/oracle/oradata/CDBREP/data/temp01.dbf                                                                                                                     71

             2 /u02/oracle/oradata/CDBREP/data/pdbseed/temp01.dbf                                                                                                             62

             3 /u02/oracle/oradata/CDBREP/data/CDBREP/550FE3B518860CADE053380614AC1BCD/datafile/o1_mf_temp_dqcrlvh4_.dbf                                                      43

             4 /u02/oracle/oradata/CDBREP/data/CDBREP/5512F0D7ABD21883E053380614AC1E4E/datafile/o1_mf_temp_dqd4vs76_.dbf                                                      26

             5 /u02/oracle/oradata/CDBREP/data/CDBREP/554E113ACD8776BCE053380614ACFFDA/datafile/o1_mf_temp_dqmxg8ok_.dbf                                                      25

             6 /u02/oracle/oradata/CDBREP/data/CDBREP/554F1505B34B7C23E053380614ACE8BD/datafile/o1_mf_temp_dqn169j5_.dbf                                                      26

    6 rows selected.

    SQL>

    SQL> select * from v$pdbs;

        CON_ID       DBID    CON_UID GUID

    ---------- ---------- ---------- --------------------------------

    NAME                                                                                                                                                   OPEN_MODE  RES

    ------------------------------------------------------------------------------------------------------------------------------------------------------ ---------- ---

    OPEN_TIME                                                                   CREATE_SCN TOTAL_SIZE BLOCK_SIZE RECOVERY SNAPSHOT_PARENT_CON_ID

    --------------------------------------------------------------------------- ---------- ---------- ---------- -------- ----------------------

             2 2780640798 2780640798 540D840E590A7964E053380614AC7BF0

    PDB$SEED                                                                                                                                               READ ONLY  NO

    24-JUL-17 02.49.04.659 PM +02:00                                                   227 1116733440       8192 ENABLED                       0

             3 2284278053 2284278053 550FE3B518860CADE053380614AC1BCD

    PDB_311                                                                                                                                                READ WRITE NO

    28-JUL-17 10.21.22.665 AM +02:00                                            1.2433E+13 3447717888       8192 ENABLED                       0

             4  537574296  537574296 5512F0D7ABD21883E053380614AC1E4E

    PDB_310                                                                                                                                                READ WRITE NO

    28-JUL-17 10.21.22.665 AM +02:00                                            1.2433E+13 4006608896       8192 ENABLED                       0

             5  206930836  206930836 554E113ACD8776BCE053380614ACFFDA

    PDB_39                                                                                                                                                 READ WRITE NO

    28-JUL-17 10.21.22.665 AM +02:00                                            1.2433E+13 4037017600       8192 ENABLED                       0

             6 3892495505 3892495505 554F1505B34B7C23E053380614ACE8BD

    PDB_38                                                                                                                                                 READ WRITE NO

    28-JUL-17 10.21.22.665 AM +02:00                                            1.2433E+13 4069523456       8192 ENABLED                       0

    SQL>

    thanks and regards,

    Gabor

  • User_HCU9J
    User_HCU9J Member Posts: 19 Blue Ribbon
    edited Aug 4, 2017 10:53AM

    Thanks for the info.

    Are you connected to the root/cdb as SYS for ALL of the info you just posted?

    --> was connected as sys / as sysdba, the setting the session/container

    If not it could be a privilege issue. There can even be differences in the root/cdb SYS accounts and the pdb SYS account in terms of privileges.

    If possible do additional testing by:

    1. shutting down the instance and all PDBs

    2. restart the instance and the same PDBs

    3. connect to the root/CDB as SYS

    4. rerun the numbers

    Only Oracle knows what the app numbers represent and what queries are used to produce them.

    Since the size has a value but the max size does not it could represent:

    1. that the datafiles exist but no allocations have been made yet (unlikely since the system and aux tablespaces would use space by default). But the MAX size is the anomaly so  it could be that the query used excludes Oracle spaces.

    2. that the PDB can't be written to; almost as if it were READ ONLY or not available for actual use.

    --> I could already import into the PDBs from another database via database link, so they are writable

    Which raises some questions and suggests some more tests you might do:

    1. have you connected manually to that PDB?

    --> yes, via sqlplus

    2. are there local users that have been created in that PDB? are they useable?

    --> yes

    3. can you connect manually as a local user to that PDB? what privileges exist for that local user? can you create tables and populate them?

    --> yes, I could connect, it is a core application user

    4. do the numbers you see change if you actually use a lot of space for table data for that local user?

    --> don't understand

    If the above tests show the same difference you will have to log an SR and ask Oracle to explain it.

    --> don't think Oracle supports this Beta version...

  • Markus Flechtner
    Markus Flechtner Member Posts: 503 Bronze Trophy
    edited Aug 4, 2017 2:50PM

    Hi,

    you can enable SQL tracing and try to find out, which queries are executed to produce the numbers in PDBSS.

    Regards

    Markus

This discussion has been closed.