Re: performance impact of monitor hint?
- From: Frits Hoogland <frits.hoogland@xxxxxxxxx>
- To: niall.litchfield@xxxxxxxxx
- Date: Sun, 17 Mar 2013 15:05:19 +0100
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset=us-ascii
It's quite easy measurable on Linux with a 2.6.32+ kernel: run 'perf =
record -g -p <pid>' of a session with monitoring and without monitoring, =
and analyse the result. That gives quite conclusive results.
Frits Hoogland
http://fritshoogland.wordpress.com
frits.hoogland@xxxxxxxxx
+31 6 53569942
On Mar 15, 2013, at 7:57 PM, Niall Litchfield =
<niall.litchfield@xxxxxxxxx> 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@xxxxxxxxxxxx> =
wrote:
>> Does the /*+ monitor */ hint affect performance at all?
>> Thanks for your help!
>>=20
>> --
>> //www.freelists.org/webpage/oracle-l
>>=20
>>=20
>>=20
>=20
>=20
> --
> //www.freelists.org/webpage/oracle-l
>=20
>=20
--
//www.freelists.org/webpage/oracle-l
Other related posts:
