Database Tuning (MOSC)

MOSC Banner

Install STATSPACK on 12c

edited May 3, 2019 6:01AM in Database Tuning (MOSC) 3 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center