Troubleshooting App unresponsiveness due to Oracle DB

Описание: Recently we encountered a production in an application. This application was connecting to multiple systems of records (SOR). Oracle RAC cluster is one of the primary systems of record. This Oracle RAC cluster was slowing down due to resource constraints. This slowdown in the Oracle RAC cluster degraded the entire application's response time. In this video, let's discuss the steps we pursued to troubleshoot this problem.

If you liked this video, you'll love our Java Performance Masterclass. Learn more:
https://ycrash.io/java-performance-tr...

- - - - - - - - - - - - - -

Topics covered:

00:30 - yCrash open source script
02:05 - Thread dump report from yCrash
02:30 - Analyzing thread dumps
04:58 - Flame graph in thread dump analysis
09:00 - Oracle database slowdown

- - - - - - - - - - - - - -

Links shared in the video:

yCrash open source script:
https://github.com/ycrash/yc-data-script

- - - - - - - - - - - - - -

Read more in this blog:
https://blog.ycrash.io/2022/09/06/tro...

- - - - - - - - - - - - - -

Our Tools:

yCrash: https://yCrash.io/
GCeasy: https://gceasy.io/
HeapHero: https://heaphero.io/
fastThread Tool: https://fastthread.io/

- - - - - - - - - - - - - -

SRE Community:

Need help in troubleshooting your performance problems?
Post here: https://answers.ycrash.io/

- - - - - - - - - - - - - -

Follow us on:

LinkedIn:   / ycrash  
Instagram:   / ycrash_rca  
Facebook:   / tier1app  
Twitter:   / tier1app  

- - - - - - - - - - - - - -

Related videos:

How to use Java thread dump flame Graph?
   • Master Java Thread Dump Flame Graphs: Fix ...  

- - - - - - - - - - - - - -

#troubleshooting | #troubleshootingoracle | #oracle | #endpointtroubleshooting | #agenttroubleshooting | #unabletoopenexefile | #howtofixappsnotrespondinginwindows10 | #howtofix ppsnotrespondinginwindows11 | #fixcmdunabletoopen | #howtoopenexefilesonwindows8 | #howtodeletecorruptedandunreadablefolder | #unabletoopencmd | #oraclefusiontechnicalonlinetraining | #howtocloneaclouddatabase | #howtofixwindows10appscrashing