For statistics, logon & logoff triggers
+ v$mystat + autonomous transactions.
If you want to capture all sql, it will be hard
& very resource hungry, you either enable trace for given session (which
slows stuff down enormously) or poll v$sql or v$open_cursor frequently. This
isn't a good idea either. You might want to look at fine grained auditing if you
want to track which data is viewed by anybody.
Tanel.
|
- suggestion Sai Selvaganesan
- Re: suggestion Tanel Poder
- Re: suggestion Binley Lim
- RE: suggestion Jamadagni, Rajendra
- RE: suggestion Norris, Gregory T [ITS]
- RE: suggestion Jamadagni, Rajendra