select top 10 t.TOP_SQL_TEXT, t.TIME_USED, t.START_TIME from v$sql_history t order by time_used desc; 慢sql确实查询到了，但是sql显示不全，各位大佬，有办法显示全这个吗，谢谢各位
加一个函数sf_get_session_sql(), select top 10 t.sf_get_session_sql(TOP_SQL_TEXT), t.TIME_USED, t.START_TIME from v$sql_history t order by time_used desc;
可以通过获取V$SQL_HISTORY中SQL_ID字段内容，然后select * from v$sqltext where sql_id=SQL_ID字段过滤获取全的SQL
加一个函数sf_get_session_sql(),
select top 10 t.sf_get_session_sql(TOP_SQL_TEXT), t.TIME_USED, t.START_TIME
from v$sql_history t
order by time_used desc;