Welcome, Guest
Username: Password: Remember me

TOPIC: ReviewMRSKEW

ReviewMRSKEW 3 years 1 month ago #264

Hi

just trying some differnt mrskew commands. Why the last 2 not picking up the sqlids?

mrskew SMP1_ora_26188.trc --group='$sqlid' --where=1

'$sqlid' DURATION % CALLS MEAN MIN MAX
akmff4zpy1unu 2890.742678 99.3% 113 25.581794 0.000000 2890.710756
#0 8.408762 0.3% 4275 0.001967 0.000000 6.343065
aumu18tncas5k 3.818822 0.1% 6 0.636470 0.000000 3.818818
837kfnc26wua0 3.073737 0.1% 6 0.512289 0.000000 3.063732
9kmvf1j8b6u9d 0.648946 0.0% 2574 0.000252 0.000000 0.247655
amabyvt27pd0z 0.575169 0.0% 144 0.003994 0.000000 0.472339
ds7zdmz16tnfy 0.430777 0.0% 15 0.028718 0.000000 0.417488
90k1vfphhvrt6 0.223476 0.0% 9 0.024831 0.000000 0.220000
32yg5cccd1r3c 0.167750 0.0% 30 0.005592 0.000000 0.149833
fgmw3x5gyxq82 0.162296 0.0% 6 0.027049 0.000000 0.160000
cgnd2t0cgqs37 0.108193 0.0% 141 0.000767 0.000000 0.040000
a7svwv9htyv42 0.052360 0.0% 12 0.004363 0.000000 0.028181
10juyq4xk911w 0.042155 0.0% 87 0.000485 0.000000 0.010000
gzxbn8g9291jy 0.041232 0.0% 24 0.001718 0.000000 0.010000
2dd4j0kkvw9zb 0.038065 0.0% 48 0.000793 0.000000 0.020000
1wuaanb7jfzw1 0.036129 0.0% 49 0.000737 0.000000 0.010000
gj5g6nuyy7680 0.032402 0.0% 42 0.000771 0.000000 0.012296
49sk87gxk8agd 0.028851 0.0% 42 0.000687 0.000000 0.010000
9t2dut4nsggps 0.027434 0.0% 6 0.004572 0.000000 0.020000
91k7w9p2xfa3x 0.025429 0.0% 48 0.000530 0.000000 0.010000
140 others 1.083319 0.0% 2353 0.000460 0.000000 0.020008
TOTAL (160) 2909.767982 100.0% 10030 0.290106 0.000000 2890.710756

mrskew SMP1_ora_26188.trc --name=read --where='$p3 ==1' --group='substr($tim,0,-(9+1))' --label-group=1000-S-RANGE
1000-S-RANGE DURATION % CALLS MEAN MIN MAX
17350 0.083013 100.0% 9 0.009224 0.000171 0.022283
TOTAL (1) 0.083013 100.0% 9 0.009224 0.000171 0.022283

mrskew SMP1_ora_26188.trc --name=read --where='$p3 == 1' --group='$sqlid' --label-group=SQLID
SQLID DURATION % CALLS MEAN MIN MAX
#0 0.083013 100.0% 9 0.009224 0.000171 0.022283
TOTAL (1) 0.083013 100.0% 9 0.009224 0.000171 0.022283
The administrator has disabled public write access.

Re:ReviewMRSKEW 3 years 2 days ago #269

Sorry for the horrible latency! We've had a problem with our notification gizmo on this forum and didn't realize it.

Your second mrskew command doesn't show any information about sqlid because your command line didn't ask for it; that is, you didn't refer to $sqlid in the --group expression.

The third one is giving you the best it can. The only read calls in the trace file for which $p3==1 were associated with cursor id #0, which is never associated with a specific SQL statement. Cursor #0 is generally how Oracle maps implicit COMMIT workload and LOB processing. When there is no sqlid for a given call, mrskew tries to be as helpful as it can by giving you the cursor id.

Hope this helps,

Cary
The administrator has disabled public write access.