java 存储过程

[复制链接]
查看11 | 回复0 | 2007-1-19 18:16:00 | 显示全部楼层 |阅读模式
用 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

2SQL*Net roundtrips to/from client

0sorts (memory)

0sorts (disk)

1rows processed

Statistics
----------------------------------------------------------

5recursive calls

0db block gets

8consistent gets

0physical reads

0redo size
418bytes sent via SQL*Net to client
512bytes received via SQL*Net from client

2SQL*Net roundtrips to/from client

0sorts (memory)

0sorts (disk)

1rows processed
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行