SELECT a.username, a.sid,b.sql_text
FROM v$session a, v$sqlarea b
WHERE a.username IS NOT NULL AND a.sql_address = b.address
select count(*) from v$session;
返回166条
select count(*) from v$sqlarea;
返回386,323条
是v$sqlarea记录太多导致的查询慢? 怎么清理v$sqlarea中的记录?
...全文
3073打赏收藏
查询当前执行的SQL好慢呀, 怎么弄快些?
这段SQL需要1分钟才能执行完毕 SELECT a.username, a.sid,b.sql_text FROM v$session a, v$sqlarea b WHERE a.username IS NOT NULL AND a.sql_address = b.address select count(*) from v$session; 返回166条 select count(*) from v$sqlarea; 返回386,323条 是v$sqlarea记录太多导致的查询慢? 怎么清理