APM shows large executions of SQL after migration to Oracle 12c

Asked Jul 31 '19 at 12:15

Active Jul 31 '19 at 15:52

Viewed 31 times

After migration from oracle 10c to 12c, there are many times where in intrascope we see large number of same sql executing large number of times, which is causing heap space issue.

Since code is same and issue did not appear in 10c, why it uis now causing issue after migration?

Example:

In java we have method repository. load(id) which is called in for loop in many places . So this is sql we seen in intrascope APM where it was executed 500 000 times in 30 mins. and suddenly increases heap size to max.

This issues did not apprear in 10c

Below is APM heap space increased in 30 mins

SQL executions

edited Jul 31 '19 at 15:52

James Z

12,209
10
24
44

asked Jul 31 '19 at 12:15

sshet

1,152
1
6
15

Please provide a minimal, complete and verifiable example, so that we can reproduce your issue. – marstran Jul 31 '19 at 12:22
Hello marstran , i have edited, let me know if needed anything – sshet Jul 31 '19 at 12:25
Adaptive Query Optimization. https://oracle-base.com/articles/12c/adaptive-query-optimization-12cr1 – ibre5041 Jul 31 '19 at 12:33
Thanks ibre, you means to say there is some configuration we need to do in 12c ? – sshet Jul 31 '19 at 12:34
for information response time is very good 0.006 s , only it is exceuted many times – sshet Jul 31 '19 at 12:36

APM shows large executions of SQL after migration to Oracle 12c

0 Answers0