question

OraLearner avatar image
OraLearner asked

How can we resolve the application hanging issue in OLTP ?

Many users are complaining that their application is hanging. How we will resolve this situation in OLTP ? Thank you.

oracleperformance
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
HillbillyToad avatar image
HillbillyToad answered

Have you played the finger-pointing game before? This is where you blame the database, the dbas blame the application, the application admins blame the network, and the network folks blame all the storage peeps.

You need to drill into their session and looks for WAIT events to see where the bottleneck is happening. You can use a tool like OEM or Spotlight to see if the hot spots are highlighted.

Or you can trace a user session and use TkProf or a tool like Toad to analyze the trace file(s) to see why their application is hung - assuming it's happening in the database.

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

OraLearner avatar image OraLearner commented ·
Thank you for your valuable answer..
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.