blob: 8ab0e49e5151a638d522a84f9ce4f580513bd2f8 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
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";
|
