Re: SQL performance in prod
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 23 Jul 2018 15:45:57 -0400
Message-ID: <bc08e5db-8e7f-876a-af12-f7b780903ae0_at_gmail.com>
Date: Mon, 23 Jul 2018 15:45:57 -0400
Message-ID: <bc08e5db-8e7f-876a-af12-f7b780903ae0_at_gmail.com>
Use /*+ GATHER_PLAN_STATISTICS */ hint and you will see E-Rows and
A-Rows in the plan. E-Rows are estimated rows, A-rows are actual rows.
The problem is where there is significant difference between the two.
Regards
On 7/18/2018 6:30 PM, V Raman wrote:
> 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.
>
--
Mladen Gogala Database Consultant Tel: (347) 321-1217
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jul 23 2018 - 21:45:57 CEST