| sasi |
Posted: Aug 19, 2006 04:39:07 AM |
Total Post: 59
Joined: Nov, 2005
|
Dear all,
I am having 200 users , can i able to see which user issued last sql Stmt in the Database throught the day as a DBA.
Regards
sarath |
|
|
Prakash |
| Posted: Nov 29, 2006 10:32:26 PM | |
|
Total Post: 112
Joined: Aug, 2006
|
Sarath,
You can quary v$sql view to find out who issued the last sql stmt.
Or u can enable auditing on perticular table to have a trap on it.
|
|
|
|
|
mani |
| Posted: Jan 16, 2008 03:52:22 AM | |
|
Total Post: 6
Joined: Jan, 2008
|
We can use v$SQL view for this.
select distinct FIRST_LOAD_TIME from v$sql
|
|
|
|
|
positive |
| Posted: Jun 29, 2008 03:42:47 PM | |
|
Total Post: 361
Joined: Jun, 2008
|
select sql_text from v$sqlarea - sql statement is displayed
http://neworacledba.blogspot.com/
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |