10gR2 : Recording all the statements fired by a specific users
Hi Guys,
I(as DBA) want to monitor/record all the statements fired by a specific users during a certain period of time.
I use v$sql but have some doubt about following :
1. exact sequence of foreground statements are difficult to get.
2. column 'executions' does not give me actual number of time that SQL statement is fired ?
3. Actual run time is also not possible to get ?
4. what about the history of sql statements ?
PS :I can not put a system level trigger trigger because of security.
I(as DBA) want to monitor/record all the statements fired by a specific users during a certain period of time.
- I have access to Toad dba session and
- access to SQLPLUS session as dba ?
I use v$sql but have some doubt about following :
1. exact sequence of foreground statements are difficult to get.
2. column 'executions' does not give me actual number of time that SQL statement is fired ?
3. Actual run time is also not possible to get ?
4. what about the history of sql statements ?
PS :I can not put a system level trigger trigger because of security.
0