Tuesday, June 8, 2010

Script to Check the Status of the JVM within the Database

The following script can be used to determine whether the Oracle JVM is installed completely and is valid also check  How to Check if the Oracle JVM is Installed Correctly in the Database
sqlplus  '/ as sysdba'
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 dba_objects  where object_type like '%JAVA%' group by owner, status;

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

select owner, status, object_type, object_name from dba_objects

where object_name like'%DBMS_JAVA%';

select owner, status, object_type, object_name from dba_objects

where object_name like'%INITJVMAUX%';

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 dba_objects

where object_type like '%JAVA%' and status <> 'VALID';


Related  topics:
How to Check if the Oracle JVM is Installed Correctly in the Database
Is the Oracle JVM actively used in the database

No comments: