Hi, I have a query which when run through autotrace and tkprof shows me
about 50,000 gets. But the same query when shot as a part of loadrunner
performance testing causes about 1.2 million consistent gets as seen in the
AWR report. How is this possible?
The database is running on a 2 node RAC with each node having 32 cores.
Tkprof shows this query takes about .8 seconds and causes 50K consistent
gets while when shot through loadrunner it, causes both the RAC nodes to go
as much as 100% CPU. When monitoring session waits I can see that there is
a hot block contention happening on a table with about 19K rows and an
index on this table. This query is responsible for about 94% of the gets
and thus high cpu utilization.
Any clues how to troubleshoot this issue?
Thanks
Regards,
Ashish
