Home » SQL & PL/SQL » Client Tools » product spy (oracle 10g)
product spy [message #517576] Tue, 26 July 2011 12:34 Go to next message
prashant_ora
Messages: 194
Registered: July 2010
Senior Member
Hi,
This is a different type of question and even i do not know where to put it, so i m putting here ...
I have a web based product developed in java, now my requirement is to put a spy kind of thing, so that i can find out which module of the product is using very much, without putting performance overhead. I want to records information somewhere after visting each module by end users without thier information. Please suggest.
Re: product spy [message #517580 is a reply to message #517576] Tue, 26 July 2011 12:40 Go to previous messageGo to next message
BlackSwan
Messages: 22517
Registered: January 2009
Senior Member
run statspack or AWR report during heavy load for about 15 minutes

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: product spy [message #517587 is a reply to message #517580] Tue, 26 July 2011 12:48 Go to previous messageGo to next message
prashant_ora
Messages: 194
Registered: July 2010
Senior Member
In the application say there are 20 diferent features, so we have to capture which feature is used most, and that information we have to show to management at any point of time. This would be a on going process ,so please suggest what would be the best way.
Re: product spy [message #517589 is a reply to message #517576] Tue, 26 July 2011 12:50 Go to previous messageGo to next message
Michel Cadot
Messages: 58605
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Suggestion: why doesn't your application do it?
Modify the code to include it, this is the proper way to do.

Regards
Michel
Re: product spy [message #517591 is a reply to message #517587] Tue, 26 July 2011 12:52 Go to previous message
BlackSwan
Messages: 22517
Registered: January 2009
Senior Member
prashant_ora wrote on Tue, 26 July 2011 10:48
In the application say there are 20 diferent features, so we have to capture which feature is used most, and that information we have to show to management at any point of time. This would be a on going process ,so please suggest what would be the best way.


Oracle RDBMS knows nothing about your application or its features.
You will need to "instrument" the code to increment counter table values each time it is invoked & incur resultant overhead for collecting this level of detail.

You can't get somethimg for nothing.
Previous Topic: Define - help (merged)
Next Topic: last data changed
Goto Forum:
  


Current Time: Mon Jul 28 21:01:03 CDT 2014

Total time taken to generate the page: 0.10529 seconds