How to read a trace file
edited Jun 2, 2014 9:03AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 3 commentsAnswered ✓
Hi all,
I have a peoplesoft sqltrace file. I can not understand it well. Would you please help me ?
I want to now that what is the duration of executing the first (ligne 1-55403) and the second query (ligne 1-184).
Here is the trace :
| PSAPPSRV.65816 | 1-55403 15.49.42 | 0.000 Cur#1.MYSYSTEM RC=0 Dur=0.000 COM Stmt=SELECT PTCUSTOMFORMAT FROM PSUSEROBJTYPE WHERE MENUNAME = :1 AND PNLGRPNAME = :2 AND PNLNAME = AND OPRID = :4 AND FIELDTYPE = :5 |
| PSAPPSRV.65816 | 1-55404 15.49.42 | 0.000 Cur#1.MYSYSTEM RC=0 Dur=0.000 Bind-1 type=2 length=12 value=PV_MAIN_MENU |
| PSAPPSRV.65816 | 1-55405 15.49.42 | 0.000 Cur#1.MYSYSTEM RC=0 Dur=0.000 Bind-2 type=2 length=14 value=PV_REQ_PO_DTLS |
| PSAPPSRV.65816 | 1-55406 15.49.42 | 0.000 Cur#1.MYSYSTEM RC=0 Dur=0.000 Bind-3 type=2 length=14 value=PV_REQ_PO_DTLS |
0