select substr(sql_text,1,60), count(*)
from v$sqlstats
where excutions<4
group by substr(sql_text, 1, 60)
having count(*)>1;
from v$sqlstats
where excutions<4
group by substr(sql_text, 1, 60)
having count(*)>1;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12742547/viewspace-257059/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12742547/viewspace-257059/