Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
event monitoring
0 views
Skip to first unread message
Jo
Jun 29, 2006, 11:23:00 PM6/29/06
to
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.
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.
bala_e
Jul 3, 2006, 2:20:53 AM7/3/06
to
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
0 new messages