In this video, Andrew Holdsworth, Senior Director of Oracle's Real World Performance team, demonstrates the negative impact of soft and hard parsing on performance.
Great video. One question I have - how are you getting the insert / update / select TPS measurements in the top right of the screen? Are they coming out of the database v$ tables, or is that a connection pool monitoring thing?
Also, in the middle section, which tables do the total parse rate and Execution Rate stats come from?
same question here
stoaca 7 months ago
Great video. One question I have - how are you getting the insert / update / select TPS measurements in the top right of the screen? Are they coming out of the database v$ tables, or is that a connection pool monitoring thing?
Also, in the middle section, which tables do the total parse rate and Execution Rate stats come from?
fendale2000 7 months ago