Number of records fetched by SQL (Select)

Question

Question by Anurag S. · Jun 19, 2014 at 08:15 PM ·

Number of records fetched by SQL (Select)

Hi,

Can we get the number of records fetched in a SQL query from dynaTrace?

0

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Answer 1 · 2015-04-14T05:37:59Z

Answer by Andreas G. · Apr 14, 2015 at 05:37 AM

Hi.I just double checked with engineering and it seems I was wrong. Row Count in the Moment is ONLY available for MongoDB databases. Other databases accessed through JDBC or ADO.NET do not provide that data with our current implementation. There is however an RFE for this that you can up-vote: RFE - Can we get the row count from oracle

sorry for the incorrect statement i made in the beginning.

0 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Answer 2 · 2015-04-10T06:38:06Z

Answer by Yifan L. · Apr 10, 2015 at 06:38 AM

Could you specify what are the JDBC Drivers that we can get the row count data?

0 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Answer 3 · 2014-06-24T15:41:10Z

Answer by Andreas G. · Jun 24, 2014 at 03:41 PM

Hi Erik

Unfortunately we dont get row counts for all SQL Statements. We only get them for certain JDBC Drivers and it then also depends on how the data is retrieved. AFAIK - if you use cursors to iterate through the resultset we dont get the row count as it is not provided by the JDBC Driver when you execute the query.

Andi

0 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Answer 4 · 2014-06-24T05:28:58Z

Answer by Erik O. · Jun 24, 2014 at 05:28 AM

Andi, is there a sensor I should add to get numbers in the Row count column?
I'm getting dashes instead of numbers.

--Erik

0 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Answer 5 · 2014-06-19T23:28:50Z

Answer by Andreas G. · Jun 19, 2014 at 11:28 PM

There is a "Row Count" measure we capture when a SQL Statement is executed. However - this number might not be 100% accurate as we do not always get the full row count when the SQL Statement is executed.

0 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Number of records fetched by SQL (Select)

5 Replies

How to get started:

NAM 2019 SP3 is available

LIVE WEBINAR

Follow this Question

Forum Tags