Re: performance impact of monitor hint?

From: Frits Hoogland <frits.hoogland_at_gmail.com>
Date: Sun, 17 Mar 2013 15:05:19 +0100
Message-Id: <F567070A-12B4-4DA1-B70A-5507BC71CCA6_at_gmail.com>

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_at_gmail.com
+31 6 53569942

On Mar 15, 2013, at 7: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!
>>=20
>> --
>> http://www.freelists.org/webpage/oracle-l
>>=20
>>=20
>>=20
>=20
>=20

> --
> http://www.freelists.org/webpage/oracle-l
>=20
>=20

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

Received on Sun Mar 17 2013 - 15:05:19 CET