
206 7.3 Tools for Tuning Queries
The following query simply joins sessions and SQL code statements to
find the SQL code that is currently executing the most often:
SELECT * FROM (SELECT s.username, a.sql_text, a.executions
FROM v$session s, v$sqlarea a
WHERE s.sql_address = a.address
AND s.sql_hash_value = a.hash_value
ORDER BY 3 DESC) WHERE ROWNUM <= 10;
USERNAME SQL_TEXT
---------- -----------------------------------------------------------
SELECT to_number(to_char(SYSTIMESTAMP,'FF3'))+1 from dual
SELECT to_number(to_char(SYSTIMESTAMP,'FF3'))+1 from dual
ACCOUNTS INSERT into transactions
values(transactions_seq.nextval,'S'
ACCOUNTS INSERT into transactions ...