?
Solved

How to know the history of sql commands executed by a user on linux

Posted on 2011-03-09
5
Medium Priority
?
289 Views
Last Modified: 2012-06-21
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.
0
Comment
Question by:Cha1tu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 15

Expert Comment

by:Franck Pachot
ID: 35093881
Hi,
You can check v$sql for a PARSING_SCHEMA_NAME (user) and order by LAST_ACTIVE_TIME
Regards,
Franck.
0
 
LVL 2

Author Comment

by:Cha1tu
ID: 35094579
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?
0
 
LVL 15

Accepted Solution

by:
Franck Pachot earned 2000 total points
ID: 35094961
You see statements typed by the users as well as recursive statements (from a pl/sql procedure for exemple)
Not sure, but sys.wri$_optstat_opr may come from the call to dbms_stats.gather_system_stats
0
 
LVL 2

Author Comment

by:Cha1tu
ID: 35095346
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?
0
 
LVL 15

Expert Comment

by:Franck Pachot
ID: 35095922
No you can't :(
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question