| Counting the use of formsmodules [message #118846] |
Mon, 09 May 2005 05:18  |
pskoopman
Messages: 6
Registered: May 2005
|
Junior Member |
|
|
Hello,
I’m searching for a solution to count the use of formsmodules. Every time a user switches to another formsmodule the name of the module (and same other stuff) must be written to a log-table.
I’ve already being investigating the v$session view. The column action displays the name of the formsmodule. But you can’t use any trigger of changing the values of this column. To put a trigger on the underlaying tables is a bit tricky. Any suggestions?
Thanks anyway.
Patrick
|
|
|
|
|
|
| Re: Counting the use of formsmodules [message #118971 is a reply to message #118931] |
Tue, 10 May 2005 01:59  |
pskoopman
Messages: 6
Registered: May 2005
|
Junior Member |
|
|
The main problem is that we already have for about 1100 formsmodules (forms6i character based) and want to see which is used for most. So, I think, it would be better to stay on de database. Thanks anyway.
Patrick
|
|
|
|
| Re: Counting the use of formsmodules [message #119791 is a reply to message #118971] |
Sun, 15 May 2005 15:47 |
pskoopman
Messages: 6
Registered: May 2005
|
Junior Member |
|
|
I've got a solution, not a 100% one but still. In the v$session view, I've done een selection every 5 minutes (with a job). Every new session I'll insert in some log table, every same session with new action also.
Like this you get a good view for using the forms. If you narrow the interval (to 1 minute) you even get better information.
Patrick
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
