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!

How to gather various statistics with respect to CDB and PDB in 12c?

user10972420Aug 13 2015 — edited Aug 19 2015

Hello,

Have a quick question about various statistics with respect to CDB and PDB in 12c.

system statistics

dictionary statistics

fixed objects statistics

optimizer statistics

Out of these which ones are applicable to CDB and which ones are applicable to PDB. Here are my observations. Dictionary statistics might be gathered as part of the auto optimizer statistics. Also one would think that the system statistics belong to CDB, but apparently it may have to be collected in both CDB and PDB which doesn't make sense.

Any insight would be greatly appreciated.

Thanks for your time.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 16 2015

Added on Aug 13 2015

#database-key-features, #multitenant

2 comments

3,558 views