kgskupdbalance: time_used[38149107] greater than threshold[30000000] current_consumed_cpu_time[67644337] exec_start_consumed_time[29495230]exec_start_elapsed_time[18137550996799]

From: <l.flatz_at_bluewin.ch>
Date: Fri, 3 May 2019 11:17:48 +0200 (CEST)
Message-ID: <55020440.13236.1556875068907_at_bluewin.ch>

Hi,
does anybody know what kgsk statement stands for? I found it in a trace where long parsing times occured.# The statement to parse had extremly long inlists. kgskupdbalance: time_used[153045464] greater than threshold[30000000] current_consumed_cpu_time[690119909] exec_start_consumed_time[537074445]exec_start_elapsed_time[18138966829946]
*** 2019-05-02 18:52:06.928

kgskupdbalance: time_used[258300603] greater than threshold[30000000] current_consumed_cpu_time[948420512] exec_start_consumed_time[690119909]exec_start_elapsed_time[18139146083208]
*** 2019-05-02 18:53:09.983

kgskupdbalance: time_used[55357911] greater than threshold[30000000] current_consumed_cpu_time[1006849200] exec_start_consumed_time[951491289]exec_start_elapsed_time[18139439551170] This was the parsing time:
That s the parse time
call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ----------

Parse        1    498.54     565.22          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        2      0.04       0.04          0       1456          0           9
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        4    498.58     565.26          0       1456          0           9

IN MOS I only find Doc ID 2126295.1. That does not feel like a fit. I suspect a bug though.
_at_Frits: I know you were looking for long parse times. Regards
Lothar

--
http://www.freelists.org/webpage/oracle-l

Received on Fri May 03 2019 - 11:17:48 CEST