Mobile Web Applications Server - MWA Troubleshooting Tips for E-Business Suite 11i and R12

Mobile Web Applications Server - MWA Troubleshooting Tips for E-Business Suite 11i and R12 Oracle Mobile Application Server (Doc ID 269991.1)

MWA connection by Machine:

sqlplus -s "/ as sysdba" <

   set echo off

   set pagesize 220

   set markup html on spool on

   spool ${SPOOL_FILE_MWA}

   TTITLE  CENTER 'Hourly Report - MWA sessions Count By Machine'

   select count(machine),machine from  v$session where module='MWAJDBC' group by machine

/

ALTER SESSION

   SET NLS_DATE_FORMAT = 'YYYY MM DD HH24:MI:SS';

select machine,action,logon_time,last_call_et,status from v$session where module='MWAJDBC'

order  by machine

/

   spool off

   set markup html off spool off

EOF

select count(machine),machine from  v$session where module='MWAJDBC' group by machine