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@xxxxxxxxxx" <l.flatz@xxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx, contact@xxxxxxxx, frits.hoogland@xxxxxxxxx
  • Date: Fri, 3 May 2019 11:17:48 +0200 (CEST)

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.
@Frits: I know you were looking for long parse times.
Regards
Lothar

Other related posts:

  • » kgskupdbalance: time_used[38149107] greater than threshold[30000000] current_consumed_cpu_time[67644337] exec_start_consumed_time[29495230]exec_start_elapsed_time[18137550996799] - l.flatz@xxxxxxxxxx