summaryrefslogtreecommitdiff
path: root/src/pmie/examples/upm.08
diff options
context:
space:
mode:
Diffstat (limited to 'src/pmie/examples/upm.08')
-rw-r--r--src/pmie/examples/upm.0813
1 files changed, 13 insertions, 0 deletions
diff --git a/src/pmie/examples/upm.08 b/src/pmie/examples/upm.08
new file mode 100644
index 0000000..8ab0e49
--- /dev/null
+++ b/src/pmie/examples/upm.08
@@ -0,0 +1,13 @@
+//
+// Something interesting if you have performance problems with
+// your Oracle data base ...
+//
+db = "oracle.ptg1";
+host = ":moomba.melbourne.sgi.com";
+lru = "#'cache buffers lru chain'";
+gets = "$db.latch.gets $host $lru";
+total = "$db.latch.gets $host $lru + $db.latch.misses $host $lru +
+ $db.latch.immisses $host $lru";
+
+$total > 100 && $gets / $total < 0.2
+ -> alarm "high LRU latch contention";