Q:

Find most frequently used query

I am trying to find the most used query in an oracle database.. Im a little confused!  Are these types of statistics stored in the AWR table?  If so how would I use this table to find the most popular query executed on the database?  Thanks! 

A:

try this:
SELECT ADDRESS, SQL_TEXT, PARSE_CALLS, EXECUTIONS
FROM V$SQLAREA
ORDER BY EXECUTIONS desc;

