Mandalika's scratchpad | [ Work blog @Oracle | My Music Compositions ] |
Old Posts: 09.04 10.04 11.04 12.04 01.05 02.05 03.05 04.05 05.05 06.05 07.05 08.05 09.05 10.05 11.05 12.05 01.06 02.06 03.06 04.06 05.06 06.06 07.06 08.06 09.06 10.06 11.06 12.06 01.07 02.07 03.07 04.07 05.07 06.07 08.07 09.07 10.07 11.07 12.07 01.08 02.08 03.08 04.08 05.08 06.08 07.08 08.08 09.08 10.08 11.08 12.08 01.09 02.09 03.09 04.09 05.09 06.09 07.09 08.09 09.09 10.09 11.09 12.09 01.10 02.10 03.10 04.10 05.10 06.10 07.10 08.10 09.10 10.10 11.10 12.10 01.11 02.11 03.11 04.11 05.11 07.11 08.11 09.11 10.11 11.11 12.11 01.12 02.12 03.12 04.12 05.12 06.12 07.12 08.12 09.12 10.12 11.12 12.12 01.13 02.13 03.13 04.13 05.13 06.13 07.13 08.13 09.13 10.13 11.13 12.13 01.14 02.14 03.14 04.14 05.14 06.14 07.14 09.14 10.14 11.14 12.14 01.15 02.15 03.15 04.15 06.15 09.15 12.15 01.16 03.16 04.16 05.16 06.16 07.16 08.16 09.16 12.16 01.17 02.17 03.17 04.17 06.17 07.17 08.17 09.17 10.17 12.17 01.18 02.18 03.18 04.18 05.18 06.18 07.18 08.18 09.18 11.18 12.18 01.19 02.19 05.19 06.19 08.19 10.19 11.19 05.20 10.20 11.20 12.20 09.21 11.21 12.22
Goal: for a given process, find out how the SGA was allocated in different locality groups on a system running Solaris operating system.
Download the shell script, sga_in_lgrp.sh. The script accepts any Oracle database process id as input, and prints out the memory allocated in each locality group.
Usage: ./sga_in_lgrp.sh <pid>
eg.,
# prstat -p 12820 PID USERNAME SIZE RSS STATE PRI NICE TIME CPU PROCESS/NLWP 12820 oracle 32G 32G sleep 60 -20 0:00:16 0.0% oracle/2 # ./sga_in_lgrp.sh 12820 Number of Locality Groups (lgrp): 4 ------------------------------------ lgroup 1 : 8.56 GB lgroup 2 : 6.56 GB lgroup 3 : 6.81 GB lgroup 4 : 10.07 GB Total allocated memory: 32.00 GB
For those who wants to have a quick look at the source code, here it is.
# cat sga_in_lgrp.sh #!/bin/bash # check the argument count if [ $# -lt 1 ] then echo "usage: ./sga_in_lgrp.sh <oracle pid>" exit 1 fi # find the number of locality groups lgrp_count=$(kstat -l lgrp | tail -1 | awk -F':' '{ print $2 }') echo "\nNumber of Locality Groups (lgrp): $lgrp_count" echo "------------------------------------\n" # save the ism output using pmap pmap -sL $1 | grep ism | sort -k5 > /tmp/tmp_pmap_$1 # calculate the total amount of memory allocated in each lgroup for i in `seq 1 $lgrp_count` do echo -n "lgroup $i : " grep "$i \[" /tmp/tmp_pmap_$1 | awk '{ print $2 }' | sed 's/K//g' | awk '{ sum+=$1} END {printf ("%6.2f GB\n", sum/(1024*1024))}' done echo echo -n "Total allocated memory: " awk '{ print $2 }' /tmp/tmp_pmap_$1 | sed 's/K//g' | awk '{ sum+=$1} END {printf ("%6.2f GB\n\n", sum/(1024*1024))}' rm /tmp/tmp_pmap_$1
Like many things in life, there will always be a better or simpler way to achieve this. If you find one, do not fret over this approach. Please share, if possible.
Labels: breakdown database groups locality oracle pmap sga solaris
2004-2019 |