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


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