query hanged in parsing
From: Laurentiu Oprea <laurentiu.oprea06_at_gmail.com>
Date: Fri, 15 Mar 2024 17:58:03 +0200
Message-ID: <CA+riqSXx_=fHiVckPf_MB9YQbocYObeJq5MJ5KrLPwUtJ=ZxUw_at_mail.gmail.com>
Dear all,
Date: Fri, 15 Mar 2024 17:58:03 +0200
Message-ID: <CA+riqSXx_=fHiVckPf_MB9YQbocYObeJq5MJ5KrLPwUtJ=ZxUw_at_mail.gmail.com>
Dear all,
Maybe you can give me an idea, I have a query running in parallel hanging in parsing phase for very long time, I did a flamegraph and seems like stack is looking like this (qesmaUpdatePlanSig is in top of flamegraph)
qkaComputePlanSignature
qkaTraverseQknDescendents
qknApplyCallback
qkaPlanSignatureCB
qesmaUpdatePlanSig
Any ideas what could be the reason for this??
Appreciate your help.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 15 2024 - 16:58:03 CET