/
heapdump_analyzer
executable file
·58 lines (52 loc) · 2.17 KB
/
heapdump_analyzer
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
#!/bin/ksh
################################################################################
## Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com
## Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.
##
## File name: heapdump_analyzer
## Purpose: Script for aggregating Oracle heapdump chunk sizes
##
## Author: Tanel Poder
## Copyright: (c) http://www.tanelpoder.com
##
## Usage: 1) Take a heapdump ( read http://www.juliandyke.com )
##
## 2) run ./heapdump_analyzer <heapdump tracefile name>
## For example: ./heapdump_analyzer ORCL_ora_4345.trc
##
## Other: Only take heapdumps when you know what you're doing!
## Taking a heapdump on shared pool (when bit 2 in heapdump event
## level is enabled) can hang your database for a while as it
## holds shared pool latches for a long time if your shared pool
## is big and heavily active.
##
## Private memory heapdumps are safer as only the dumped process is
## affected.
##
## On Solaris you may need to replace awk with nawk in this script
##
################################################################################
if [ "$1" == "-t" ]; then
EXCLUDE='dummy_nonexistent_12345'
shift
else
EXCLUDE='Total heap size$'
fi
echo
echo " -- Heapdump Analyzer v1.03 by Tanel Poder ( https://blog.tanelpoder.com )"
echo
echo " Total_size #Chunks Chunk_size, From_heap, Chunk_type, Alloc_reason"
echo " ------------ ------- ------------ ----------------- ----------------- -----------------"
cat $1 | awk '
/^HEAP DUMP heap name=/ { split($0,ht,"\""); HTYPE=ht[2]; doPrintOut = 1; }
/Chunk/{ if ( doPrintOut == 1 ) {
split($0,sf,"\"");
printf "%12.0f , %16s, %16s, %16s\n", $4, HTYPE, $5, sf[2];
}
}
/Total heap size/ {
printf "%12.0f , %16s, %16s, %16s\n", $5, HTYPE, "TOTAL", "Total heap size";
doPrintOut=0;
}
' | grep -v "$EXCLUDE" | sort -n | uniq -c | awk '{ printf " %12.0f %s\n", $1*$2, $0 }' | sort -nr
echo