Your report runs slow? DATABASE FAULT! Transaction performance is low? DATABASE FAULT! Application down again? DATABASE FAULT! And what about the rain? Wait, but what if not… ?
In this talk we will analyze SQL performance from an app perspective, by analyzing a TNS layer. To do this, we will use a TCPDUMP and a new tool – STADO – for analyzing SQL performance from the network layer.
I will show, how SQL execution times can differ, depending on the number of packets, single packet delay, and how we can tune it by designing applications in a proper way.
Speaker: Kamil Stawiarski
Title: “When AWR is not enough, a.k.a. Why your app is not cloud-ready. #SMARTDB”
Recorded on: Wednesday, April 1st 2020