APPS.FND_OAM_COLLECTION dependencies on GV$SESSION

Line 1389: gv$session S

1385: -- get the number of active users
1386: select count(distinct(F.login_id))
1387: into ct_active_users
1388: from fnd_login_resp_forms F,
1389: gv$session S
1390: where F.AUDSID = S.AUDSID;
1391:
1392: -- update the number of active forms users
1393: update_metric_internal('ACTIVE_USERS', to_char(ct_active_users), -1);

Line 1398: select count(*) into ct_db_sessions from gv$session where audsid > 0;

1394: end if;
1395:
1396: if (is_collection_enabled('DB_SESSIONS')) then
1397: -- get the number of db sessions
1398: select count(*) into ct_db_sessions from gv$session where audsid > 0;
1399:
1400: -- update the number of db sessions
1401: update_metric_internal('DB_SESSIONS', to_char(ct_db_sessions), -1);
1402: end if;