Strange situation with network - other Slow operations

Question

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 (82.7 kB)

2.png (97.4 kB)

3.png (62.0 kB)

1

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 52.4 MB each and 262.1 MB total.

Answer 1 · 2016-07-04T08:31:41Z

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 :-)

0 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 52.4 MB each and 262.1 MB total.

Answer 2 · 2016-07-01T12:25:31Z

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.((

0 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 52.4 MB each and 262.1 MB total.

Answer 3 · 2016-07-01T10:14:20Z

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 :-))?

0 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 52.4 MB each and 262.1 MB total.

Answer 4 · 2016-07-01T10:11:18Z

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

0 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 52.4 MB each and 262.1 MB total.

Answer 5 · 2016-07-01T08:34:13Z

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.

0 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 52.4 MB each and 262.1 MB total.

Strange situation with network - other Slow operations

5 Replies

Join the conversation!

NAM 2019 SP3 is available

LIVE WEBINAR

Follow this Question

Related Questions

Forum Tags