Re: performance impact of monitor hint?

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: Josh.Collier@xxxxxxxxxxxx
  • Date: Fri, 15 Mar 2013 18:57:19 +0000

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@xxxxxxxxxxxx> wrote:
> Does the /*+ monitor */ hint affect performance at all?
> Thanks for your help!
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>


--
//www.freelists.org/webpage/oracle-l


Other related posts: