AIX 5.1 , PatchSet 9.2.0.5

From: Adam <koshyk_at_wp.pl>
Date: Thu, 29 Jul 2004 09:16:38 +0200
Message-ID: <cea83g$kin$1@nemesis.news.tpi.pl>

Hi,

After install PatchSet 9.2.0.5 (AIX 5.1) I executed catpatch.sql (witch JAVA_POOL_SIZE =300 MB wystapi³ SHARED_POOL_SIZE = 300MB). Now I have following count of JAVA objects in my database:

SQL> select owner, status, count(*) from sys.dba_objects where OBJECT_type like '%JAVA%' group by o
wner, status;

OWNER                          STATUS    COUNT(*)


------------------------------ ------- ----------

ODM                            VALID          253
ODM                            INVALID         11
SYS                            VALID         9010
WKSYS                          VALID           40
ORDSYS                         VALID          906

5 rows selected

the same query on another installation (another machine) :

OWNER                          STATUS    COUNT(*)


------------------------------ ------- ----------

ODM                            VALID          264
SYS                            VALID         9549
WKSYS                          VALID           40
ORDSYS                         VALID          906
ORDPLUGINS                     VALID            1

How many JAVA's objects must be in schema SYS in the database and how can I check that installation of PAtchSet is correct?

Regards
Adam Received on Thu Jul 29 2004 - 02:16:38 CDT