Skip to Main Content
Forums

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

install statspack into oracle 12 database - CDB or PDB

willirobJul 3 2013 — edited Jul 5 2013

Hi All

I am trying to install statspack into a new ORACLE 12c DB.

The install fails creating perfstat user in the ROOT container.

My question I guess is whether statspack can be installed as a common user - the rdbms/admin scripts don't do this since common users need to be prefixed with c##

eg. c##perfstat

spdoc.txt contains this entry:

9.1.  Changes between 11.1  and 12.1

  o  Idle Events

     - Added Idle Events that span LogMiner, PQ, SQL*Net, Capture Reply

  o  Consolidated DB/Pluggable DB

     - Consolidated DB and Statspack Reporting at the CDB Root Level
This post has been answered by Jonathan Lewis on Jul 5 2013
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 2 2013
Added on Jul 3 2013
#general-database-discussions
12 comments
18,776 views