The following steps will enable SQL*Trace for all MSCA/WMS users.
Please modify the following parameter in Mobile server configuration file mwa.cfg .
mwa.LogLevel=performance
Here are the steps
1) Stop the mobile telnet server
2) Modify the file mwa.cfg setting mwa.LogLevel=performance
3) Start the mobile server
4) Logon to mobile applications and perform the transaction
5) Confirm the presence of a new trace file.
5) Log out of application
6) Stop the mobile server
7) Reset the parameter in mwa.cfg
8) Restart the mobile server.
Please provide the trace file generated by the process.
2. Provide the tkprof as follows:
a. Retrieve the trace file.
b. Issue a command like the following to create a TKPROF version of the
trace file. This command sorts the results with the longest running
queries first:
tkprof <filename.trc> <output_filename> sys=no
explain=apps/<password>
sort='(prsela,exeela,fchela)'
c. Additionally, provide the following TKPROF that limits the results to
the top ten queries:
tkprof <filename.trc> <output_filename> sys=no
explain=apps/<password>
sort='(prsela,exeela,fchela)' print=10
SQL Trace - MWA
转载文章标签 SQL 文章分类 SQL Server 数据库
本文章为转载内容,我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题,欢迎原作者联系我们进行内容更正或删除文章。
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
Oracle 10046 SQL TRACE
为什么我们要使用10046 trace? 10046 trace帮助我们解析 一条/多条SQL、PL/SQL语句
数据库 操作系统 sql oracle 执行计划 -
怎样去 trace sql*net
trace sql*net
sql net trace