How to know the history of sql commands executed by a user on linux
Hi,
I would like to know if there is any location where the sql commands executed by a user are stored. Any help is appreciated.
Thanks in advance.
Oracle Database
Last Comment
Franck Pachot
8/22/2022 - Mon
Franck Pachot
Hi,
You can check v$sql for a PARSING_SCHEMA_NAME (user) and order by LAST_ACTIVE_TIME
Regards,
Franck.
Cha1tu
ASKER
Thank you Franck for your response. The SQL_FULLTEXT is giving a vague idea of what the user may have done something like " insert into sys.wri$_optstat_opr (operation, target, start_time, end_time) valu "
How do we interpret it? Can we actually get back the query as it was executed?
You can check v$sql for a PARSING_SCHEMA_NAME (user) and order by LAST_ACTIVE_TIME
Regards,
Franck.