Instalación Catalogos: JAVA 11G & XDK

A la hora de instalar el Java en 11G correctanente, junto al XDK, hay que instalar los siguientes paquetes: 

JServer JAVA Virtual Machine
Oracle9i Java Packages
XDK (Oracle XML Developers Kit 11g)

Para ello, se ejecutarán en la Base de Datos los siguientes paquetes: 

JServer JAVA Virtual Machine :-   @?/javavm/install/initjvm.sql
Java Packages:-                                  @?/rdbms/admin/catjava.sql

XDK (Siguiendo este orden)

@?/javavm/install/initjvm.sql
@?/xdk/admin/initxml.sql
@?/xdk/admin/xmlja.sql
@?/rdbms/admin/catjava.sql

COMPROBACIONES

1.- Comprobar que se ha instalado correctamente la versión XDK

CREATE OR REPLACE FUNCTION XMLVersion RETURN VARCHAR2
  IS LANGUAGE JAVA NAME
  'oracle.xml.parser.v2.XMLParser.getReleaseVersion() returns java.lang.String';
/

select xmlversion from dual;

2.- Comprobar los Objetos Java en la Base de Datos: 

select count(*), object_type from all_objects
where object_type like '%JAVA%' group by object_type;

  COUNT(*) OBJECT_TYPE
---------- ---------------
       317 JAVA DATA
       763 JAVA RESOURCE
     19974 JAVA CLASS

3.- Comprobar el Estado del JAVA en Oracle

connect / as sysdba

spool jvm_stats.log

set serveroutput on
set echo on
set pagesize500
set linesize 100
column comp_name format a40

select comp_name, version, status from dba_registry;

select owner, status, count(*) from all_objects
where object_type like '%JAVA%' group by owner, status;

select owner, object_type, count(*) from all_objects
where object_type like '%JAVA%' and status <> 'VALID' group by owner, object_type;

select owner, status, object_type, object_name from all_objects
where object_name like'%DBMS_JAVA%';

select owner, status, object_type, object_name from all_objects
where object_name like'%INITJVMAUX%';     

select role from dba_roles where role like '%JAVA%';

select * from v$sgastat where POOL = 'java pool' or NAME = 'free memory';

show parameter pool_size

show parameter sga

select owner, object_type, status, dbms_java.longname(object_name) from all_objects
where object_type like '%JAVA%' and status <> 'VALID';

spool off