UNIX HEALTH CHECK FOR AIX --- oratest

Report

This report is generated by Inspur Power System.Co.Ltd UNIX Health Check for AIX. It is can be run in physical-partition、vios-partition、vioc-partition, including AIX、PowerHA、GPFS . selected when the checkall.ksh script was run, it will list each check script, the returncode of the check script, the output of the check script and a description. At the end of this report is an overview of all scripts run and a score report.

AIX-PowerHA-GPFS-Oracle

Options selected

System configuration

Individual checks

to_char(sysdate-8, 'yyyy-mm-dd hh24:mi:ss') and s.COMMAND_ID=b.COMMAND_ID order by s.START_TIME desc 572fbaj0fdw2bselect output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options )) 5aa4qy7098w5kSELECT seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5, count() over () from sys.wri$_adv_message_groups WHERE id = :1 ORDER BY seq 7cfz5wy9caaf4SELECT NAME NAME_COL_PLUS_SHOW_PARAM, DECODE(TYPE, 1, 'boolean', 2, 'string', 3, 'integer', 4, 'file', 5, 'number', 6, 'big integer', 'unknown') TYPE, DISPLAY_VALUE VALUE_COL_PLUS_SHOW_PARAM FROM V$PARAMETER WHERE UPPER(NAME) LIKE UPPER(:NMBIND_SHOW_OBJ) ORDER BY NAME_COL_PLUS_SHOW_PARAM, ROWNUM 7ng34ruy5awxqselect i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj# 7xa8wfych4madSELECT SUM(blocks) FROM x$kewx_segments WHERE segment_name IN ('SQL$', 'I_SQL$_PKEY', 'SQLLOG$') OR segment_name LIKE '%SMB$CONFIG%' OR segment_name LIKE '%SQL$TEXT%' OR segment_name LIKE '%SQLOBJ$%' OR segment_name IN (SELECT DISTINCT lob_name FROM x$kewx_lobs WHERE table_name IN ('SQL$', 'SQL$TEXT', 'SQLOBJ$', 'SQLOBJ$DATA', 'SQLOBJ$AUXDATA')) 82nzukz9sbj9mselect client_name, status from dba_autotask_client 89w8y2pgn25ydselect ts# from ts$ where ts$.online$ != 3 and bitand(flags, 2048) != 2048 8akbb0380s5q5SELECT T.TABLESPACE_NAME TABLESPACE_NAME, T.CONTENTS CONTENTS, T.STATUS STATUS, ROUND(SUM(A.BYTES)/1048576) ALL_MB, ROUND(SUM(NVL(F.BYTES, 0))/1048576) FREE_MB, ROUND(100 SUM(NVL(F.BYTES, 0))/SUM(A.BYTES)) PCT_FREE, ROUND(SUM(DECODE(MAXBYTES, 0, A.BYTES, MAXBYTES))/1048576) MAX_MB, ROUND((SUM(DECODE(MAXBYTES, 0, 0, MAXBYTES - A.BYTES)) + SUM(NVL(F.BYTES, 0)))/1048576) FREE_EXT, ROUND(100 (SUM(DECODE(MAXBYTES, 0, 0, MAXBYTES - A.BYTES)) + SUM(NVL(F.BYTES, 0))) / SUM(DECODE(A.MAXBYTES, 0, A.BYTES, A.MAXBYTES))) PCT_EXT FROM DBA_DATA_FILES A, DBA_TABLESPACES T, (SELECT FILE_ID, SUM(BYTES) BYTES FROM DBA_FREE_SPACE GROUP BY FILE_ID) F WHERE A.FILE_ID = F.FILE_ID(+) AND A.TABLESPACE_NAME = T.TABLESPACE_NAME AND T.CONTENTS != 'TEMPORARY' GROUP BY T.TABLESPACE_NAME, T.CONTENTS, T.STATUS ORDER BY ROUND(100 SUM(NVL(F.BYTES, 0)) / SUM(A.BYTES)) 8gbygchn0n3g5 SELECT '

