Cha1tu
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.