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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment