Install STATSPACK on 12c
Hi all,
In progress to configure statspack for my prod db.
There is timeout error during installation.
SYS@server <instance_name>>@spcreate.sql
...........................................................................................
...........................................................................................
...........................................................................................
TABLESPACE_NAME CONTENTS DB DEFAULT TEMP TABLESPACE
------------------------------ --------- --------------------------
TEMP TEMPORARY *
Pressing <return> will result in the database's default Temporary
tablespace (identified by *) being used.
Enter value for temporary_tablespace: TEMP
Using tablespace TEMP as PERFSTAT temporary tablespace.
... Creating PERFSTAT user
... Installing required packages
... Creating views
... Granting privileges
grant select on GV_$INSTANCE to PERFSTAT
*
ERROR at line 1:
ORA-04021: timeout occurred while waiting to lock object
Thanks
Abez