Thursday, July 11, 2013

Jonathan Lewis: v$lock and OEM

Jonathan Lewis introduces us to a problem with the performance of the v$lock table with OEM, the v$resource table, and how we can gather stats on individual x$ tables to increase performance.  I thought this was a good read because a. we might encounter this in the future since we're on 11.2.0.2 and b. it's yet another good example of how to identify performance issues that may be small in nature but could have a large effect on your system.  From a few of the posts over the past week, you can see that I find the prospect of digging deeper into the system very interesting and something I'm looking forward to!

No comments:

Post a Comment