By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,467 Members | 1,308 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,467 IT Pros & Developers. It's quick & easy.

event monitoring

P: n/a
Jo
Hi.
I have a few questions regd event monitoring. Would appreciate some
assistance with this.
1. Does the event monitor only insert data into the event monitoring
tables once the connection has been disconnected? sometimes when i
select from the tables the data does not show current connections, only
when i use the FLUSH command the data is updated. so, is my
understanding correct? thanks.
2. Can we activate and deactivate the event monitor from a stored
procedure? If not is there any other way of doing this apart from using
APIs. thanks.
Thanks a lot.

Jun 30 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi,

Regarding point #2,

To activate event monitor issue the following command,

SET EVENT MONITOR <<event monitor name>STATE 0 / 1;

0 - Specified Event Monitor should be de-activated.
1 - Specified Event Monitor should be activated.

If you want to de-activate event monitors you can but if AUTOSTART is
enabled, then every time when the database started event monitor will
start again.

With Regards

Balakrishnan Ethiraju
Jo wrote:
Hi.
I have a few questions regd event monitoring. Would appreciate some
assistance with this.
1. Does the event monitor only insert data into the event monitoring
tables once the connection has been disconnected? sometimes when i
select from the tables the data does not show current connections, only
when i use the FLUSH command the data is updated. so, is my
understanding correct? thanks.
2. Can we activate and deactivate the event monitor from a stored
procedure? If not is there any other way of doing this apart from using
APIs. thanks.
Thanks a lot.
Jul 3 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.