ORACLE-查询SQL执行次数

-- 查看 SQL 执行次数 <SQL_ID>
SELECT sql_id, executions, elapsed_time, first_load_time FROM V$SQL WHERE SQL_ID = '<SQL_ID>';

V$SQL： 只记录最近的 sql 记录 ? 

-- 查找 SQL 
SELECT * FROM DBA_HIST_SQLTEXT WHERE SQL_ID = '<SQL_ID>';
SELECT * FROM DBA_HIST_SQLTEXT WHERE SQL_TEXT LIKE '%<table_name>%';