' || t.owner || '

' owner , '

' || t.type_name || '

' type_name , '

' || t.typecode || '

' typecode , '

' || a.attr_name || '

' attribute_name , (CASE WHEN (a.length IS NOT NULL) THEN a.attr_type_name || '(' || a.length || ')' WHEN (a.attr_type_name='NUMBER' AND (a.precision IS NOT NULL AND a.scale IS NOT NULL)) THEN a.attr_type_name || '(' || a.precision || ', ' || a.scale || ')' WHEN (a.attr_type_name='NUMBER' AND (a.precision IS NOT NULL AND a.scale IS NULL)) THEN a.attr_type_name || '(' || a.precision || ')' ELSE a.attr_type_name END) attribute_datatype , DECODE( a.inherited , 'YES' , '

' || a.inherited || '

' , 'NO' , '

' || a.inherited || '

' , '

' || a.inherited || '

') inherited FROM dba_types t , dba_type_attrs a WHERE t.owner = a.owner AND t.type_name = a.type_name AND t.owner NOT IN ( 'CTXSYS' , 'DBSNMP' , 'DMSYS' , 'EXFSYS' , 'IX' , 'LBACSYS' , 'MDSYS' , 'OLAPSYS' , 'ORDSYS' , 'OUTLN' , 'SYS' , 'SYSMAN' , 'SYSTEM' , 'WKSYS' , 'WMSYS' , 'XDB') ORDER BY t.owner , t.type_name , t.typecode , a.attr_no 8j04xm53d26dpselect 'SGA' AS NAME, ROUND(sum(value)/1024/1024, 2)||'M' AS "SIZE(M)" from v$sga UNION select 'SGA_conf' AS NAME, SGA_SIZE||'M' AS "SIZE(M)" from v$sga_target_advice where SGA_SIZE_FACTOR=1 union select 'PGA_use' AS NAME, ROUND(value/1024/1024, 2)||'M' AS "SIZE(M)" from v$pgastat where name='total PGA allocated' UNION select 'PGA_conf' AS NAME, PGA_TARGET_FOR_ESTIMATE/1024/1024||'M' AS "SIZE(M)" from v$pga_target_advice where PGA_TARGET_FACTOR=1 union select 'TOTAL' AS NAME, ((SELECT ROUND(sum(value)/1024/1024, 2) from v$sga)+(select ROUND(value/1024/1024, 2) from v$pgastat where name='total PGA allocated'))||'M' AS "SIZE(M)" FROM DUAL 8jz78ftfxx59wSELECT OCCUPANT_NAME , SCHEMA_NAME , SPACE_USAGE_KBYTES/1024 SPACE_USAGE_MB FROM V$SYSAUX_OCCUPANTS ORDER BY SPACE_USAGE_KBYTES DESC , OCCUPANT_NAME 8swypbbr0m372select order#, columns, types from access$ where d_obj#=:1 985vbnfm9j8cjselect CLIENT_NAME, TASK_NAME, STATUS from DBA_AUTOTASK_TASK 9babjv8yq8ru3BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END; 9fhmu7pvx6rzq DECLARE CURSOR get_instances IS SELECT COUNT(DISTINCT instance_number) FROM sys.wrm$_database_instance; CURSOR get_wr_control_info IS SELECT snapint_num, retention_num FROM sys.wrm$_wr_control; CURSOR get_snaps IS SELECT SUM(all_snaps) , SUM(good_snaps) , SUM(today_snaps) , SYSDATE - MIN(begin_interval_time) FROM (SELECT 1 AS all_snaps , (CASE WHEN s.status = 0 THEN 1 ELSE 0 END) AS good_snaps , (CASE WHEN (s.end_interval_time > SYSDATE - 1) THEN 1 ELSE 0 END) AS today_snaps , CAST(s.begin_interval_time AS DATE) AS begin_interval_time FROM sys.wrm$_snapshot s ); CURSOR sysaux_occ_usage IS SELECT occupant_name , schema_name , space_usage_kbytes/1024 space_usage_mb FROM v$sysaux_occupants ORDER BY space_usage_kbytes DESC , occupant_name; mb_format CONSTANT VARCHAR2(30) := '99, 999, 990.0'; kb_format CONSTANT VARCHAR2(30) := '999, 999, 990'; pct_format CONSTANT VARCHAR2(30) := '990.0'; snapshot_interval NUMBER; retention_interval NUMBER; all_snaps NUMBER; awr_size NUMBER; sna p_size NUMBER; awr_average_size NUMBER; est_today_snaps NUMBER; awr_size_past24 NUMBER; good_snaps NUMBER; today_snaps NUMBER; num_days NUMBER; num_instances NUMBER; BEGIN OPEN get_instances; FETCH get_instances INTO num_instances; CLOSE get_instances; OPEN get_wr_control_info; FETCH get_wr_control_info INTO snapshot_interval, retention_interval; CLOSE get_wr_control_info; OPEN get_snaps; FETCH get_snaps INTO all_snaps, good_snaps, today_snaps, num_days; CLOSE get_snaps; FOR occ_rec IN sysaux_occ_usage LOOP IF (occ_rec.occupant_name = 'SM/AWR') THEN awr_size := occ_rec.space_usage_mb; END IF; END LOOP; snap_size := awr_size/all_snaps; awr_average_size := snap_size86400/snapshot_interval; today_snaps := today_snaps / num_instances; IF (num_days < 1) THEN est_today_snaps := ROUND(today_snaps / num_days); ELSE est_today_snaps := today_snaps; END IF; awr_size_past24 := snap_size est_today_snaps; DBMS_OUTPUT.PUT_LINE(''); DBM S_OUTPUT.PUT_LINE(''); DBMS_OUTPUT.PUT_LINE('' ); DBMS_OUTPUT.PUT_LINE('' ); IF (num_instances > 1) THEN DBMS_OUTPUT.PUT_LINE('' ); END IF; DBMS_OUTPUT.PUT_LINE(''); DBMS_OUTPUT.PUT_LINE('' ); DBMS_OUTPUT.PUT_LINE('' ); IF (num_instances > 1) THEN DBMS_OUTPUT.PUT_LINE('' ); END IF; DBMS_OUTPUT.PUT_LINE('

