so if 100 user connected to oracle ,100 jvm instance will be there ,is that right?

How will i know how many no VJVM is running?

How do we know which version of JVM running ?

create or replace and compile java source named "props" as
public class props {
  public static void show_props() {
    System.getProperties().list(System.out);
  }
}
/
show errors
create or replace procedure java_props
as language java name 'props.show_props()';
/
show errors
exec dbms_java.grant_permission( user, 'java.util.PropertyPermission','*','read,write' );
set serveroutput on size 10000
exec dbms_java.set_output(10000)
exec java_props


will do it:

ops$tkyte@ORA817DEV.US.ORACLE.COM> exec java_props
-- listing properties --
java.specification.name=Java Platform API Specification<b>
java.version=1.2.1</b>
oracle.aurora.mts.INIT=oracle.aurora.mts.rdbms.INIT
user.timezone=EST 

Hi Tom,

We have come to a point where we are seeing the Oracle JVM running java code more than 10 times slower than running the java code outside of Oracle. I have read a number of threads on Metalink where other users see similar issues. There seems to be no response from Oracle on these threads. Unfortunalty I cannot find where I can optimise this. We have altered database parameters in many ways to see if we can get changes, but to no avail.

Could you comment on your own experience with this. Is the Oracle JVM really inefficient ?

many thanks

sorry ..

the version of Oracle we are using is 9i r2. Also the java code we are testing with receives an object from a plsql stored procedure, this object is an array of about 5000 rows of data. The java returns a clob which is of XML. We have tried similar tests , whereby we just call the java passing the object and returning a string. The performance was the same.

many thanks

appologies...

something simple ...

create or replace and compile
java source named "Mysp"
as
public class Mysp extends Object {
public static double test() {
double d = 0.0;
long p = System.currentTimeMillis();
for (int i=0; i<10000000; i++) {
d= d+ (i+0.1)*2;
}
long p2 = System.currentTimeMillis();
return d;
}
}
/

create or replace function test return number as
language java name 'Mysp.test() return double';

user@db> declare
2 n long;
3 begin
4 dbms_output.put_line(to_char(sysdate, 'dd/mm/yy hh:mi:ss'));
5 select test() into n from dual;
6 dbms_output.put_line(to_char(sysdate, 'dd/mm/yy hh:mi:ss'));
7 end;
8 /
24/08/04 06:15:50
24/08/04 06:15:58

PL/SQL procedure successfully completed.

as pure java .... 78 miliseconds


import java.util.Date;

public class My
{
public static void main(String[] args)
{
Date start = new Date();
double d = 0.0;
long p = System.currentTimeMillis();
for (int i = 0; i < 10000000; i++)
{
d = d + (i + 0.1) * 2;
}
long p2 = System.currentTimeMillis();
System.out.println((p2 - p) / 1000.0);
System.out.println(d);
Date end = new Date();
System.out.println( "diff " +(end.getTime() - start.getTime()) );
}
}

==============
0.078
9.999999201065402E13
diff 78

where can i get a detailed description for procedures ?

how to pass sysdate from java funtion to the oracle table