Mysterious high consistent gets;
From: Ashish Lunawat <ashish.lunawat_at_gmail.com>
Date: Tue, 19 Jun 2018 02:48:33 +0800
Message-ID: <CAEzAyeB6C7kewxVMFK7uq3ZJBdm=buDm6w6DhwCrwvEsOCmJxQ_at_mail.gmail.com>
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?
Date: Tue, 19 Jun 2018 02:48:33 +0800
Message-ID: <CAEzAyeB6C7kewxVMFK7uq3ZJBdm=buDm6w6DhwCrwvEsOCmJxQ_at_mail.gmail.com>
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,
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 18 2018 - 20:48:33 CEST