Data SQL> select count(*), machine,module from gv$session where status='INACTIVE' group by machine,module order by count(*) desc; COUNT(*) Machine Name Module Name ---------- ------------------------- ------------------------------------------------ 51 prodapp1.ttd.com JDBC Thin Client 50 prodapp1.ttd.com e::fwk:fnd.framework.navigate.server.OANavigateP 49 prodapp1.ttd.com e::fwk:fnd.framework.favorites.server.ICXFavorit 41 prodapp1.ttd.com e::fwk:fnd.framework.service.lookups.server.Look 35 prodapp2.ttd.com e::fwk:fnd.framework.navigate.server.OANavigateP 34 prodapp2.ttd.com e::fwk:fnd.framework.favorites.server.ICXFavorit 31 prodapp2.ttd.com e::fwk:fnd.framework.service.lookups.server.Look 23 prodapp2.ttd.com JDBC Thin Client 20 prodapp2.ttd.com e:FND:cp:STANDARD2 20 prodapp1.ttd.com e:FND:cp:STANDARD 14 prodapp1.ttd.com e:SQLAP:frm:FNDSCSGN 13 prodapp1.ttd.com e:SQLAP:fwk:fnd.framework.service.lookups.server 12 CHINA\1233455 toad.exe 12 prodapp2.ttd.com e:SQLAP:frm:FNDSCSGN 10 prodapp1.ttd.com e:SQLAP:fwk:fnd.framework.favorites.server.ICXFa 10 prodapp1.ttd.com e:SQLAP:fwk:fnd.framework.navigate.server.OANavi 10 prodapp1.ttd.com e:SQLAP:frm:APXINWKB SQL> select count(*),module,program,last_call_et/3600 from gv$session where status='INACTIVE' group by module,program,last_call_et/3600 order by last_call_et/3600 desc; COUNT(*) Module Name PROGRAM LAST_CALL_ET/3600 ---------- ------------------------------------------------ ------------------------------------------------ ----------------- 1 JDBC Thin Client JDBC Thin Client 1443.63389 1 JDBC Thin Client JDBC Thin Client 1443.63333 1 FNDSM@prodapp1.ttd.com (TNS V1-V3) FNDSM@prodapp1.ttd.com (TNS V1-V3) 1196.68222 2 JDBC Thin Client JDBC Thin Client 1196.66111 1 JDBC Thin Client JDBC Thin Client 1194.49889 1 JDBC Thin Client JDBC Thin Client 1194.44222 1 JDBC Thin Client JDBC Thin Client 1194.40361 2 JDBC Thin Client JDBC Thin Client 1126.97222 1 JDBC Thin Client JDBC Thin Client 1126.96611 2 JDBC Thin Client JDBC Thin Client 1126.96556 1 JDBC Thin Client JDBC Thin Client 1017.36333 1 e:SYSADMIN:gsm:WFMailerOAF:BES Dispatch Thread JDBC Thin Client 1017.36333 1 JDBC Thin Client JDBC Thin Client 808.154722 1 JDBC Thin Client JDBC Thin Client 808.140833 1 JDBC Thin Client JDBC Thin Client 456.4 1 JDBC Thin Client JDBC Thin Client 456.399722 1 JDBC Thin Client JDBC Thin Client 450.040556 1 FNDCPOPP JDBC Thin Client 450.026111 1 JDBC Thin Client JDBC Thin Client 449.851667 1 JDBC Thin Client JDBC Thin Client 449.851389 1 e::fwk:fnd.framework.service.lookups.server.Look JDBC Thin Client 431.535 1 e::bes:oracle.apps.icx.security.session.created JDBC Thin Client 431.5275 1 e::fwk:fnd.framework.favorites.server.ICXFavorit JDBC Thin Client 431.524167 1 JDBC Thin Client JDBC Thin Client 426.042778 1 JDBC Thin Client JDBC Thin Client 383.864444 1 JDBC Thin Client JDBC Thin Client 336.374722 1 e::fwk:fnd.framework.navigate.server.OANavigateP JDBC Thin Client 283.773333 1 JDBC Thin Client JDBC Thin Client 212.301944 1 JDBC Thin Client JDBC Thin Client 212.289444 1 JDBC Thin Client JDBC Thin Client 212.265833 1 JDBC Thin Client JDBC Thin Client 212.253056 1 e::fwk:fnd.framework.service.lookups.server.Look JDBC Thin Client 211.4825 1 e::bes:oracle.apps.icx.security.session.created JDBC Thin Client 118.592778 1 OAM JDBC Thin Client 118.591389 1 e::bes:oracle.apps.icx.security.session.created JDBC Thin Client 118.591389 1 JDBC Thin Client JDBC Thin Client 95.5819444 1 JDBC Thin Client JDBC Thin Client 47.5402778 1 e::fwk:fnd.framework.favorites.server.ICXFavorit JDBC Thin Client 47.2861111 1 JDBC Thin Client JDBC Thin Client 44.4113889 1 e:INV:fwk:fnd.framework.favorites.server.ICXFavo JDBC Thin Client 43.8730556 1 e::fwk:fnd.framework.navigate.server.OANavigateP JDBC Thin Client 43.8663889 1 e::bes:oracle.apps.icx.security.session.created JDBC Thin Client 43.8591667 1 20.4208333 1 e::fwk:fnd.framework.navigate.server.OANavigateP JDBC Thin Client 2.28 1 toad.exe toad.exe 1.89861111 1 e:SQLGL:frm:FNDSCSGN frmweb@prodapp2.ttd.com (TNS V1-V3) 1.57888889 1 e:SQLAP:frm:FNDSCSGN frmweb@prodapp1.ttd.com (TNS V1-V3) 1.29611111