Example: What Are User Sessions Doing?
The following SQL shows what user sessions are currently doing in all servers in the local VNODE and the remote VNODE “GRFR6”:
update ima_mib_objects
set value = DBMSINFO('IMA_VNODE')
where classid = 'exp.gwf.gwm.session.control.add_vnode'
and instance = '0'
and server = DBMSINFO('IMA_SERVER');
update ima_mib_objects
set value = 'GRFR6'
where classid = 'exp.gwf.gwm.session.control.add_vnode'
and instance = '0'
and server = DBMSINFO('IMA_SERVER');
select
*
from
ima_server_sessions
where db_owner != '';