Re: suggestion

Tue, 23 Sep 2003 15:14:21 -0700

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.
 
----- Original Message -----
Sent: Wednesday, September 24, 2003 1:39 AM
Subject: suggestion

hi
 
there is a requirement for capturing sqls and cpu consumed by any session logging into the database . this info should be stored in the database.
 
can you please give me suggestions as to how i do this?
 
thanks
sai
 

Reply via email to