468,119 Members | 1,983 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,119 developers. It's quick & easy.

event monitoring

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
1 1750
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.

Similar topics

1 post views Thread by Daniel Bass | last post: by
12 posts views Thread by Jack Russell | last post: by
18 posts views Thread by Jerry Boone | last post: by
1 post views Thread by =?Utf-8?B?YnJlbnQ5NjA=?= | last post: by
1 post views Thread by brad.serbus | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.