Re: Help: How do you find where you are using array processing?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 10 May 2002 18:45:20 +0200
Message-ID: <87undug3drqor8t6g9ml8m6g3go9ot4vsm@4ax.com>

On Fri, 10 May 2002 14:20:42 GMT,
u705413818_at_spawnkill.ip-mobilphone.net (Joe Bayer) wrote:

>When I was reading some oracle performance tuning paper, they mentioned
>that array processing can increblly increase the performance.
>
>How do I find out whethere I am using array process or not other than
>asking the developers or trace the each sql statement in our database?
>
>Thanks for your help.
>

Enable event 10046 for a session. For every fetch your trace file will now indicate how many rows have been fetched.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri May 10 2002 - 11:45:20 CDT