Re: How to count round trips from ADO via OraOLEDB to Oracle?

Thanks, that works nicely. (Or maybe I should subtract one round trip because of this query itself? :-)

• Phil

In microsoft.public.data.ado, "Charles Hooper" <hooperc2000_at_yahoo.com> wrote:

On Feb 19, 11:35 am, Phil Davidson <P..._at_PhilDavidson.com> wrote:
> Actually, since the ADO queries are passing via Oracle's OLEDB provider
> (OraOLEDB), maybe the right question is: How can I count how many round
> trips OraOLEDB is initiating?
>
> (Posted to microsoft.public.data.ado and comp.databases.oracle.server.)
>
> -- Phil
>
> In microsoft.public.data.ado, Phil Davidson <P..._at_PhilDavidson.com>
> wrote:
>
> I'm querying an Oracle database via ADO. How can I count the round trips
> made to the database? (I thought I would find the answer using PerfMon
> or perhaps Visual Studio Analyzer, but I haven't found the answer yet.
> Maybe the answer is in Visual Studio Analyzer but I have difficulty
> getting it to capture events.)
>
> -- Phil Davidson
> phil _at_ ivorycc _dot_ com
> phil _at_ phildavidson _dot_ com

Something like this might work:
SELECT
  SN.NAME,
  MS.VALUE
FROM
  V$STATNAME SN,
  V$MYSTAT MS
WHERE
  SN.NAME='SQL*Net roundtrips to/from client'   AND SN.STATISTIC#=MS.STATISTIC#; Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Tue Feb 20 2007 - 11:20:35 CST