Re: performance impact of monitor hint?
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 15 Mar 2013 19:00:19 +0000
Message-ID: <CABe10sYnFVHq04GPaGy-9fjo6G90YQk3BcCVHxBywbaK9qhZ_Q_at_mail.gmail.com>
And of course as soon as I hit send it occurs that you'd probably only use the hint when your problem statement takes less than 3s and doesn't run in parallel. Those cases will almost certainly turn out to be row by agonizing row problems anyway.
On Mar 15, 2013 6:57 PM, "Niall Litchfield" <niall.litchfield_at_gmail.com> wrote:
> I imagine there might be cases where the rowsource stats gathered impact
> performance (similar issues have affected trace files ) but I haven't seen
> any, and given you'd be using this to look at badly performing SQL in the
> first place I'd say use on your problems until you encounter an actual
> issue. RTSM is, frankly, worth the extra cost for the pack on its own.
> On Mar 15, 2013 6:46 PM, "Josh Collier" <Josh.Collier_at_banfield.net> wrote:
>
>> Does the /*+ monitor */ hint affect performance at all?
>> Thanks for your help!
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
Date: Fri, 15 Mar 2013 19:00:19 +0000
Message-ID: <CABe10sYnFVHq04GPaGy-9fjo6G90YQk3BcCVHxBywbaK9qhZ_Q_at_mail.gmail.com>
And of course as soon as I hit send it occurs that you'd probably only use the hint when your problem statement takes less than 3s and doesn't run in parallel. Those cases will almost certainly turn out to be row by agonizing row problems anyway.
On Mar 15, 2013 6:57 PM, "Niall Litchfield" <niall.litchfield_at_gmail.com> wrote:
> I imagine there might be cases where the rowsource stats gathered impact
> performance (similar issues have affected trace files ) but I haven't seen
> any, and given you'd be using this to look at badly performing SQL in the
> first place I'd say use on your problems until you encounter an actual
> issue. RTSM is, frankly, worth the extra cost for the pack on its own.
> On Mar 15, 2013 6:46 PM, "Josh Collier" <Josh.Collier_at_banfield.net> wrote:
>
>> Does the /*+ monitor */ hint affect performance at all?
>> Thanks for your help!
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 15 2013 - 20:00:19 CET