Install Statspack PDB Windows

Note: Statspack installation and reporting is not supported at the root level (CDB$ROOT)

sqlplus /@<TNS for PDB> as sysdba

show con_name
show user
show pdbs

select tablespace_name from dba_tablespaces;

— password : perfstat
— tablespace : users
— temp : temp

@%ORACLE_HOME%\rdbms\admin\spcreate

Gathering data – taking a snapshot
The default level of data collection is level 5.

connect perfstat/perfstat@<TNS for PDB> 

execute statspack.snap;

— run report : use C:\Windows\Temp
a) Instance Report spreport.sql

@%ORACLE_HOME%\rdbms\admin\spreport.sql