-- Start of File full_jvminst.sql
    spool full_jvminst.log;
    set echo on
    connect internal
    startup restrict
    show parameters _system
    select obj#, name from obj$
      where type#=28 or type#=29 or type#=30 or namespace=32;
    @?/javavm/install/initjvm.sql
    select count(*), object_type from all_objects
       where object_type like '%JAVA%' group by object_type;
    @?/oracore/admin/initxml.sql
    select count(*), object_type from all_objects
       where object_type like '%JAVA%' group by object_type;
    @?/rdbms/admin/catxsu.sql
    select count(*), object_type from all_objects
       where object_type like '%JAVA%' group by object_type;
    @?/javavm/install/init_jis.sql
    select count(*), object_type from all_objects
       where object_type like '%JAVA%' group by object_type;
    @?/javavm/install/jisja.sql
    select count(*), object_type from all_objects
       where object_type like '%JAVA%' group by object_type;
    @?/javavm/install/jisaephc.sql
    select count(*), object_type from all_objects
       where object_type like '%JAVA%' group by object_type;
    @?/rdbms/admin/initplgs.sql
    select count(*), object_type from all_objects
       where object_type like '%JAVA%' group by object_type;
    @?/jsp/install/initjsp.sql
    select count(*), object_type from all_objects
       where object_type like '%JAVA%' group by object_type;
    @?/jsp/install/jspja.sql
    select count(*), object_type from all_objects
       where object_type like '%JAVA%' group by object_type;
    @?/rdbms/admin/initplsj.sql
    select count(*), object_type from all_objects
       where object_type like '%JAVA%' group by object_type;
    @?/rdbms/admin/initjms.sql
    select count(*), object_type from all_objects
       where object_type like '%JAVA%' group by object_type;
    @?/rdbms/admin/initrepapi.sql
    select count(*), object_type from all_objects
       where object_type like '%JAVA%' group by object_type;
    @?/rdbms/admin/initsoxx.sql
    select count(*), object_type from all_objects
       where object_type like '%JAVA%' group by object_type;
    select object_name, object_type, owner from all_objects
       where status <> 'VALID';
    shutdown immediate
    set echo off
    spool off
    exit
    -- End of File full_jvminst.sql