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 Mon Feb 19 2007 - 11:44:57 CST
