:cpu := dbms_utility.get_cpu_time; dbms_application_info.set_client_info(0); end; / selectid,(selectf(id)fromdual)asclient_infofromtest; selectdbms_utility.get_cpu_time- :cpu cpu_hsecs, userenv('client_info') fromdual; 我们可以看到测试结果userenv('client_info')的值为3, 这意味着标...
如果对函数dbms_application_info.set_client_info不了解的,自行搜索、学习这个知识点! create or replace function f( x in varchar2 ) return number 1. as 1. begin 1. dbms_application_info.set_client_info(userenv('client_info')+1 ); 1. return length(x); 1. end 1. 然后创建测试表,插入测试...