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.

[bala_e]

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.