OLTP Performance - The Trouble with Parsing

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. Copyright © 2012 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.

• Category

  Science & Technology

[Silviu Stochita]

same question here



[fendale2000]

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?