I query view "v$sql" and see that column "module" has values 'PL/SQL Developer' and 'plsqldev.exe'.
Why so? Why the values are different on different rows?
Example of data:
select last_active_time, service, module from v$sql
where last_active_time > sysdate - (1/24/60)*15
and module in ('PL/SQL Developer','plsqldev.exe')
order by last_active_time desc
/*
1 1.11.2010 15:14:44 casino.world PL/SQL Developer
2 1.11.2010 15:14:44 casino.world PL/SQL Developer
3 1.11.2010 15:14:44 casino.world PL/SQL Developer
4 1.11.2010 15:14:44 casino.world PL/SQL Developer
5 1.11.2010 15:14:44 casino.world PL/SQL Developer
6 1.11.2010 15:14:20 casino.world PL/SQL Developer
7 1.11.2010 15:14:20 casino.world PL/SQL Developer
8 1.11.2010 15:14:20 casino.world PL/SQL Developer
9 1.11.2010 15:09:11 casino.world PL/SQL Developer
10 1.11.2010 15:08:23 casino.world PL/SQL Developer
11 1.11.2010 15:08:08 casino.world PL/SQL Developer
12 1.11.2010 15:07:56 casino.world plsqldev.exe
13 1.11.2010 15:07:56 casino.world plsqldev.exe
14 1.11.2010 15:07:56 casino.world PL/SQL Developer
15 1.11.2010 15:07:56 casino.world plsqldev.exe
*/
Edited by: CharlesRoos on 1.11.2010 15:15
Edited by: CharlesRoos on 1.11.2010 15:15