PeopleSoft Configuration Settings for Tracing
来源:互联网 发布:网络安全工程师 英文 编辑:程序博客网 时间:2024/04/25 03:10
mybasicknowledge.comOriginal Page
PeopleSoft Configuration Settings for Tracing
•Set the following in psappsrv.cfg, or for a single user session in PIA using trace=y
“31” is the recommended value when tracing with “TraceSQL”.
“1984” is the recommended value when tracing with “TracePC”.
“1984” is the recommended value when tracing with “TracePC”.
Utility for analyzing *.tracesql trace files
TraceMagic is a utility that gives PeopleSoft system administrators, programmers and support engineers the ability to quickly isolate performance bottlenecks in SQL Statements and/or PeopleCode functions. It accomplishes this by turning the text-based, time-ordered tracesql file into a sortable-grid display, allowing the user to quickly locate system performance issues.
You may download and read more at My Oracle Support [ID 1470578.1] and Source Code available at [1471144.1], It require .Net Framework 4.0 to run
Batch Process
"135" is the recommended value when tracing with "TraceAE"
if peoplecode tracing is needed, please also set
You can also do this in process definition of Application Engine to affect this for only 1 program.
Override options : Append : -TRACE 135 -TOOLSTRACESQL 31 -TOOLSTRACEPC 1984
To see which processes are set with this options, run this sql.
SELECT PRCSNAME, PARMLIST FROM PS_PRCSDEFN WHERE UPPER(PARMLIST) LIKE '%TRACE%' AND PRCSTYPE = 'Application Engine';
To generate Database Level Trace, Use TraceAE=2183. This will create file within the "UDUMP" directory on the database server.
It will contain details of each SQL statement that was executed on the database including its runtime execution plan. You can then use this as a input to tkprof for generating formatted trace report. However this will not capture bind variables. To capture bind variables, following trigger is needed.
CREATE OR REPLACE TRIGGER MYDB.SET_TRACE_POCALC
BEFORE UPDATE OF RUNSTATUS ON MYDB.PSPRCSRQST
AND NEW.prcstype = 'Application Engine'
AND NEW.prcsname = 'PO_PO_CALC'
'ALTER SESSION SET TIMED_STATISTICS = TRUE';
'ALTER SESSION SET MAX_DUMP_FILE_SIZE = UNLIMITED';
'ALTER SESSION SET TRACEFILE_IDENTIFIER = ''POCALC''';
'ALTER SESSION SET EVENTS = ''10046 TRACE NAME CONTEXT FOREVER, LEVEL 12''';
SQR Process
A database level trigger is the only way for generating SQR trace.
CREATE OR REPLACE TRIGGER MYDB.SET_TRACE_INS6000
BEFORE UPDATE OF RUNSTATUS ON MYDB.PSPRCSRQST
AND NEW.prcstype = 'SQR REPORT'
AND NEW.prcsname = 'INS6000'
'ALTER SESSION SET TIMED_STATISTICS = TRUE';
EXECUTE IMMEDIATE
EXECUTE IMMEDIATE
'ALTER SESSION SET MAX_DUMP_FILE_SIZE = UNLIMITED';
EXECUTE IMMEDIATE
EXECUTE IMMEDIATE
'ALTER SESSION SET TRACEFILE_IDENTIFIER = ''INS6000''';
EXECUTE IMMEDIATE
EXECUTE IMMEDIATE
'ALTER SESSION SET EVENTS = ''10046 TRACE NAME CONTEXT FOREVER, LEVEL 12''';
Once the raw database trace is captured, execute the program “tkprof” with following sort options:
References
Original URL:
http://www.mybasicknowledge.com/2012/08/peoplesoft-configuration-settings-for.html
Readability
- Appearance
- Send to Kindle
- PeopleSoft Configuration Settings for Tracing
- PeopleSoft Tracing & Logging
- Enterprise Structure Configuration Settings
- Configuration--settings(三-4)
- Peoplesoft AWE Workflow configuration DMS scripts
- Peoplesoft AWE Workflow configuration DMS scripts
- Interview Questions on Peoplesoft for IBM
- Pointers for developing selfservice in PeopleSoft
- VNC settings for Linux
- Settings for CMCC China
- Serialize / Stream (Read/Write) Configuration Settings
- DOCSIS config file-Configuration-File-Specific Settings
- Financial Accounting Global Settings Configuration Steps
- mybatis:"configuration" must match "(properties?,settings?,typeAliase.....
- High-Performance Ray Tracing for Dynamic Scenes
- ETW是什么架构|Event Tracing for Windows
- Five ways for tracing Java execution
- ETW-Event Tracing for Windows入门
- 《通过游戏编程实战教新手学C++编程》学习笔记
- Java IO 基本知识(2)
- Java IO 基本知识
- Java IO 基本知识
- ZBrush
- PeopleSoft Configuration Settings for Tracing
- C++如何使用简单的引用计数
- ArcEngine开发之打印地图(C#)
- 交换排序之冒泡排序
- java ---- 数学函数Math和随机产生数值Random
- Hdu 1010 Tempter of the Bone
- Code128 条码生成
- 初始化与赋值
- Windows socket 编程汇总