求助：如何监控指定session执行的sql语句？

jzhou

history is made of single time points. I think you need to query v$ constantly, store data somewhere else and build user activity history. Based on the data collected you will find out who is log in and doing what, how long he log in, etc. With help of programming, like Perl, you can immediate detect someone is doing something illegal by sending you an email.
You can create cron job (or at job  if you are on windows platform). The query I gave only serve as a way to collect data. you may need to add group by, distinct(sid)  into query. I think you are working on a  small, but userful project.

John

flex

最初由 jzhou 发布
[B]history is made of single time points. I think you need to query v$ constantly, store data somewhere else and build user activity history. Based on the data collected you will find out who is log in and doing what, how long he log in, etc. With help of programming, like Perl, you can immediate detect someone is doing something illegal by sending you an email.
You can create cron job (or at job  if you are on windows platform). The query I gave only serve as a way to collect data. you may need to add group by, distinct(sid)  into query. I think you are working on a  small, but userful project.

John [/B]

thank you,but my project is a HIS(hospital information system),and that is a big project,there are always 300 users working on it at the same time,so i couldn't query v$ frequently because it will reduce the db performance obviously.i will upgrade the db to 8i,that is the only way i can choose to use logon trigger.

gxjian

很好！！！