Skip to main content
Question

when will v_monitor.execution_engine_profiles be populated?

  • October 31, 2023
  • 1 reply
  • 1 view

qihua_wu
Forum|alt.badge.img+1

Per the document, it said when we profile a sql, it will populate this table. But from our system, we have many sql which are not profiled, this table is also populated for them. I am wondering whether this kind of populated data when no profile is partial in comparison when doing profile. Or the only difference between profile and non-profile is to print out the mem usage message?

1 reply

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • November 1, 2023

it will populate even when the query is not profiled as long as the execution time of query crosses value set for SaveDCEEProfileThresholdUS