| Estimates based on ' || ROUND(snapshot_interval/60) || ' minute snapshot intervals |
| AWR size/day | ' || TO_CHAR(awr_average_size, mb_format) || ' MB | (' || TRIM(TO_CHAR(snap_size1024, kb_format)) || ' K/snap ' || ROUND(86400/snapshot_interval) || ' snaps/day) |
| AWR size/wk | ' || TO_CHAR(awr_average_size 7, mb_format) || ' MB | (size_per_day 7) per instance |
| AWR size/wk | ' || TO_CHAR(awr_average_size 7 num_instances, mb_format) || ' MB | (size_per_day * 7) per database |
| Estimates based on ' || ROUND(today_snaps) || ' snaps in past 24 hours |
| AWR size/day | ' || TO_CHAR(awr_size_past24, mb_format) || ' MB | (' || TRIM(TO_CHAR(snap_size1024, kb_format)) || ' K/snap and ' || ROUND(today_snaps) || ' snaps in past ' || ROUND(least(num_days24, 24), 1) || ' hours) |
| AWR size/wk | ' || TO_CHAR(awr_size_past24 7, mb_format) || ' MB | (size_per_day 7) per instance |
| AWR size/wk | ' || TO_CHAR(awr_size_past24 7 num_instances, mb_format) || ' MB | (size_per_day * 7) per database

|
|
|

Results

Copyright (c) 2015-2020 UNIX Health Check - All Rights Reserved

xiongph@inspur.com -20200714-v33