用 CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "J1" AS ......建立了一个java class,用
CREATE OR REPLACE function f1
(
loginID invarchar2,
passwd
invarchar2
) return varchar2
as language java
name'J1.M1(java.lang.String,java.lang.String) return java.lang.String';
函数调用,每次数据库新连接后第一次运行很慢,再运行就快了,怎么解决啊?
两次执行的 Statistics 如下:
Statistics
----------------------------------------------------------
945recursive calls
0db block gets
1245consistent gets
0physical reads
0redo size
418bytes sent via SQL*Net to client
512bytes received via SQL*Net from client