Hide command from monitor

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
alex1
Posts: 4
Joined: Fri 14 Oct 2011 14:25

Hide command from monitor

Post by alex1 » Tue 25 Oct 2011 11:12

Setting IsActive to false for OracleMonitor instance is very ugly solution... Is there any other way to hide OracleCommand (query or stored procedure call) from dbMonitor?

alex1
Posts: 4
Joined: Fri 14 Oct 2011 14:25

Post by alex1 » Tue 25 Oct 2011 11:15

Also I want to hide from dbMonitor ASP.NET providers queries (such as session state, profiles and other..)

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 28 Oct 2011 14:12

There are 2 possible ways to hide some database activity from dbMonitor: either set OracleMonitor.IsActive to False in your code or play with Filter settings (the View > Event Filter menu) of dbMonitor.

alex1
Posts: 4
Joined: Fri 14 Oct 2011 14:25

Post by alex1 » Tue 01 Nov 2011 08:26

Setting IsActive to false is very bad because it slows down the application then monitor is not running (I have a lot of queries and need to hide every second).

It will be nice to have boolean property HideFromMonitor for OracleCommand. I'm sure its easy task. =)

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 04 Nov 2011 15:02

alex1 wrote:It will be nice to have boolean property HideFromMonitor for OracleCommand.
At the moment we do not have a technical possibility to implement functionality to control the events which are sent to dbMonitor.

Post Reply