Oracle database embedded JVM

Question

How can we identify which JRE version is supported by Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 64 bit (embedded JVM)

Any suggestion will be appreciated

Answer 1

I found the answer for determining which jvm version is used on Oracle database

Here is the solution:

If You need to find out which java/jdk version in installed along Your Oracle server You can create function and than retrieve java version direcly from JDK. First create function...

CREATE OR REPLACE FUNCTION get_java_property (prop IN VARCHAR2) 
RETURN VARCHAR2 IS LANGUAGE JAVA
name 'java.lang.System.getProperty(java.lang.String) return java.lang.String';

.. and then get the version

SELECT get_java_property('java.version') FROM dual;

If You cannot create such function, general rule is that in default installation: Oracle 9 uses JDK 1.3, Oracle 10 uses JDK 1.4.