How long was the query
edited Jun 5, 2014 3:21AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 3 commentsAnswered ✓
Hi,
on FSCM8 and tools 8.44.
In trace file we have :
| PSAPPSRV.65896 | 1-11061 15.43.41 | 0.000 Cur#1.MYSYSTEM RC=0 Dur=0.000 COM Stmt=SELECT COUNT(*) from PS_SHIP_INF_INV where SOURCE_BUS_UNIT = :1 and REQ_ID = :2 and REQ_LINE_NBR = | ||
| PSAPPSRV.65896 | 1-11062 15.43.41 | 0.000 Cur#1.MYSYSTEM RC=0 Dur=0.000 Bind-1 type=2 length=5 value=01 | ||
| PSAPPSRV.65896 | 1-11063 15.43.41 | 0.000 Cur#1.MYSYSTEM RC=0 Dur=0.000 Bind-2 type=2 length=10 value=0000275852 | ||
| PSAPPSRV.65896 | 1-11064 15.43.41 | 0.000 Cur#1.MYSYSTEM RC=0 Dur=0.000 Bind-3 type=19 length=1 value=1 | ||
| PSAPPSRV.65896 | 1-11065 15.44.27 46.440 Cur#1.MYSYSTEM RC=0 Dur=0.000 Fetch | |||
| PSAPPSRV.65896 | 1-11066 15.44.27 | 0.000 | 12: | If &PV_COUNT <= 0 Then |
Can you please say me how long the query : SELECT COUNT(*) from PS_SHIP_INF_INV has taken ?
I attach the trace file. May you take a look at it please ?
0