查询大量可共享的语句
select sql_text from v$sqlarea where executions = 1 order by upper(sql_text);
oracle 最近执行过的sql语句:
SELECT sql_text, last_load_time
FROM v$sql
WHERE last_load_time IS NOT NULL
ORDER BY last_load_time DESC
查看当前登录用户
select ora_login_user from dual;
查看oracle数据库最近执行了哪些sql语句
SELECT b.sql_text, --content of SQL
a.machine, --which machine run this code
a.username,
a.module,
-- the method to run this SQL
c.sofar / totalwork * 100,
--conplete percent
c.elapsed_seconds, --run time
c.time_remaining --remain to run time
FROM v$session a, v$sqlarea b, v$session_longops c
WHERE a.sql_hash_value = b.hash_value(+)
AND a.SID = c.SID(+)
AND a.serial# = c.serial#(+)
--AND a.sid=139
应用级绑定化处理
loop
cursor cur
number eno :=;
parse(cur,"select * from emp where empno=:x");
bind(cur,":x",eno);
execute(cur);
fetch(cur);
close(cur);
end loop;
select sql_text from v$sqlarea where executions = 1 order by upper(sql_text);
oracle 最近执行过的sql语句:
SELECT sql_text, last_load_time
FROM v$sql
WHERE last_load_time IS NOT NULL
ORDER BY last_load_time DESC
查看当前登录用户
select ora_login_user from dual;
查看oracle数据库最近执行了哪些sql语句
SELECT b.sql_text, --content of SQL
a.machine, --which machine run this code
a.username,
a.module,
-- the method to run this SQL
c.sofar / totalwork * 100,
--conplete percent
c.elapsed_seconds, --run time
c.time_remaining --remain to run time
FROM v$session a, v$sqlarea b, v$session_longops c
WHERE a.sql_hash_value = b.hash_value(+)
AND a.SID = c.SID(+)
AND a.serial# = c.serial#(+)
--AND a.sid=139
应用级绑定化处理
loop
cursor cur
number eno :=
parse(cur,"select * from emp where empno=:x");
bind(cur,":x",eno);
execute(cur);
fetch(cur);
close(cur);
end loop;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12961536/viewspace-769511/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
