Re: performance impact of monitor hint?
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 15 Mar 2013 18:57:19 +0000
Message-ID: <CABe10saT6hBdeAaOWnM-XWVQ=BMzYhZcTJTB3hkfMY-tjFtD7A_at_mail.gmail.com>
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 18:57:19 +0000
Message-ID: <CABe10saT6hBdeAaOWnM-XWVQ=BMzYhZcTJTB3hkfMY-tjFtD7A_at_mail.gmail.com>
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 - 19:57:19 CET