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!

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 2 2013

Added on Jul 3 2013

#general-database-discussions

12 comments

19,185 views