Duplicate DBMS_SHARED_POOL object in database prior to upgrade
Hi,
We are currently on Oracle 11.2.0.3 and this Saturday we are planning to upgrade to 11.2.0.4 on new servers.
I was reviewing the checklist of what to review prior to the upgrade.
So I ran the duplicate objects check:
select OBJECT_NAME, OBJECT_TYPE from
DBA_OBJECTS where OBJECT_NAME||OBJECT_TYPE
in (select OBJECT_NAME||OBJECT_TYPE from
DBA_OBJECTS where OWNER='SYS') and
OWNER='SYSTEM' and OBJECT_NAME not in
('AQ$_SCHEDULES_PRIMARY', 'AQ$_SCHEDULES',
'DBMS_REPCAT_AUTH');
It came back with DBMS_SHARED_POOL PACKAGE
I had a closer look and could see:
SYS DBMS_SHARED_POOL 2013-06-08:21:48:00