SQL performance in prod
From: V Raman <vraman4list_at_gmail.com>
Date: Wed, 18 Jul 2018 17:30:02 -0500
Message-ID: <CAGAYmOCig470NFCTFQC9wCY=Lc46H=CZnTBXY2RG8X8D2PrGeg_at_mail.gmail.com>
List
Date: Wed, 18 Jul 2018 17:30:02 -0500
Message-ID: <CAGAYmOCig470NFCTFQC9wCY=Lc46H=CZnTBXY2RG8X8D2PrGeg_at_mail.gmail.com>
List
We have a SQL that is performing intermittently bad in our prod env. The
good ones take 2 to 5 mins, the bad ones run for hours we kill them. They
run fine in the non prod env. I ran an awsqrpt and based on that I see that
there are a few executions with the bad ones taking hours. Looking at the
differences in the execution plan, the good ones have lots of nested loops
in them, with the bad ones having lots of hash joins.
I am trying to figure out the cause(s). Assuming there is not much change
in the DB, the first thing that comes to mind is statistics. Can the
listers help with ideas? Thanks.
If anyone is interested is seeing the report, i can provide a link to them
by email.
Venky
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 19 2018 - 00:30:02 CEST