Oracle: V$SQLAREA

ADDRESS and SQL_ID identify records in V$SQLAREA uniquely

--
--  sql_id is unique in v$sqlarea:
--
select
  count(*),
  sql_id
from
  v$sqlarea
group by
  sql_id
order by
  count(*) desc;

select
   count(*),
   address
from
   v$sqlarea
group by
   address
order by
   count(*) desc;

Joining with DBA_USERS

select
-- sql.last_active_time,
   round((sysdate - sql.last_active_time) * 24*60*60) last_active_secs_ago,
-- sql.first_load_time,
   sql.sql_id,
   sql.sql_text,
   sql.executions,
   sql.parse_calls,
   sql.last_load_time,
   sql.*
from
   v$sqlarea   sql                                        join
   dba_users   usr on sql.parsing_user_id = usr.user_id
where
   usr.username = user
order by
   sql.last_active_time desc
;

See also