- 论坛徽章:
- 0
|
查看了一下JVM状态,有几个无效的,不知道会不会有影响呢?
SQL> select comp_name, version, status from dba_registry;
COMP_NAME VERSION STATUS
---------------------------------------- ------------------------------ -----------
Oracle9i Catalog Views 9.2.0.4.0 VALID
Oracle9i Packages and Types 9.2.0.4.0 VALID
Oracle Workspace Manager 9.2.0.1.0 VALID
JServer JAVA Virtual Machine 9.2.0.4.0 VALID
Oracle XDK for Java 9.2.0.6.0 VALID
Oracle9i Java Packages 9.2.0.4.0 VALID
Oracle interMedia 9.2.0.4.0 VALID
Spatial 9.2.0.4.0 LOADED
Oracle Text 9.2.0.4.0 VALID
Oracle XML Database 9.2.0.4.0 VALID
Oracle Data Mining 9.2.0.1.0 LOADED
OLAP Analytic Workspace 9.2.0.4.0 LOADED
Oracle OLAP API 9.2.0.4.0 LOADED
OLAP Catalog 9.2.0.4.0 VALID
14 rows selected.
SQL>
SQL> select owner, status, count(*) from all_objects
2 where object_type like '%JAVA%' group by owner, status;
OWNER STATUS COUNT(*)
------------------------------ ------- ----------
ODM VALID 263
SYS VALID 9539
ORDSYS VALID 892
ORDSYS INVALID 12
ORDPLUGINS VALID 1
SQL> select owner, object_type, status, dbms_java.longname(object_name) from all_objects
2 where object_type like '%JAVA%' and status <> 'VALID';
OWNER OBJECT_TYPE STATUS
------------------------------ ------------------ -------
DBMS_JAVA.LONGNAME(OBJECT_NAME)
----------------------------------------------------------------------------------------------------
ORDSYS JAVA CLASS INVALID
oracle/aurora/deploy/javax_media_jai_iterator_Installer
ORDSYS JAVA CLASS INVALID
oracle/aurora/deploy/javax_media_jai_operator_Installer
ORDSYS JAVA CLASS INVALID
oracle/aurora/deploy/com_sun_media_jai_rmi_Installer
ORDSYS JAVA CLASS INVALID
oracle/aurora/deploy/com_sun_media_jai_iterator_Installer
ORDSYS JAVA CLASS INVALID
oracle/aurora/deploy/com_sun_media_jai_codecimpl_fpx_Installer
ORDSYS JAVA CLASS INVALID
oracle/aurora/deploy/com_sun_media_jai_util_Installer
ORDSYS JAVA CLASS INVALID
oracle/aurora/deploy/com_sun_media_jai_opimage_Installer
ORDSYS JAVA CLASS INVALID
oracle/aurora/deploy/javax_media_jai_widget_Installer
ORDSYS JAVA CLASS INVALID
oracle/aurora/deploy/javax_media_jai_Installer
ORDSYS JAVA CLASS INVALID
oracle/aurora/deploy/com_sun_media_jai_codec_Installer
ORDSYS JAVA CLASS INVALID
oracle/aurora/deploy/com_sun_media_jai_codecimpl_Installer
ORDSYS JAVA CLASS INVALID
oracle/aurora/deploy/com_sun_media_jai_codecimpl_util_Installer
|
|