2012-11-20

System Performance Statistics Report Summary

statpack

ls -lt /sharedrive/data/statpack_result | grep MM
/sharedrive/scripts/perfstat/spreport.sh MM

sqlplus perfstat/password@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DBServer)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=xxrac)))"
@$ORACLE_HOME/rdbms/admin/spreport.sql
@?/rdbms/admin/spreport.sql
@$ORACLE_HOME/rdbms/admin/sppurge.sql

find max, min snap_id

select startup_time, count(1) from STATS$snapshot where snap_time between to_date('2014-11-01', 'yyyy-mm-dd') and to_date('2014-11-30', 'yyyy-mm-dd') group by startup_time;

select * from STATS$snapshot where snap_time between to_date('2014-11-01', 'yyyy-mm-dd') and to_date('2014-11-30', 'yyyy-mm-dd') and to_char(startup_time, 'yyyy-mm-dd hh24:mi:ss') = '2014-10-16 18:42:52' order by snap_id;

http://burleson-dba.com/SP/

performance statistic

/aix-combine-csv-daily-to-csv-month-parameter.sh Server 2015 07
/aix-calc-monthly-avg.sh Server 2015 07 
/aix-calc-monthly-avg.sh Server 2015 07 | awk  -F ','  '{print $2","$4"M"}'
/aix-calc-monthly-avg.sh Server 2015 07 | awk  -F ','  '{print $2","$5"%"}'

select df.tablespace_name "Tablespace",
round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace)) || '%'
"Pct. Free"
from
(select tablespace_name,
round(sum(bytes) / 1048576) TotalSpace
from dba_data_files 
group by tablespace_name) df,
(select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name
from dba_segments 
group by tablespace_name) tu
where df.tablespace_name = tu.tablespace_name order by df.tablespace_name ;

WEB server

D:\perfstat-bin\convert\relog-daily-blg-to-monthly-csv.bat 201501
./relog-daily-blg-to-monthly-csv.bat 201501
check D:\perfstat-csv

cd /cygdrive/d/perfstat-bin/convert
relog ../../PerfLogs/Web_201506*.blg -cf relog-parameters.txt -f csv -o ../../perfstat-csv/Web_201506.csv

AIX