Hi Andi,
thanks. Good point. I thought it was resource manager related. So this might be
no hint other than parsing was taking too long .
Reagrds
Lothar
----Ursprüngliche Nachricht----
Von : andreas.schloegl@xxxxxxxxxxxxxxxx
Datum : 03/05/2019 - 11:23 (MS)
An : l.flatz@xxxxxxxxxx, oracle-l@xxxxxxxxxxxxx, contact@xxxxxxxx,
frits.hoogland@xxxxxxxxx
Betreff : AW: kgskupdbalance: time_used[38149107] greater than
threshold[30000000] current_consumed_cpu_time[67644337]
exec_start_consumed_time[29495230]exec_start_elapsed_time[18137550996799]
p.MsoNormal, li.MsoNormal, div.MsoNormal {
margin: 0.0cm;
margin-bottom: 1.0E-4pt;
font-size: 11.0pt;
font-family: Calibri , sans-serif;
}
a:link, span.MsoHyperlink {
mso-style-priority: 99;
color: rgb(5,99,193);
text-decoration: underline;
}
a:visited, span.MsoHyperlinkFollowed {
mso-style-priority: 99;
color: rgb(149,79,114);
text-decoration: underline;
}
p.msonormal0, li.msonormal0, div.msonormal0 {
mso-style-name: msonormal;
mso-margin-top-alt: auto;
margin-right: 0.0cm;
mso-margin-bottom-alt: auto;
margin-left: 0.0cm;
font-size: 11.0pt;
font-family: Calibri , sans-serif;
}
span.E-MailFormatvorlage18 {
mso-style-type: personal;
font-family: Calibri , sans-serif;
color: windowtext;
}
span.E-MailFormatvorlage19 {
mso-style-type: personal-compose;
font-family: Calibri , sans-serif;
color: windowtext;
}
*.MsoChpDefault {
mso-style-type: export-only;
font-family: Calibri , sans-serif;
mso-fareast-language: EN-US;
}
div.WordSection1 {
page: WordSection1;
}
Hi Lothar,
I always look those things up here: http://orafun.info/
Cu
Andi
Von: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] Im ;
Auftrag von l.flatz@xxxxxxxxxx
Gesendet: Freitag, 03. Mai 2019 11:18
An: oracle-l@xxxxxxxxxxxxx; contact@xxxxxxxx; frits.hoogland@xxxxxxxxx
Betreff: kgskupdbalance: time_used[38149107] greater than threshold[30000000]
current_consumed_cpu_time[67644337]
exec_start_consumed_time[29495230]exec_start_elapsed_time[18137550996799]
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
BearingPoint Software Solutions Austria GmbH
Sitz: Wien
Firmenbuchgericht: Handelsgericht Wien
Firmenbuchnummer: FN 496641 f
The information in this email is confidential and may be legally privileged. If
you are not the intended recipient of this message, any review, disclosure,
copying, distribution, retention, or any action taken or omitted to be taken in
reliance on it is prohibited and may be unlawful. If you are not the intended
recipient, please reply to or forward a copy of this message to the sender and
delete the message, any attachments, and any copies thereof from your system.