asked on
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.
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
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?
How do we interpret it? Can we actually get back the query as it was executed?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you Franck,
I now understood what you said. But is there any way we can filter only the full commands and not the recursive statements?
I now understood what you said. But is there any way we can filter only the full commands and not the recursive statements?
No you can't :(
You can check v$sql for a PARSING_SCHEMA_NAME (user) and order by LAST_ACTIVE_TIME
Regards,
Franck.