• Forums
    • Public Forums
      • Community Connect
      • Dynatrace
        • Dynatrace Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Open Q&A
      • Network Application Monitoring
        • NAM Open Q&A
  • Home /
  • Public Forums /
  • Network Application Monitoring /
  • NAM Open Q&A /
avatar image
Question by Alexander V. · Jun 30, 2016 at 03:25 PM · nam probe

Strange situation with network - other Slow operations

Hello.

We have at customer with an application which is fat client and oracle database.

During the monitoring we saw a some operations with big network time (till 3 hours) on sql requests.

I turned on ADS data collectiong about this slow operation, but the data shown by ADS is somehow strange.

If we see the operation time is lasts 16 min for example, but on the Load Sequence data we only see 80 ms data. Asked the users, they dont have such long operations...

What can be the problem and where to start the diagnostics?

1.png (80.8 KiB)
2.png (95.1 KiB)
3.png (60.5 KiB)
Comment
Raffaele T.

People who like this

1 Show 0
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

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

5 Replies

  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image

Answer by Ulf T. · Jul 04, 2016 at 08:31 AM

OK - do the trace and try to check if it is indeed cursor Creation and deletion that is being measured.

IF you have DNA, this will be quite straightforward :-)

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

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

avatar image

Answer by Alexander V. · Jul 01, 2016 at 12:25 PM

Is 12.3.8

Yes i can do, but i can't get it outside because it can contain sentitive data.((

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

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

avatar image

Answer by Ulf T. · Jul 01, 2016 at 10:14 AM

Possible - what veriosn are you on?

Can you do a trace (The proof is in the packets - not the pudding :-))?

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

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

avatar image

Answer by Alexander V. · Jul 01, 2016 at 10:11 AM

Hi Ulf,

thanks for your reply.

So why we see only 30 rows on ADS? i think we should see much more iterations from ADS side.

The network time of the operation can last 10 min and can last 2 hours 30 min, i think the probles is not the timeout

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

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

avatar image

Answer by Ulf T. · Jul 01, 2016 at 08:34 AM

Hi

I'm not an Oracle expert in any way but could it be the time the cursor "lives" until it's removed?

3 hours feels like on of those timeouts that you have by default.

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

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

How to get started

First steps in the forum
Read Community User Guide
Best practices of using forum

NAM 2019 SP5 is available


Check the RHEL support added in the latest NAM service pack.

Learn more

LIVE WEBINAR

"Performance Clinic - Monitoring as a Self Service with Dynatrace"


JANUARY 15, 3:00 PM GMT / 10:00 AM ET

Register here

Follow this Question

Answers Answers and Comments

15 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

Cascade flow and RTT

Using Netflow to monitor switch and switch ports

AMD and Netflow

Change AppFlow Listening Port on AMD

Cannot recieve Netflow from Cisco Wireless controller..

Forum Tags

esm siebel Dynatrace Managed license nam probe wan citrix dna rest api configuration mq alerting NAM 2018 dashboard dcrumadvisory reports css nam universal decode database mobileapp RUM ads sap nam console scripting nam server sequence transactions nam 2019 upgrade
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace
      • Dynatrace Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Open Q&A
    • Network Application Monitoring
      • NAM Open Q&A