Perfstat.Statspack is Invalid After Upgrade (Doc ID 1337034.1)

Last updated on MAY 23, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

1- Package perfstat.statspack invalid and getting The following error:

PL/SQL:ORA-00942: table or view does not exist on lines 3073 and 4387 (package body perfstat.statspack)


In the package these line are:

1. select .... from from v$dynamic_remaster_stats (line 3073)
2. select ...from v$temp_histogram (line 4387)



2- Additionally, the sql below returns zero rows


SELECT * FROM DBA_OBJECTS
WHERE OBJECT_NAME IN ('STATS$V_$DYNAMIC_REM_STATS','V_$TEMP_HISTOGRAM')



3- Running utlrp.sql does not fix the problem

Changes

New Upgrade (In this case from 10.2 to 11.2)

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms