How to get last executed SQL (oracle)

How to get last executed SQL (oracle)

You can use the below query to get the last sql executed based on last sql which was active in database

select ltrim(sq.sql_text)

  from v$sql sq, v$session se, v$open_cursor oc

 where sq.sql_id = oc.sql_id

   and se.saddr = oc.saddr

   and se.sid = oc.sid

   and se.audsid = SYS_CONTEXT('userenv', 'sessionid')

 order by oc.LAST_SQL_ACTIVE_TIME desc;