Oracle EXADATA健康检查指南
OracleExada特性简介及应用指南
2012年8月1 前言............................... 错误!未指定书签。
一Exadata概述....................... 错误!未指定书签。
1Exadata简介....................... 错误!未指定书签。
2Exadata的配置及性能参数 ........... 错误!未指定书签。
二Exadata特性....................... 错误!未指定书签。
1SmartScan（智能扫描）.............. 错误!未指定书签。
2StorageIndex（存储索引）........... 错误!未指定书签。
3FlashCache（智能闪存）............. 错误!未指定书签。
4Compression（压缩）&EHCC（ExadataHybridColumnarCompression）错误!未指定书签。
5IORM（IO资源管理） ................ 错误!未指定书签。
三Exadata监控....................... 错误!未指定书签。
1Exadata特性监控常用指标 ........... 错误!未指定书签。
2如何查看指标....................... 错误!未指定书签。
四如何应用Exadata................... 错误!未指定书签。
1Exadata参数调整................... 错误!未指定书签。
2在Exadata上开发注意事项........... 错误!未指定书签。
3应用总结........................... 错误!未指定书签。
4Exadata总体总结................... 错误!未指定书签。
1前言1.1本文背景前期东软-甲骨文公司组织了一次针对社保系统的Exadata联合应用测试，本文内容是本次Exadata测试的经验总结，其中包含了与Oracle技术人员交流经验应用、Oracle相关技术文档应用及个人测试经验总结。
ORACLE_健康检查脚本
Rem chk_health.sqlRem 1.0Rem by Pond KaRemRem usage: sqlplus system/password_of_system@connect_string @chk_health.sql Rem only for single instance databaseRem not suitable for RACRem only tested under 9.2.0RemRemRem This script do health check .Rem Must run under system or user has dba privilege.Remset pages 0set lines 1000set trimspool onset head offset feedback offset echo offset verify offRem get report name based on database name and report dateRemcol logname noprint new_value log_nameselect lower(name)||to_char(sysdate,'yyyymmddhh24mi')||'.txt' lognamefrom v$database;spool &log_nameRemRem report headerRempromptselect 'Report produced at '||to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss') from dual;promptprompt Basic information:prompt --------------------------------------------------------------------------------RemRem Check database informationset head onset pages 45col dbid heading "Database|ID" format a11col name heading "Database|Name"col open_mode heading "Open |Mode"col force_logging heading "Force|Logging" format a7selectto_char(dbid,9999999999) dbid, name, open_mode, force_loggingfrom v$database;RemRem Check instance informationRemcol instance_name heading "Instance|Name" format a10col host_name heading "Host|Name" format a10col status heading "Instance|Status" format a8col archiver heading "Archiver|Status" format a8col up_time heading "Running Time" format a30selecthost_name, instance_name, status, archiver, trunc(sysdate - startup_time) || ' Days '|| trunc(mod(sysdate-startup_time, 1) *24) || ' Hours '|| trunc(mod((sysdate-startup_time)*24,1)*60) || ' Minutes 'up_timefrom v$instance;promptpromptprompt Check hit ratioprompt These value expected higher than 90%prompt --------------------------------------------------------------------------------RemRem Check buffer cache hit ratiocol pr heading "Physical|Reads" format 999,999,999col prd heading "Phy_Reads|Direct" format 999,999,999col prl heading "Phy_Reads|Direct_LOB" format 999,999,999col bg heading "Block|Gets" format 999,999,999,999col cg heading "Consistent|Gets" format 999,999,999,999col ht heading "Buffer|Hit Ratio"selectto_char((1-((pr - prd - prl) / (bg + cg - prd - prl))) * 100, '999.9')||'%' ht, bg, cg, pr, prd, prlfrom(select value pr from v$sysstat where name = 'physical reads') pr, (select value prd from v$sysstat where name = 'physical reads direct') prd, (select value prl from v$sysstat where name = 'physical reads direct (lob)') prl , (select value bg from v$sysstat where name = 'db block gets') bg, (select value cg from v$sysstat where name = 'consistent gets') cg;RemRem check library hit ratioRemcol ht heading "Libray|Hit Ratio" format a10selectto_char(sum(pinhits) / sum(pins) * 100, 999.9)||'%' htfrom v$librarycache;promptprompt Check session informationsprompt --------------------------------------------------------------------------------RemRem Check session high water markRemcol sessions_current heading "Sessions|Current" format 999,999,999col sessions_highwater heading "Sessions|High Water" format 999,999,999selectsessions_current, sessions_highwaterfrom v$license;RemRem Check session wait eventsRemcol username heading "User Name" format a15col program heading "Program" format a35col event heading "Wait Event" format a25promptprompt Session wait events, excluding waiting for user's message prompt _________________selectername, s.program, sw.eventfromv$session_wait sw, v$session swheresw.sid = s.sidand ername is not nulland event not in ('SQL*Net message from client');RemRem Check session statusRemcol status heading "Session|Status"col nu heading "Number|of Sessions"compute sum of nu on reportbreak on reportpromptprompt Session statusprompt -----------------selectstatus, count(*) nufrom v$sessionwhere username is not nullgroup by status;clear break;RemRem detail information for sessions which idle for more than 4 hours Remcol lc heading "Idle Time|(Hours)" format a8col username format a10 heading "Database|Username"col machine format a17 heading "Machine"col osuser format a10 heading "OS|Username"col prg format a35 heading "Program"promptprompt Idle sessionsprompt -----------------selectusername, machine, osuser, program prg, to_char(trunc(last_call_et/3600, 1), 99999.9) lcfrom v$sessionwhere last_call_et > 14400and username is not nullorder by last_call_et desc;promptprompt Redo log files informationprompt --------------------------------------------------------------------------------RemRem Online redo logfile informationRemcol grp format 99 heading "Log Group|Number"col bytes format 999,999.99 heading "Bytes|(M)"col status heading "Status"col member heading "Log File|Members" format a45break on grp on bytes on status skip 1promptprompt Online redo log fileprompt -----------------selectl.group# grp, l.bytes/1024/1024 bytes, l.status, lf.memberfrom v$log l, v$logfile lfwhere l.group# = lf.group#order by 1;clear break;RemRem Online redo logfile switch frequencyRemcol dt heading "Begin Time (1 hour)" format a25col cnt heading "Switch times" format 999promptprompt Switch frequencyprompt -----------------selectto_char(trunc(first_time, 'hh'), 'yyyy-mm-dd hh24:mi') dt, count(*) cntfromv$loghistwhere first_time > sysdate - 30group by trunc(first_time,'hh')order by 1;RemRem Space usage checkRempromptprompt Tablespace usageprompt --------------------------------------------------------------------------------col tbsn heading "Tablespace|Name" format a20col bytes heading "Current|Size(M)" format 999,999.99col max_b heading "Maximum|Size(M)" format 999,999.99col fre_b heading "Free Space|Size(M)" format 999,999.99col usg heading "Free Space|persentage" format a10col em heading "Extent|Management" format a10col ssm heading "Segment|Management" format a10selecttb.tbsn, bytes, fre_b, lpad(to_char(nvl(fre_b,0)/bytes*100, 999.99)||'%',10) usg, max_bfrom(select tablespace_name tbsn, sum(bytes)/1024/1024 bytes, sum( decode(AUTOEXTENSIBLE,'YES', greatest(bytes, maxbytes),bytes))/1024/1024 max_bfrom dba_data_filesgroup by tablespace_name) tb,(select tablespace_name tbsn, sum(bytes)/1024/1024 fre_bfrom dba_free_spacegroup by tablespace_name) frewhere tb.tbsn = fre.tbsn (+)order by 4;promptprompt Table usageprompt -----------------set serveroutput onexec dbms_output.enable(100000000);declaretype seg is record (seg_owner dba_segments.owner%type,seg_namedba_segments.segment_name%type,par_name d ba_segments.PARTITION_NAME%type,seg_type dba_segments.segment_type%type,tbs_name dba_segments.TABLESPACE_NAME%type);type usg is record (t_bck number,t_byt number,u_bck number,u_byt number,luefi number,luebi number,lub number);v_seg seg;v_usg usg;v_tbsname dba_tablespaces.tablespace_name%type;v_tbsseg dba_tablespaces.SEGMENT_SPACE_MANAGEMENT%type; cursor c_tbs isselecttablespace_name, SEGMENT_SPACE_MANAGEMENTfromdba_tablespaceswhereCONTENTS = 'PERMANENT'order by 1;cursor c_seg isselectowner, segment_name, PARTITION_NAME, segment_typefromdba_segmentswhereowner not in ('SYS', 'SYSTEM', 'OUTLN', 'DBSNMP', 'WMSYS')and tablespace_name = v_tbsnameorder by 1, 2, 3;beginopen c_tbs;fetch c_tbs into v_tbsname, v_tbsseg;while c_tbs%found loopdbms_output.put_line('~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~');dbms_output.put_line('Tablespace: '||v_tbsname);dbms_output.put_line (rpad('Owner',15)||rpad('Segment Name', 30)||rpad('Par', 8)||rpad('Seg Type', 10)||rpad('Bytes(K)',10)||'Used(K)');dbms_output.put_line (rpad('-',14, '-')||' '||rpad('-',29, '-')||' '||rpad('-',7, '-')||' '||rpad('-', 9, '-')||' '||rpad('-',9, '-')||' '||' ------------');open c_seg;fetch c_seg into v_seg.seg_owner, v_seg.seg_name, v_seg.par_name, v_seg.seg_type;while c_seg%found loopif v_seg.seg_type in ('TABLE', 'TABLE PARTITION', 'TABLE SUBPARTITION','INDEX', 'INDEX PARTITION', 'INDEX SUBPARTITION', 'CLUSTER','LOB') thendbms_space.unused_space (v_seg.seg_owner, v_seg.seg_name, v_seg.seg_type, v_usg.t_bck, v_usg.t_byt, v_usg.u_bck, v_usg.u_byt, v_usg.luefi, v_usg.luebi, v_usg.lub, v_seg.par_name);dbms_output.put_line(rpad(v_seg.seg_owner,15)||rpad(v_seg.seg_name, 30)||rpad(substr(nvl(v_seg.par_name,'NULL'),1,7), 8)||rpad(substr(v_seg.seg_type, 1, 9), 10)||to_char(v_usg.t_byt/1024, '9,999,999')||to_char((v_usg.t_byt-v_usg.u_byt)/1024, '9,999,999'));end if;fetch c_seg into v_seg.seg_owner, v_seg.seg_name, v_seg.par_name, v_seg.seg_type;end loop;close c_seg;fetch c_tbs into v_tbsname, v_tbsseg;end loop;close c_tbs;end;/spool off;exit;。
exadata_exachk健康检查
这里简单介绍一下基本的操作和步骤:1. 把指令文件exachk.zip上传到一个数据库服务器节点上推荐路径/opt/oracle.SupportTools/exachk2. Unzip 解压exachk.zip3. 推荐使用root用户去执行exachk (可以考虑使用VNC避免网络中断)<从12.1.0.2.2版本起, Oracle推荐使用root去执行exachk>执行exachk的时候，会有一些提示信息需要输入Yes or No，确认您是否从系统收集数据，并给你一些选项，同时需要输入密码(exachk是不会保存密码文件到操作系统)，然后脚本开始工作，收集原始数据并在最后进行分析。
原数据和分析结果会被存放在以日期为结构的目录中。
详情请参考文档文件里的Exachk的使用手册。
Exachk有个watchdog进程，负责监控exachk的执行状态，它会设定一个默认的“超时”值，以防止exachkhung住。
在一个繁忙的系统中，如果在默认的时间内没有响应的话，检查将会被终止。
通过设置一些环境变量，可以延长默认的“超时”值。
（RAT_TIMEOUT 和RAT_ROOT_TIMEOUT）接下来我们看下执行exachk的过程：$ ./exachkCRS stack isrunning and CRS_HOME is not set. Do you want to set CRS_HOME to/u01/app/11.2.0/grid?[y/n][y]Exachk可以自己通过查询系统文件，来判断gridhome，如果路径正确，你可以输入“Y”来设定CRS_HOME，如果不正确，需要输入“N”然后手动设置正确的路径。
Checking ssh userequivalency settings on all nodes in clusterNode randomdb02 isconfigured for ssh user equivalency for oracle userExachk会验证ssh等价性是否可用，如果没有配置ssh等价性，它会需要你输入密码，并临时配置等价性。
Oracle-EXADATA健康检查指南
0.作业概述
运行EXADATA Database Machine HealthCheck，检查软件、硬件、固件版本、配置等，生成健康检查报告。
1.作业对象
EXADATA Database Machine上的软件、硬件、固件版本、配置等。
2.作业前确认事项
3.作业具体操作步骤
3.1.下载最新软件
登录ORACLE SUPPORT网站： ，找到并打开ID为1070954.1的文章，下载最新的HealthCheck软件。
3.2.安装并做健康检查
1）将exachk.zip上传到一台数据库服务器上，如：hdexdb01；
2）以“oracle”用户登录数据库服务器，并执行：
•$ unzip exachk.zip
•$ chmod +x exachk
3）查看readme.txt 和UserGuide：
4）运行Exachk工具（必须以“oracle”用户执行）
•$./exachk
5）确认clusterware home (CRS_HOME)
6）检查数据库服务器上的SSH设置是否正确
7）选择要检查的数据库
8）软件环境检查结果显示
9）输入Storage Server 上root的密码
10）输入Database Server 上root的密码
11）输入Infiniband switch上root的密码
12）收集database server, storage server 和infiniband switche上的配置信息
13）分析系统状况
14）检查结果输出到文件
15）查看结果并处理错误
---手册完---。
oracle数据库巡检报告标准
Oracle Health-Check Report Oracle数据库健康巡检报告XX公司xx数据库系统健康巡检报告作者:文档创建日期: 2010-12-1上次修改日期:服务工程师:服务类型：现场客户联系人:目录健康检查记录 (3)数据库调整记录 (3)一、系统概况 (4)二、数据库趋势分析 (4)1、数据缓冲区和库缓冲区命中率趋势 (4)2、数据量变化趋势 (5)三、健康检查项目列表及结果 (5)1、操作系统 (5)1.1磁盘空间 (5)1.2系统性能信息 (8)2、数据库系统 (9)2.1安全性 (9)2.2稳定性 (9)2.3数据库性能 (9)3、健康检查 (11)3.1数据库版本信息 (11)3.2目前数据库参数 (11)3.3数据库资源限制 (12)3.4控制文件 (12)3.5日志文件 (13)3.6数据文件 (13)3.7临时文件 (13)3.8表空间使用率监控 (13)3.9无效索引 (14)四、巡检总结与调整建议 (14)1、巡检总结： (14)2、调整建议： (14)3、对管理人员的提醒： (14)前次巡检记录巡检日期市民卡公司工程师联创工程师本次巡检记录巡检日期市民卡公司工程师联创工程师数据库调整记录自上次巡检以来对本数据库调整记录如下：1)调整一2)调整二3)调整三一、系统概况项目值业务名称主机名硬件平台CPU物理内存操作系统数据库软件版本数据库名归档模式Blocksize数据库核心字符集控制文件镜像份数控制文件镜像是否在不同目录联机日志组数联机日志每组member数联机日志每组成员是否在不同磁盘每组日志大小时日志切换高峰注:天日志生成量高峰、时日志切换高峰:这里的高峰指的是redo生成高峰，非业务高峰。
全库export大小的计算方法是:统计全库中表的大小,这种方式计算出的表的大小包含了空的行记录,而export实际导出时不会导出空数据行,所以这里的export大小会大于实际的导出dmp文件的大小,具体误差多少取决与数据库中存在多少的空数据行(delete操作产生的空数据行).全库rman备份大小(10.2.0.1)的计算方法是:统计全库中所有对象的大小.而rman备份集是备份所有曾经被对象暂用过的空间,所以此种统计方法统计的数据和rman备份实际的大小的差异在很大程度上取决于被放入回收站对象的多少.二、数据库趋势分析1、数据缓冲区和库缓冲区命中率趋势[数据来源典型业务高峰时段statspack or awr]Buffer Nowait %: 100 Redo NoWait %: 100Buffer Hit %: 82 In-memory Sort %: 100Library Hit %: 99 Soft Parse %: 99Execute to Parse %: 65 Latch Hit %: 100123.4 % Non-Parse CPU: 99.4Parse CPU to ParseElapsd %:建议:数据库性能2、数据量变化趋势[]dmp全备份估计大小(G) RMAN全备份估计大小(G) 数据文件容量(G)81 137 348 建议:三、健康检查项目列表及结果1、操作系统[操作系统命令df-k 和prstat,top,topas,glance,sar输出]1.1磁盘空间[数据来源df -k]对操作系统的磁盘空间进行检查，是否有足够空间。
Oracle 一体机管理手册(Exadata_admin)
•
• • •
dcli
In parallel executes OS commands or scripts on multiple nodes Requires SSH -k option automates distribution of SSH private keys into authorized_keys file
17
© 2011 Oracle Corporation – Proprietary and Confidential
DCLI Usage Examples
$ dcli -g mycells stsd2s1: GridDisk stsd2s1: GridDisk stsd2s1: GridDisk stsd2s1: GridDisk stsd2s1: GridDisk ... $ dcli -g mycells stsd2s1: GridDisk stsd2s1: GridDisk stsd2s1: GridDisk stsd2s1: GridDisk ... $ dcli -g mycells stsd2s1: IORMPLAN stsd2s2: IORMPLAN stsd2s3: IORMPLAN cellcli -e create data_CD_2_stsd2s1 data_CD_3_stsd2s1 data_CD_4_stsd2s1 data_CD_5_stsd2s1 data_CD_6_stsd2s1 griddisk all successfully successfully successfully successfully successfully prefix="data", size=120G created created created created created
oracle数据库系统健康检查及优化
［ ９ ］ 谷 小秋 ， 李德 昌． 索引 调整 优 化 Ｏ ｒ ａ ｃ ｌ ｅ １ １ Ｇ工 作 性 能 的研 究 ［ Ｊ ］ ． 计 算机工程与应用， ２ Ｏ １ ０ （ ２ ６ ） ： ２ ５ — ２ ６ ． ［ １ ０ ］ 童 有奎 ． 浅谈 Ｏ Ｒ Ａ Ｃ Ｌ Ｅ数据 库 系统 性 能优 化 方 案 ［ Ｊ ］ ． 上 海 铁道 科 技， ２ ０ １ ２ ， ０ （ ３ ） ： ４ ５ — ４ ６ ． ［ １ １ ］ 刘 占江， 王志超 ． 关于 Ｏ ｒ ａ ｃ ｌ ｅ数据 库 Ｓ Ｑ Ｌ 优化系统 的研 究［ Ｊ ］ ． 信 息安全 与技术， ２ ０ １ ４ ， ０ （ ５ ） ： ６ １ — ６ ２ ． ［ １ ２ ］ 宋慧艳． Ｏ ｒ ａ ｃ ｌ ｅ 数据库统计应用 的结构设计与维护技巧［ Ｊ ］ ． 科技 传播。 ２ ０ １ ４ ， Ｏ （ ３ ） ： １ ９ ９ ． ［ １ ３ ］ 袁 勇． Ｏ ｒ ａ ｃ ｌ ｅ 数据库大对象数据存取 的两种实现方法及时间性 能比较［ Ｊ ］ ． 佳木斯大学学报（ 自然科学版） ， ２ ０ ｌ ４ ， ０ （ ０ １ ） ： １ １ ６ —１ １ ８ ． ［ １ ４ ］ 柴康． Ｏ Ｒ Ａ Ｃ Ｌ Ｅ数据库 的体系结构、安全 和优化［ Ｊ ］ ． 电子制作，
２ ０１ １ ． ９ ： ６１ —６ ５ ．
２． ２． ４ Ｓ ｑ １ 分析 与优 化
通过ａ ｗｒ ｓ ｑ ｒ ｐ ｔ ． ９ ｑ １ 脚本， ａ ｗｒ ｆ ￣够生成 曾经执行过的Ｓ Ｑ Ｌ 的执行 计划 ， 查看消耗的资源等等信息， 有助于Ｄ Ｂ 对ｓ Ｑ Ｌ 调 优。 从ａ ｗ Ｔ 报告中我们找出最耗资源的几条Ｓ ｑ 】 语句， 查看它们的执行计划 ， 然后 进行优化。 比如 我们从图１ 的执行计划中发现 了全表扫描 ， 因此我们 建议在 Ｌ ｃ ＿ ｂ ａ ｔ ｃ ｈ — ｍｄ — ｉ ｎ ｆ ｏ 表 需 要 由ｅ ｑ ｕ ｉ ｐ ｘ ｃ ａ ｔ ｅ ｇ、 ａ ｒ ｒ ｉ ｖ ｅ — ｄ ａ ｔ ｅ 、 ｄ ｅ ｖ ｉ ｃ ｅｓ ｐ ｅ ｃ ￣建组合索引 。 通过创建索引， 我们将全表扫描 转变成索 引扫描 。 索引扫描分 为２ 步骤 ， 首先扫描索 引得到相应记录的ｒ ｏ ｗｉ ｄ 值， 然后通过ｒ ｏ ｗｉ ｄ 从表 中读 出所要的数据 。 每步都是单独的一次Ｉ ／ Ｏ， 但是对于索 引， 由于经常使用 ， 绝大多数都 已经Ｃ ＡＣ ＨＥ 到 内存 中， 所 以第ｌ 步的Ｉ ／ Ｏ 经常是逻辑Ｉ ／ ０， 即数据可 以从 内存中得到 。 但 是对于第２ 步来说 ， 如果表 比较大 ， 则其数据 不可能全在 内存 中， 所 以 其Ｉ ／ Ｏ 很有可能是物理Ｉ ／ ０， 这是一个机械操作， 相对逻辑Ｉ ／ Ｏ 来说 ， 是极其费时间的。 所 以如果多大表进行索引扫描 ， 取 出的数据如果大 于总量的５ ％～１ Ｏ ％， 使用索引扫描会效率下降很多 。
oracle 11g R2 RAC健康检查报告
oracle 11g R2 RAC健康检查1.检查集群状态[grid@rac1 ~]$ iduid=501(grid) gid=501(oinstall) groups=501(oinstall),504(asmadmin),506(asmdba),507(asmoper) [grid@rac1 ~]$ crsctl check clusterCRS-4537: Cluster Ready Services is onlineCRS-4529: Cluster Synchronization Services is onlineCRS-4533: Event Manager is online[grid@rac1 ~]$2.检查rac下实例的状态[grid@rac1 ~]$ srvctl config database1.检查集群状态[grid@rac1 ~]$ iduid=501(grid) gid=501(oinstall) groups=501(oinstall),504(asmadmin),506(asmdba),507(asmoper) [grid@rac1 ~]$ crsctl check clusterCRS-4537: Cluster Ready Services is onlineCRS-4529: Cluster Synchronization Services is onlineCRS-4533: Event Manager is online[grid@rac1 ~]$2.检查rac下实例的状态[grid@rac1 ~]$ srvctl config databaseorcl[grid@rac1 ~]$ srvctl status database -d orclInstance orcl1 is running on node rac1Instance orcl2 is running on node rac2[grid@rac1 ~]$3.检查rac下某个实例状态[grid@rac1 ~]$ srvctl status instance -d orcl -i orcl1Instance orcl1 is running on node rac1[grid@rac1 ~]$ srvctl status instance -d orcl -i orcl2Instance orcl2 is running on node rac2[grid@rac1 ~]$4.检查rac各个节点应用程序状态（vip,network,gsd,ons,eons）[grid@rac1 ~]$ srvctl status nodeappsVIP rac1-vip is enabledVIP rac1-vip is running on node: rac1VIP rac2-vip is enabledVIP rac2-vip is running on node: rac2Network is enabledNetwork is running on node: rac1Network is running on node: rac2GSD is enabledGSD is running on node: rac1GSD is running on node: rac2ONS is enabledONS daemon is running on node: rac1ONS daemon is running on node: rac2eONS is enabledeONS daemon is running on node: rac1eONS daemon is running on node: rac2[grid@rac1 ~]$5.检查rac下的数据库配置[grid@rac1 ~]$ srvctl config database -d orcl -a Database unique name: orclDatabase name: orclOracle home: /u01/app/oracle/product/11.2.0/db_1 Oracle user: oracleSpfile: +DATA/orcl/spfileorcl.oraDomain:Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: orclDatabase instances: orcl1,orcl2Disk Groups: DATA,BACKServices:Database is enabledDatabase is administrator managed[grid@rac1 ~]$6.检查rac下的ASM状态以及ASM配置[grid@rac1 ~]$ srvctl status asmASM is running on rac1,rac2[grid@rac1 ~]$ srvctl status asm -aASM is running on rac1,rac2ASM is enabled.[grid@rac1 ~]$ srvctl config asm -aASM home: /u01/app/grid/11.2.0/gridASM listener: LISTENERASM is enabled.[grid@rac1 ~]$7.检查rac下的TNS监听器状态以及配置[grid@rac1 ~]$ srvctl status listenerListener LISTENER is enabledListener LISTENER is running on node(s): rac1,rac2 [grid@rac1 ~]$ srvctl config listener -aName: LISTENERNetwork: 1, Owner: gridHome: <CRS home>/u01/app/grid/11.2.0/grid on node(s) rac2,rac1End points: TCP:1521[grid@rac1 ~]$8.检查rac下的SCAN状态以及配置[grid@rac1 ~]$ srvctl status scanSCAN VIP scan1 is enabledSCAN VIP scan1 is running on node rac1[grid@rac1 ~]$ srvctl config scanSCAN name: rac-cluster-scan, Network: 1/192.9.100.0/255.255.255.0/eth0 SCAN VIP name: scan1, IP: /rac-cluster-scan/192.9.100.36[grid@rac1 ~]$#SCAN192.9.100.36 rac-cluster-scan9.检查rac下的VIP各个节点的状态以及配置[grid@rac1 ~]$ srvctl status vip -n rac1VIP rac1-vip is enabledVIP rac1-vip is running on node: rac1[grid@rac1 ~]$ srvctl status vip -n rac2VIP rac2-vip is enabledVIP rac2-vip is running on node: rac2[grid@rac1 ~]$ srvctl config vip -n rac1VIP exists.:rac1VIP exists.: /rac1-vip/192.9.100.33/255.255.255.0/eth0[grid@rac1 ~]$ srvctl config vip -n rac2VIP exists.:rac2VIP exists.: /rac2-vip/192.9.100.35/255.255.255.0/eth0[grid@rac1 ~]$#VIP192.9.100.33 rac1-vip192.9.100.35 rac2-vip10.检查rac下各个节点应用程序配置情况 (VIP、GSD、ONS、监听器）[grid@rac1 ~]$ srvctl config nodeapps -a -g -s -l-l option has been deprecated and will be ignored.VIP exists.:rac1VIP exists.: /rac1-vip/192.9.100.33/255.255.255.0/eth0VIP exists.:rac2VIP exists.: /rac2-vip/192.9.100.35/255.255.255.0/eth0GSD exists.ONS daemon exists. Local port 6100, remote port 6200Name: LISTENERNetwork: 1, Owner: gridHome: <CRS home>/u01/app/grid/11.2.0/grid on node(s) rac2,rac1End points: TCP:152111.检查rac下的各个节点间的时钟同步情况[grid@rac1 ~]$ cluvfy comp clocksync -verboseVerifying Clock Synchronization across the cluster nodesChecking if Clusterware is installed on all nodes...Check of Clusterware install passedChecking if CTSS Resource is running on all nodes...Check: CTSS Resource running on all nodesNode N ame Status------------------------------------ ------------------------rac1 passedResult: CTSS resource check passedQuerying CTSS for time offset on all nodes...Result: Query of CTSS for time offset passedCheck CTSS state started...Check: CTSS stateNode N ame State------------------------------------ ------------------------rac1 ObserverCTSS is in Observer state. Switching over to clock synchronization checks using NTP Starting Clock synchronization checks using Network Time Protocol(NTP)...NTP Configuration file check started...The NTP configuration file "/etc/ntp.conf" is available on all nodesNTP Configuration file check passedChecking daemon liveness...Check: Liveness for "ntpd"Node N ame Running?------------------------------------ ------------------------rac1 yesResult: Liveness check passed for "ntpd"Checking NTP daemon command line for slewing option "-x"Check: NTP daemon command lineNode N ame Slewing O ption S et?------------------------------------ ------------------------rac1 yesResult:NTP daemon slewing option check passedChecking NTP daemon's boot time configuration, in file "/etc/sysconfig/ntpd", for slewing option "-x"Check: NTP daemon's boot time configurationNode N ame Slewing O ption S et?------------------------------------ ------------------------rac1 yesResult:NTP daemon's boot time configuration check for slewing option passedNTP common Time Server Check started...PRVF-5410 : Check of common NTP Time Server failedPRVF-5416 : Query of NTP daemon failed on all nodesResult: Clock synchronization check using Network Time Protocol(NTP) passedOracle Cluster Time Synchronization Services check passedVerification of Clock Synchronization across the cluster nodes was successful.[grid@rac1 ~]$12.检查rac下的所有正在运行的实例情况col status for a15;col database_status for a15;col instance_name for a15;col host_name for a15;col active_state for a15;SQL> set linesize 200;SQL> select instance_number, instance_name, parallel , status , database_status, active_state, host_name from gv$instance order by instance_number;INSTANCE_NUMBER INSTANCE_NAME PARALLEL STATUS DATABASE_STATUS ACTIVE_STATE HOST_NAME--------------- --------------- --------- --------------- --------------- --------------- ---------------1o rcl1YES OPEN ACTIVE NORMAL rac12o rcl2YES OPEN ACTIVE NORMAL rac2SQL> select * from v$active_instances;INST_NUMBER INST_NAME----------- --------------------------------------------------------------------1r ac1:orcl12r ac2:orcl213.检查数据文件及它们所在的 ASM磁盘组select name from v$datafileunionselect member from v$logfileunionselect name from v$controlfileunionselect name from v$tempfile;SQL> select name from v$datafile2 union3 select member from v$logfile4 union5 select name from v$controlfile6 union7 select name from v$tempfile;NAME--------------------------------------------------------------------------------+BACK/orcl/controlfile/current.299.768402009+BACK/orcl/onlinelog/group_1.298.768402013+BACK/orcl/onlinelog/group_2.297.768402015+BACK/orcl/onlinelog/group_3.296.768402261+BACK/orcl/onlinelog/group_4.295.768402263+DATA/orcl/controlfile/current.280.768402009+DATA/orcl/datafile/example.385.768402021........+DATA/orcl/tempfile/sms_db_temp.400.768403227+DATA/orcl/tempfile/temp.386.76840201914.检查ASM磁盘情况QL> select path from v$asm_disk;PATH--------------------------------------------------------------------------------/dev/oracleasm/disks/BACK_VOL1/dev/oracleasm/disks/DATA_VOL1/dev/oracleasm/disks/OCR_VOL3/dev/oracleasm/disks/OCR_VOL2/dev/oracleasm/disks/OCR_VOL1SQL> col path for a50;SQL> select path,disk_number,name from v$asm_disk;PATH DISK_NUMBER N AME-------------------------------------------------- ----------- -----------------/dev/oracleasm/disks/BACK_VOL10B ACK_0000/dev/oracleasm/disks/DATA_VOL10D ATA_0000/dev/oracleasm/disks/OCR_VOL32O CR_0002/dev/oracleasm/disks/OCR_VOL21O CR_0001/dev/oracleasm/disks/OCR_VOL10O CR_0000SQL> select group_number,name,offline_disks from v$asm_diskgroup;GROUP_NUMBER N AME OFFLINE_DISKS------------ ------------------------------ -------------1O CR02D ATA03B ACK0SQL> select group_number,name,total_mb,free_mb from v$asm_diskgroup;GROUP_NUMBER N AME TOTAL_MB FREE_MB------------ ------------------------------ ---------- ----------1O CR2859 19332D ATA568739 5568103B ACK571600 508953SQL>SQL> SELECT AS diskgroup, , t.stripe, t.redundancy, t.primary_region, t.mirror_region2 FROM V$ASM_DISKGROUP dg, V$ASM_TEMPLATE t3 WHERE dg.group_number = t.group_number ORDER BY ;rows will be truncatedDISKGROUP NAME STRIPE R EDUND PRIM------------------------------ ------------------------------ ------ ------ ----OCR ARCHIVELOG COARSE M IRROR COLDBACK ARCHIVELOG COARSE U NPROT COLDDATA ARCHIVELOG COARSE U NPROT COLDBACK ASMPARAMETERBAKFILE COARSE U NPROT COLDOCR ASMPARAMETERBAKFILE COARSE M IRROR COLDDATA ASMPARAMETERBAKFILE COARSE U NPROT COLDOCR ASMPARAMETERFILE COARSE M IRROR COLDBACK ASMPARAMETERFILE COARSE U NPROT COLDDATA ASMPARAMETERFILE COARSE U NPROT COLDOCR ASM_STALE COARSE H IGH COLDBACK ASM_STALE COARSE U NPROT COLDDISKGROUP NAME STRIPE R EDUND PRIM------------------------------ ------------------------------ ------ ------ ----DATA ASM_STALE COARSE U NPROT COLDOCR AUTOBACKUP COARSE M IRROR COLDDATA AUTOBACKUP COARSE U NPROT COLDBACK AUTOBACKUP COARSE U NPROT COLDBACK BACKUPSET COARSE U NPROT COLDOCR BACKUPSET COARSE M IRROR COLDDATA BACKUPSET COARSE U NPROT COLDOCR CHANGETRACKING COARSE M IRROR COLDBACK CHANGETRACKING COARSE U NPROT COLDDATA CHANGETRACKING COARSE U NPROT COLDBACK CONTROLFILE FINE UNPROT COLDDISKGROUP NAME STRIPE R EDUND PRIM------------------------------ ------------------------------ ------ ------ ----OCR CONTROLFILE FINE HIGH COLDDATA CONTROLFILE FINE UNPROT COLDBACK DATAFILE COARSE U NPROT COLDDATA DATAFILE COARSE U NPROT COLDOCR DATAFILE COARSE M IRROR COLDBACK DATAGUARDCONFIG COARSE U NPROT COLDOCR DATAGUARDCONFIG COARSE M IRROR COLDDATA DATAGUARDCONFIG COARSE U NPROT COLDOCR DUMPSET COARSE M IRROR COLDBACK DUMPSET COARSE U NPROT COLDDATA DUMPSET COARSE U NPROT COLDDISKGROUP NAME STRIPE R EDUND PRIM------------------------------ ------------------------------ ------ ------ ----OCR FLASHBACK COARSE M IRROR COLDDATA FLASHBACK COARSE U NPROT COLDBACK FLASHBACK COARSE U NPROT COLDOCR FLASHFILE COARSE M IRROR COLDDATA FLASHFILE COARSE U NPROT COLDBACK FLASHFILE COARSE U NPROT COLDOCR OCRBACKUP COARSE M IRROR COLDBACK OCRBACKUP COARSE U NPROT COLDDATA OCRBACKUP COARSE U NPROT COLDBACK OCRFILE COARSE U NPROT COLDOCR OCRFILE COARSE M IRROR COLDDISKGROUP NAME STRIPE R EDUND PRIM------------------------------ ------------------------------ ------ ------ ----DATA OCRFILE COARSE U NPROT COLDOCR ONLINELOG COARSE M IRROR COLDBACK ONLINELOG COARSE U NPROT COLDDATA ONLINELOG COARSE U NPROT COLDBACK PARAMETERFILE COARSE U NPROT COLDOCR PARAMETERFILE COARSE M IRROR COLDDATA PARAMETERFILE COARSE U NPROT COLDOCR TEMPFILE COARSE M IRROR COLDDATA TEMPFILE COARSE U NPROT COLDBACK TEMPFILE COARSE U NPROT COLDOCR XTRANSPORT COARSE M IRROR COLDDISKGROUP NAME STRIPE R EDUND PRIM------------------------------ ------------------------------ ------ ------ ----DATA XTRANSPORT COARSE U NPROT COLDBACK XTRANSPORT COARSE U NPROT COLD57 rows selected.SQL> set linesize 300;SQL> select name, path, mode_status, state, disk_number from v$asm_disk;NAME PATH MODE_ST S TATE DISK_NUMBER------------------------------ -------------------------------------------------- ------- -------- -----------BACK_0000 /dev/oracleasm/disks/BACK_VOL1 ONLINE NORMAL 0DATA_0000 /dev/oracleasm/disks/DATA_VOL1 ONLINE NORMAL 0OCR_0002 /dev/oracleasm/disks/OCR_VOL3 ONLINE NORMAL 2OCR_0001 /dev/oracleasm/disks/OCR_VOL2 ONLINE NORMAL 1OCR_0000 /dev/oracleasm/disks/OCR_VOL1 ONLINE NORMAL 0SQL> select name, state from v$asm_diskgroup;NAME STATE------------------------------ -----------OCR MOUNTEDDATA MOUNTEDBACK MOUNTED15.检查rac状态[grid@rac1 ~]$ crs_stat -t -vName Type R/RA F/FT Target State Host----------------------------------------------------------------------ora.BACK.dg ora....up.type0/5 0/ ONLINE ONLINE rac1ora.DATA.dg ora....up.type0/5 0/ ONLINE ONLINE rac1ora....ER.lsnr o ra....er.type0/5 0/ONLINE ONLINE rac1ora....N1.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE rac1ora.OCR.dg ora....up.type0/5 0/ ONLINE ONLINE rac1ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE rac1ora.eons ora.eons.type 0/3 0/ ONLINE ONLINE rac1ora.gsd ora.gsd.type 0/5 0/ ONLINE ONLINE rac1work o ra....rk.type0/5 0/ONLINE ONLINE rac1ora.oc4j ora.oc4j.type 0/5 0/0 ONLINE ONLINE rac2ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE rac1 ora.orcl.db ora....se.type0/2 0/1 ONLINE ONLINE rac1 ora....SM1.asm a pplication 0/5 0/0 ONLINE ONLINE rac1 ora....C1.lsnr a pplication 0/5 0/0 ONLINE ONLINE rac1 ora.rac1.gsd application 0/5 0/0 ONLINE ONLINE rac1 ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1 ora.rac1.vip ora....t1.type0/0 0/0 ONLINE ONLINE rac1 ora....SM2.asm a pplication 0/5 0/0 ONLINE ONLINE rac2 ora....C2.lsnr a pplication 0/5 0/0 ONLINE ONLINE rac2 ora.rac2.gsd application 0/5 0/0 ONLINE ONLINE rac2 ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2 ora.rac2.vip ora....t1.type0/0 1/0 ONLINE ONLINE rac2 ora....ry.acfs o ra....fs.type0/5 0/ONLINE ONLINE rac1 ora.scan1.vip ora....ip.type0/0 0/0 ONLINE ONLINE rac1展开全文。
Oracle数据库健康检查及其评估
XXXXXXXXXXXXXXXXXXXXOracle数据库健康检查与评估XXXX巡检人：报告生成日期：yyyy-mm-dd文档控制此文档仅供江苏移动审阅，不得向与此无关的个人或机构传阅或复制。
修改记录分发者审阅记录相关文档目录1.检查介绍1.1检查系统系统主要包括1个数据库，具体情况如下：1.2检查范围本次检查仅限于数据库。
在这次检查中对数据库配置和数据库性能进行了分析。
本报告提供的检查和建议不涉及具体的安全分析和应用程序的具体细节。
以下提请注意：本次检查仅历时1天，其中还包括了提交分析报告的时间，所以在具体的应用程序性能方面并不加以深入。
以下列出系统主机的主要配置情况2.1主机配置建议：目前系统配置满足数据库要求，操作系统参数设置合理。
和数据库相关的操作系统配置将被检查，包括以下方面：●操作系统数据库相关要求补丁●存放oracle文件的硬盘区可用空间(oracle文件包括：数据文件，控制文件，在线redo logs，归档redo logs，运行情况文件和跟踪文件)。
●硬盘利用率。
●CPU利用率。
3.1操作系统数据库相关要求补丁建议：3.2硬盘可用空间硬盘可用情况如下示：数据库XXXX的硬盘使用率情况如下：Filesystem kbytes used avail %used Mounted on数据库YYYY的硬盘使用率情况如下：Filesystem kbytes used avail %used Mounted on建议：目前该数据库服务器中还没有其他硬盘空间使用率超过90%的分区。
如果有需要引起注意并且及时增加硬盘空间的容量。
3.3CPU 利用率CPU利用率的统计时间是：yyyy-mm-dd hh:mi---- yyyy-mm-dd hh:mi1.top / glance2.vmstat 2 20参考值：1.最大CPU使用率：60%--70%2.系统进程与用户进程占用CPU最大比率：40/60数据库XXXX:数据库YYYY:从上述的情况中看出，数据库:服务器CPU idle基本在75%以上，CPU资源较为空闲。
Oracle Exadata特性简介及应用指南
月 8年2012．1 前言 (3)一Exadata 概述 (4)1Exadata简介 (4)2Exadata的配置及性能参数 (4)二Exadata特性 (5)1Smart Scan（智能扫描） (5)2Storage Index（存储索引） (14)3Flash Cache（智能闪存） (24)4Compression（压缩） & EHCC（Exadata Hybrid Columnar Compression） 285IORM（IO资源管理） (34)三Exadata监控 (37)1Exadata特性监控常用指标 (37)2如何查看指标 (38)四如何应用Exadata (38)1Exadata参数调整 (38)2在Exadata上开发注意事项 (38)413 ................................................... 应用总结42........................................... 总体总结4. Exadata前言1本文背景1.1前期东软-甲骨文公司组织了一次针对社保系统的Exadata联合应用测试，本文内容是本次Exadata测试的经验总结，其中包含了与Oracle技术人员交流经验应用、Oracle相关技术文档应用及个人测试经验总结。
本文简介1.2本文是关于ORACLE Exadata的一些特性介绍和应用Exadata的一些指南；本文不会涉及太多传统ORACLE DataBase已经具有的而非Exadata专有的一些特性介绍。
通过本文，读者可以了解ORACLE推出 Exadata的目的和初衷，简单了解Exadata 架构体系，了解Exdata的一些设计思路，了解其特性及其原理；了解Exadata 的适合应用场景，不适合应用场景，以及在Exadata下开发的一些注意事项（尤其是做Exadata项目主要设计、开发人员一定要了解Exadata，不要把它完全当作传统ORACLE数据库）。
我的oracle健康检查报告
我的oracle健康检查报告最近⼀直想⽤sql来⽣成oracle的健康检查报告，这样看起来⼀⽬了然，经过⽹上搜资料加⾃⼰整理终于算是成型了，部分结果如下图所⽰，具体参考附件，恳请⼴⼤⽹友看看是否还有需要添加的地⽅。
ORADG11G 数据库巡检报告巡检时间：2015-08-26 16:05:39巡检⼈：lhr⽬录数据库巡检服务概要数据库总体概况基本信息巡检报告⽂件名称DB_healthcheck_by_lhr_ORADG11G_20150826160539.html巡检时间2015-08-26 (Wednesday) 16:05:39 PM 时区 +08:00数据库服务器名称rhel6_lhr数据库服务器IP地址192.168.59.130数据库名称ORADG11G数据库ID(DBID)1403587593数据库全局名ORADG11G操作系统信息Linux x86 64-bit / 13是否RAC集群模式?FALSERAC实例数⽬1数据库创建时间2015-04-03 15:59:05实例启动时间实例1:2015-08-26 15:24:16数据库归档模式ARCHIVELOG数据库字符集ZHS16GBK●数据库系统版本信息数据库系统版本信息Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionPL/SQL Release 11.2.0.3.0 - ProductionCORE 11.2.0.3.0 ProductionTNS for Linux: Version 11.2.0.3.0 - ProductionNLSRTL Version 11.2.0.3.0 - Production●数据库实例状况数据库实例名称数据库实例号线程号主机名数据库版本实例启动时间运⾏时间(天)RAC模式实例状态是否可登录是否可归档oradg11g11rhel6_lhr11.2.0.3.02015-08-26 15:24:16.03NO OPEN ALLOWED STARTED●数据库概要INST_ID数据库名数据库ID 数据库UniqueName创建时间平台名称当前SCN⽇志模式打开模式是否强制⽇志是否Flashback?控制⽂件类型Last OpenIncarnationNumDATABASE_ROLE SUPPLEME SUP1ORADG11G1403587593oradg11g2015-04-0315:59:05Linuxx8664-bit2282303ARCHIVELOGREADWRITEYES YES CURRENT4PRIMARY IMPLICIT YES[]●数据库服务器主机的情况SNAP_ID DB_NAMEDBIDINSTANCE_NAME INSTANCE_NUMBER STARTUP_TIME RELEASE RAC HOST_NAME PLATFORM_NAME CPUS CORES SOCKETS Memory(GB)113ORADG11G 1403587593oradg11g 126-AUG-1503.24.24.000 PM 11.2.0.3.0NO rhel6_lhr Linux x86 64-bit 221112ORADG11G 1403587593oradg11g 123-AUG-1505.35.19.000 PM11.2.0.3.0NOrhel6_lhr Linux x86 64-bit 221111ORADG11G 1403587593oradg11g 123-AUG-1505.35.19.000 PM11.2.0.3.0NOrhel6_lhr Linux x86 64-bit 221110ORADG11G 1403587593oradg11g 123-AUG-1505.35.19.000 PM11.2.0.3.0NOrhel6_lhr Linux x86 64-bit 221109ORADG11G 1403587593oradg11g 123-AUG-1505.35.19.000 PM11.2.0.3.0NOrhel6_lhr Linux x86 64-bit 221108ORADG11G 1403587593oradg11g 123-AUG-1505.35.19.000 PM11.2.0.3.0NOrhel6_lhr Linux x86 64-bit 221107ORADG11G 1403587593oradg11g 123-AUG-1505.35.19.000 PM11.2.0.3.0NOrhel6_lhr Linux x86 64-bit 221106ORADG11G 1403587593oradg11g 123-AUG-1505.35.19.000 PM11.2.0.3.0NOrhel6_lhr Linux x86 64-bit 221105ORADG11G 1403587593oradg11g123-AUG-1505.35.19.000 PM11.2.0.3.0NOrhel6_lhrLinux x86 64-bit221[] []所有的初始化参数SPFILE UsageThis database IS using an SPFILE.Parameter NameInstance NameValueDISPLAY_VALUEIs Default?O7_DICTIONARY_ACCESSIBILITY oradg11g FALSE FALSE TRUE active_instance_count oradg11g TRUE aq_tm_processesoradg11g 11TRUEarchive_lag_target oradg11g 00TRUE asm_diskgroups oradg11g TRUE asm_diskstring oradg11g TRUE asm_power_limitoradg11g 11TRUE asm_preferred_read_failure_groups oradg11gTRUE audit_file_dest oradg11g /u01/app/oracle/admin/oradg11g/adump /u01/app/oracle/admin/oradg11g/adump FALSE audit_sys_operations oradg11g FALSE FALSE TRUE audit_syslog_level oradg11g TRUE audit_trailoradg11g DB DB FALSE awr_snapshot_time_offset oradg11g 00TRUE background_core_dump oradg11g partialpartialTRUE background_dump_dest oradg11g /u01/app/oracle/diag/rdbms/oradg11g/oradg11g/trace /u01/app/oracle/diag/rdbms/oradg11g/oradg11g/trace TRUE backup_tape_io_slaves oradg11g FALSE FALSE TRUE bitmap_merge_area_size oradg11g 10485761048576TRUE blank_trimming oradg11g FALSE FALSE TRUE buffer_pool_keeporadg11gTRUEbuffer_pool_recycle oradg11gTRUE cell_offload_compaction oradg11g ADAPTIVE ADAPTIVE TRUE cell_offload_decryption oradg11g TRUE TRUE TRUE cell_offload_parameters oradg11g TRUE cell_offload_plan_display oradg11g AUTO AUTO TRUE cell_offload_processingoradg11g TRUETRUETRUEcircuits oradg11g TRUE client_result_cache_lag oradg11g30003000TRUE client_result_cache_size oradg11g00TRUE clonedb oradg11g FALSE FALSE TRUE cluster_database oradg11g FALSE FALSE TRUE cluster_database_instances oradg11g11TRUE cluster_interconnects oradg11g TRUE commit_logging oradg11g TRUE commit_point_strength oradg11g11TRUE commit_wait oradg11g TRUE commit_write oradg11g TRUE compatible oradg11g11.2.0.0.011.2.0.0.0FALSE control_file_record_keep_time oradg11g77TRUEcontrol_files oradg11g /u01/app/oracle/oradata/oradg11g/control01.ctl, /u01/app/oracle/flash_recovery_area/oradg11g/control02.ctl/u01/app/oracle/oradata/oradg11g/control01.ctl,/u01/app/oracle/flash_recovery_area/oradg11g/control02.ctlFALSEcontrol_management_pack_access oradg11g DIAGNOSTIC+TUNING DIAGNOSTIC+TUNING TRUE core_dump_dest oradg11g/u01/app/oracle/diag/rdbms/oradg11g/oradg11g/cdump/u01/app/oracle/diag/rdbms/oradg11g/oradg11g/cdump TRUEcpu_count oradg11g22TRUE create_bitmap_area_size oradg11g83886088388608TRUE create_stored_outlines oradg11g TRUE cursor_bind_capture_destination oradg11g memory+disk memory+disk TRUE cursor_sharing oradg11g EXACT EXACT TRUE cursor_space_for_time oradg11g FALSE FALSE TRUE db_16k_cache_size oradg11g00TRUE db_2k_cache_size oradg11g00TRUE db_32k_cache_size oradg11g00TRUEdb_4k_cache_size oradg11g00TRUE db_8k_cache_size oradg11g00TRUEdb_block_buffers oradg11g00TRUE db_block_checking oradg11g FALSE FALSE TRUE db_block_checksum oradg11g TYPICAL TYPICAL TRUE db_block_size oradg11g81928192FALSE db_cache_advice oradg11g ON ON TRUE db_cache_size oradg11g00TRUEdb_create_file_dest oradg11g TRUE db_create_online_log_dest_1oradg11g TRUE db_create_online_log_dest_2oradg11g TRUE db_create_online_log_dest_3oradg11g TRUE db_create_online_log_dest_4oradg11g TRUE db_create_online_log_dest_5oradg11g TRUE db_domain oradg11g FALSE db_file_multiblock_read_count oradg11g77TRUE db_file_name_convert oradg11g oradglg, oradg11g oradglg, oradg11g FALSE db_files oradg11g200200TRUE db_flash_cache_file oradg11g TRUEdb_flash_cache_size oradg11g00TRUE db_flashback_retention_target oradg11g14401440TRUE db_keep_cache_size oradg11g00TRUEdb_lost_write_protect oradg11g NONE NONE TRUE db_name oradg11g oradg11g oradg11g FALSE db_recovery_file_dest oradg11g/u01/app/oracle/flash_recovery_area/u01/app/oracle/flash_recovery_area FALSE db_recovery_file_dest_size oradg11g43222302724122M FALSE db_recycle_cache_size oradg11g00TRUE db_securefile oradg11g PERMITTED PERMITTED TRUE db_ultra_safe oradg11g OFF OFF TRUE db_unique_name oradg11g oradg11g FALSE db_unrecoverable_scn_tracking oradg11g TRUE TRUE TRUE db_writer_processes oradg11g11TRUE dbwr_io_slavesddl_lock_timeout oradg11g00TRUE deferred_segment_creation oradg11g TRUE TRUE TRUE dg_broker_config_file1oradg11g/u01/app/oracle/product/11.2.0/dbhome_1/dbs/dr1oradg11g.dat/u01/app/oracle/product/11.2.0/dbhome_1/dbs/dr1oradg11g.dat TRUE dg_broker_config_file2oradg11g/u01/app/oracle/product/11.2.0/dbhome_1/dbs/dr2oradg11g.dat/u01/app/oracle/product/11.2.0/dbhome_1/dbs/dr2oradg11g.dat TRUE dg_broker_start oradg11g FALSE FALSE TRUE diagnostic_dest oradg11g/u01/app/oracle/u01/app/oracle FALSE disk_asynch_io oradg11g TRUE TRUE TRUE dispatchers oradg11g(PROTOCOL=TCP) (SERVICE=oradg11gXDB)(PROTOCOL=TCP) (SERVICE=oradg11gXDB)FALSE distributed_lock_timeout oradg11g6060TRUE dml_locks oradg11g10881088TRUE dst_upgrade_insert_conv oradg11g TRUE TRUE TRUE enable_ddl_logging oradg11g FALSE FALSE TRUE event oradg11g TRUEfal_client oradg11g oradg11g oradg11g FALSE fal_server oradg11g oradglg oradglg FALSEfast_start_io_target oradg11g00TRUE fast_start_mttr_target oradg11g00TRUE fast_start_parallel_rollback oradg11g LOW LOW TRUE file_mapping oradg11g FALSE FALSE TRUE fileio_network_adapters oradg11g TRUE filesystemio_options oradg11g none none TRUE fixed_date oradg11g TRUE gcs_server_processes oradg11g00TRUE global_context_pool_size oradg11g TRUE global_names oradg11g FALSE FALSE TRUE global_txn_processes oradg11g11TRUE hash_area_size oradg11g131072131072TRUE hi_shared_memory_address oradg11g00TRUEhs_autoregister oradg11g TRUE TRUE TRUE ifile oradg11g TRUE instance_groups oradg11g TRUE instance_name oradg11g oradg11g oradg11g TRUE instance_number oradg11g00TRUE instance_type oradg11g RDBMS RDBMS TRUE java_jit_enabled oradg11g TRUE TRUE TRUE java_max_sessionspace_size oradg11g00TRUE java_pool_size oradg11g00TRUE java_soft_sessionspace_limit oradg11g00TRUE job_queue_processes oradg11g10001000TRUE large_pool_size oradg11g00TRUE ldap_directory_access oradg11g NONE NONE TRUE ldap_directory_sysauth oradg11g no no TRUE license_max_sessions oradg11g00TRUElicense_max_users oradg11g00TRUE license_sessions_warning oradg11g00TRUE listener_networks oradg11g TRUE local_listener oradg11g TRUE lock_name_space oradg11g TRUE lock_sga oradg11g FALSE FALSE TRUE log_archive_config oradg11g DG_CONFIG=(oradg11g,oradgphy,oradglg,oradgss)< /font>DG_CONFIG=(oradg11g,oradgphy,oradglg,oradgss)FALSE log_archive_dest oradg11g TRUElog_archive_dest_1oradg11g LOCATION=USE_DB_RECOVERY_FILE_DESTdb_unique_name= oradg11g valid_for=(ALL_LOGFILES,ALL_ROLES)LOCATION=USE_DB_RECOVERY_FILE_DESTdb_unique_name=oradg11g valid_for=(ALL_LOGFILES,ALL_ROLES)FALSElog_archive_dest_10oradg11g TRUE log_archive_dest_11oradg11g TRUE log_archive_dest_12oradg11g TRUE log_archive_dest_13oradg11g TRUE log_archive_dest_14oradg11g TRUE log_archive_dest_15oradg11g TRUE log_archive_dest_16oradg11g TRUE log_archive_dest_17oradg11g TRUE log_archive_dest_18oradg11g TRUE log_archive_dest_19oradg11g TRUElog_archive_dest_2oradg11g SERVICE=tns_oradgphy LGWR ASYNC db_unique_name=oradgphy valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)SERVICE=tns_oradgphy LGWR ASYNCdb_unique_name=oradgphy valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)FALSElog_archive_dest_20oradg11g TRUE log_archive_dest_21oradg11g TRUE log_archive_dest_22oradg11g TRUE log_archive_dest_23oradg11g TRUE log_archive_dest_24oradg11g TRUE log_archive_dest_25oradg11g TRUE log_archive_dest_26oradg11g TRUE log_archive_dest_27oradg11g TRUE log_archive_dest_28oradg11g TRUElog_archive_dest_29oradg11g TRUElog_archive_dest_3oradg11g SERVICE=tns_oradglg LGWR ASYNC db_unique_name=oradglg valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)SERVICE=tns_oradglg LGWR ASYNCdb_unique_name=oradglg valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)FALSElog_archive_dest_30oradg11g TRUE log_archive_dest_31oradg11g TRUElog_archive_dest_4oradg11g SERVICE=tns_oradgss LGWR ASYNC db_unique_name=oradgss valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)SERVICE=tns_oradgss LGWR ASYNCdb_unique_name=oradgss valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)FALSElog_archive_dest_5oradg11g TRUE log_archive_dest_6oradg11g TRUE log_archive_dest_7oradg11g TRUE log_archive_dest_8oradg11g TRUE log_archive_dest_9oradg11g TRUE log_archive_dest_state_1oradg11g ENABLE ENABLE FALSE log_archive_dest_state_10oradg11g enable enable TRUE log_archive_dest_state_11oradg11g enable enable TRUE log_archive_dest_state_12oradg11g enable enable TRUE log_archive_dest_state_13oradg11g enable enable TRUE log_archive_dest_state_14oradg11g enable enable TRUE log_archive_dest_state_15oradg11g enable enable TRUE log_archive_dest_state_16oradg11g enable enable TRUE log_archive_dest_state_17oradg11g enable enable TRUE log_archive_dest_state_18oradg11g enable enable TRUE log_archive_dest_state_19oradg11g enable enable TRUE log_archive_dest_state_2oradg11g ENABLE ENABLE FALSE log_archive_dest_state_20oradg11g enable enable TRUE log_archive_dest_state_21oradg11g enable enable TRUE log_archive_dest_state_22oradg11g enable enable TRUE log_archive_dest_state_23oradg11g enable enable TRUE log_archive_dest_state_24oradg11g enable enable TRUE log_archive_dest_state_25oradg11g enable enable TRUE log_archive_dest_state_26oradg11g enable enable TRUE log_archive_dest_state_27oradg11g enable enable TRUE log_archive_dest_state_28oradg11g enable enable TRUE log_archive_dest_state_29oradg11g enable enable TRUE log_archive_dest_state_3oradg11g ENABLE ENABLE FALSE log_archive_dest_state_30oradg11g enable enable TRUE log_archive_dest_state_31oradg11g enable enable TRUE log_archive_dest_state_4oradg11g ENABLE ENABLE FALSE log_archive_dest_state_5oradg11g enable enable TRUE log_archive_dest_state_6oradg11g enable enable TRUE log_archive_dest_state_7oradg11g enable enable TRUE log_archive_dest_state_8oradg11g enable enable TRUE log_archive_dest_state_9oradg11g enable enable TRUE log_archive_duplex_dest oradg11g TRUElog_archive_formatlog_archive_local_first oradg11g TRUE TRUE TRUE log_archive_max_processes oradg11g44FALSE log_archive_min_succeed_dest oradg11g11TRUE log_archive_start oradg11g FALSE FALSE TRUE log_archive_trace oradg11g00TRUE log_buffer oradg11g81100808110080TRUE log_checkpoint_interval oradg11g00TRUE log_checkpoint_timeout oradg11g18001800TRUE log_checkpoints_to_alert oradg11g FALSE FALSE TRUE log_file_name_convert oradg11g oradglg, oradg11g oradglg, oradg11g FALSE max_dispatchers oradg11g TRUE max_dump_file_size oradg11g unlimited unlimited TRUE max_enabled_roles oradg11g150150TRUE max_shared_servers oradg11g TRUE memory_max_target oradg11g419430400400M FALSE memory_target oradg11g314572800300M FALSE nls_calendar oradg11g GREGORIAN GREGORIAN TRUE nls_comp oradg11g BINARY BINARY TRUE nls_currency oradg11g￥￥TRUE nls_date_format oradg11g YYYY-MM-DD HH24:mi:ss YYYY-MM-DD HH24:mi:ss TRUE nls_date_language oradg11g AMERICAN AMERICAN TRUE nls_dual_currency oradg11g￥￥TRUE nls_iso_currency oradg11g CHINA CHINA TRUE nls_language oradg11g AMERICAN AMERICAN TRUE nls_length_semantics oradg11g BYTE BYTE TRUE nls_nchar_conv_excp oradg11g FALSE FALSE TRUE nls_numeric_characters oradg11g.,.,TRUE nls_sort oradg11g BINARY BINARY TRUE nls_territory oradg11g CHINA CHINA TRUE nls_time_formatnls_time_tz_format oradg11g HH.MI.SSXFF AM TZR HH.MI.SSXFF AM TZR TRUE nls_timestamp_format oradg11g DD-MON-RR HH.MI.SSXFF AM DD-MON-RR HH.MI.SSXFF AM TRUE nls_timestamp_tz_format oradg11g DD-MON-RR HH.MI.SSXFF AM TZR DD-MON-RR HH.MI.SSXFF AM TZR TRUEobject_cache_max_size_percent oradg11g1010TRUE object_cache_optimal_size oradg11g102400102400TRUE olap_page_pool_size oradg11g00TRUE open_cursors oradg11g300FALSE open_links oradg11g44TRUE open_links_per_instance oradg11g44TRUE optimizer_capture_sql_plan_baselines oradg11g FALSE FALSE TRUE optimizer_dynamic_sampling oradg11g22TRUE optimizer_features_enable oradg11g11.2.0.311.2.0.3TRUE optimizer_index_caching oradg11g00TRUE optimizer_index_cost_adj oradg11g100100TRUE optimizer_modeoptimizer_secure_view_merging oradg11g TRUE TRUE TRUEoptimizer_use_invisible_indexes oradg11g FALSE FALSE TRUE optimizer_use_pending_statistics oradg11g FALSE FALSE TRUE optimizer_use_sql_plan_baselines oradg11g TRUE TRUE TRUE os_authent_prefix oradg11g ops$ops$TRUE os_roles oradg11g FALSE FALSE TRUEparallel_adaptive_multi_user oradg11g TRUE TRUE TRUE parallel_automatic_tuning oradg11g FALSE FALSE TRUE parallel_degree_limit oradg11g CPU CPU TRUE parallel_degree_policy oradg11g MANUAL MANUAL TRUE parallel_execution_message_size oradg11g1638416384TRUEparallel_force_local oradg11g FALSE FALSE TRUE parallel_instance_group oradg11g TRUE parallel_io_cap_enabled oradg11g FALSE FALSE TRUE parallel_max_servers oradg11g8080TRUE parallel_min_percent oradg11g00TRUE parallel_min_servers oradg11g00TRUE parallel_min_time_threshold oradg11g AUTO AUTO TRUE parallel_server oradg11g FALSE FALSE TRUE parallel_server_instances oradg11g11TRUE parallel_servers_target oradg11g3232TRUE parallel_threads_per_cpu oradg11g22TRUE permit_92_wrap_format oradg11g TRUE TRUE TRUE pga_aggregate_target oradg11g00TRUE plscope_settings oradg11g IDENTIFIERS:NONE IDENTIFIERS:NONE TRUEplsql_ccflags oradg11g TRUE plsql_code_type oradg11g INTERPRETED INTERPRETED TRUE plsql_debug oradg11g FALSE FALSE TRUE plsql_optimize_level oradg11g22TRUEplsql_v2_compatibility oradg11g FALSE FALSE TRUE plsql_warnings oradg11g DISABLE:ALL DISABLE:ALL TRUEpre_page_sga oradg11g FALSE FALSE TRUE processes oradg11g150150FALSEprocessor_group_name oradg11g TRUE query_rewrite_enabled oradg11g TRUE TRUE TRUE query_rewrite_integrity oradg11g enforced enforced TRUE rdbms_server_dn oradg11g TRUE read_only_open_delayed oradg11g FALSE FALSE TRUE recovery_parallelism oradg11g00TRUE recyclebin oradg11g on on TRUEredo_transport_user oradg11g TRUE remote_dependencies_mode oradg11g TIMESTAMP TIMESTAMP TRUEremote_listener oradg11g TRUEremote_login_passwordfile oradg11g EXCLUSIVE EXCLUSIVE FALSE remote_os_authent oradg11g FALSE FALSE TRUE remote_os_roles oradg11g FALSE FALSE TRUE replication_dependency_tracking oradg11g TRUE TRUE TRUE resource_limit oradg11g FALSE FALSE TRUE resource_manager_cpu_allocation oradg11g22TRUE resource_manager_plan oradg11g TRUE result_cache_max_result oradg11g55TRUE result_cache_max_size oradg11g786432768K TRUE result_cache_mode oradg11g MANUAL MANUAL TRUE result_cache_remote_expiration oradg11g00TRUEresumable_timeout oradg11g00TRUE rollback_segments oradg11g TRUEsec_case_sensitive_logon oradg11g TRUE TRUE TRUE sec_max_failed_login_attempts oradg11g1010TRUEsec_protocol_error_further_action oradg11g CONTINUE CONTINUE TRUE sec_protocol_error_trace_action oradg11g TRACE TRACE TRUE sec_return_server_release_banner oradg11g FALSE FALSE TRUE serial_reuse oradg11g disable disable TRUE service_names oradg11g oradg11g oradg11g TRUE session_cached_cursors oradg11g5050TRUE session_max_open_files oradg11g1010TRUEsessions oradg11g248248TRUE sga_max_sizesga_target oradg11g00TRUE shadow_core_dump oradg11g partial partial TRUEshared_memory_address oradg11g00TRUEshared_pool_reserved_size oradg11g81788928178892TRUE shared_pool_size oradg11g00TRUE shared_server_sessions oradg11g TRUE shared_servers oradg11g11TRUE skip_unusable_indexes oradg11g TRUE TRUE TRUE smtp_out_server oradg11g TRUE sort_area_retained_size oradg11g00TRUE sort_area_size oradg11g6553665536TRUE spfile oradg11g/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoradg11g.ora/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoradg11g.ora TRUE sql92_security oradg11g FALSE FALSE TRUE sql_trace oradg11g FALSE FALSE TRUE sqltune_category oradg11g DEFAULT DEFAULT TRUE standby_archive_dest oradg11g?/dbs/arch?/dbs/arch TRUE standby_file_management oradg11g AUTO AUTO FALSEstar_transformation_enabled oradg11g FALSE FALSE TRUE statistics_level oradg11g TYPICAL TYPICAL TRUE streams_pool_size oradg11g00TRUE tape_asynch_io oradg11g TRUE TRUE TRUEthread oradg11g00TRUE timed_os_statistics oradg11g00TRUE timed_statistics oradg11g TRUE TRUE TRUEtrace_enabled oradg11g TRUE TRUE TRUE tracefile_identifier oradg11g TRUEtransactions oradg11g272272TRUE transactions_per_rollback_segment oradg11g55TRUE undo_management oradg11g AUTO AUTO TRUEundo_retention oradg11g900900TRUE undo_tablespace oradg11g UNDOTBS1UNDOTBS1FALSEuse_indirect_data_buffers oradg11g FALSE FALSE TRUE use_large_pages oradg11g TRUE TRUE TRUE user_dump_dest oradg11g/u01/app/oracle/diag/rdbms/oradg11g/oradg11g/trace/u01/app/oracle/diag/rdbms/oradg11g/oradg11g/trace TRUE utl_file_dir oradg11g TRUE workarea_size_policy oradg11g AUTO AUTO TRUE xml_db_events oradg11g enable enable TRUE[] []关键的初始化参数参数名称实例名称参数值cpu_count oradg11g2cursor_sharing oradg11g EXACTdb_block_size oradg11g8192db_cache_size oradg11g0db_file_multiblock_read_count oradg11g7instance_name oradg11g oradg11ginstance_number oradg11g0java_pool_size oradg11g0job_queue_processes oradg11g1000large_pool_size oradg11g0local_listener oradg11glog_archive_dest_1oradg11g LOCATION=USE_DB_RECOVERY_FILE_DEST db_unique_name= oradg11g valid_for= (ALL_LOGFILES,ALL_ROLES)log_buffer oradg11g8110080open_cursors oradg11g300optimizer_index_caching oradg11g0optimizer_index_cost_adj oradg11g100optimizer_mode oradg11g ALL_ROWSpga_aggregate_target oradg11g0processes oradg11g150sessions oradg11g248sga_max_size oradg11g419430400sga_target oradg11g0shared_pool_size oradg11g0sort_area_size oradg11g65536spfile oradg11g/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoradg11g.ora thread oradg11g0[]数据库⼤⼩dmp全备份约(G)RMAN全备份约(G)数据⽂件容量(G)223[]资源使⽤情况资源名称当前值最⼤值初始值限制值processes3752150150sessions4558248248enqueue_locks285531603160enqueue_resources22441308UNLIMITEDges_procs0000ges_ress000UNLIMITEDges_locks000UNLIMITEDges_cache_ress000UNLIMITEDges_reg_msgs000UNLIMITEDges_big_msgs000UNLIMITEDges_rsv_msgs0000gcs_resources00UNLIMITED UNLIMITEDgcs_shadows00UNLIMITED UNLIMITEDsmartio_overhead_memory000UNLIMITEDsmartio_buffer_memory000UNLIMITEDsmartio_metadata_memory000UNLIMITEDsmartio_sessions000UNLIMITEDdml_locks001088UNLIMITEDtemporary_table_locks00UNLIMITED UNLIMITEDtransactions00272UNLIMITEDbranches00272UNLIMITEDcmtcallbk01272UNLIMITEDmax_rollback_segments111127265535sort_segment_locks13UNLIMITED UNLIMITEDk2q_locks00496UNLIMITEDmax_shared_servers11UNLIMITED UNLIMITEDparallel_max_servers016803600[]表空间情况表空间状况状态表空间名称表空间类型扩展管理⽅段管理⽅�表空间⼤⼩(MB)空闲(MB)使⽤(MB)Pct. UsedONLINE EXAMPLE PERMANENT LOCAL AUTO3463631089 %ONLINE LOGMNRTBS PERMANENT LOCAL AUTO35525510028 %ONLINE SYSAUX PERMANENT LOCAL AUTO5805053091 %ONLINE SYSTEM PERMANENT LOCAL MANUAL86012773385 %ONLINE TEMP TEMPORARY LOCAL MANUAL29181137 %ONLINE UNDOTBS1UNDO LOCAL MANUAL95603637 %ONLINE USERS PERMANENT LOCAL AUTO4133892 %------------------------------------------------------------Total:2,3065481,758TS#TS_NAME CONTENTS TS_SIZE_M FREE_SIZE_M USED_SIZE_M USED_PER MAX_SIZE_G MAX_SIZE_FREE_G USED_PER_MAX BLOCK_SIZE LOGGING状态0SYSTEM PERMANENT86012773385.2763231.284 2.2388192LOGGING ONLINE 1SYSAUX PERMANENT5805053091.3693231.482 1.6178192LOGGING ONLINE 2UNDOTBS1UNDO95603637.3683231.965.1088192LOGGING ONLINE 3TEMP TEMPORARY29272 6.8973231.998.0068192NOLOGGING ONLINE 4USERS PERMANENT4133892.8793231.963.1178192LOGGING ONLINE6EXAMPLE PERMANENT3463631089.7293231.697.9468192NOLOGGING ONLINE 7LOGMNRTBS PERMANENT35525510028.169 1.953 1.85558192LOGGING ONLINE 所有表空间2305.875557174975.861194192.245[]数据库闪回空间使⽤情况●数据库闪回空间总体使⽤情况NAME LIMIT_GB USED_GB USED%RECLAIM_GB FILE# /u01/app/oracle/flash_recovery_area 4.025.614.904.4663[]●数据库闪回空间详细使⽤情况TYPE USED_GB USED%RECLAIMABLE%RECLAIM_GB FILES# ARCHIVED LOG.091 2.260045BACKUP PIECE00000CONTROL FILE00000FLASHBACK LOG.48812.1310.92.4410FOREIGN ARCHIVED LOG.021.52.51.0218IMAGE COPY00000REDO LOG00000----------------------------------------------------.614.9111.43.46163[]临时表空间使⽤情况Name Size (M)HWM (M)HWM %Using (M)Using % TEMP29.00011.00037.93 1.000 3.45[]查谁占⽤了undo表空间[]数据⽂件状况Tablespace Name / File Class Filename File Size Autoextensible Next MaxEXAMPLE/u01/app/oracle/oradata/oradg11g/example01.dbf362,414,080YES655,36034,359,721,984LOGMNRTBS/u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf372,244,480YES5,242,8802,097,152,000SYSAUX/u01/app/oracle/oradata/oradg11g/sysaux01.dbf608,174,080YES10,485,76034,359,721,984SYSTEM/u01/app/oracle/oradata/oradg11g/system01.dbf901,775,360YES10,485,76034,359,721,984TEMP/u01/app/oracle/oradata/oradg11g/temp01.dbf30,408,704YES655,36034,359,721,984UNDOTBS1/u01/app/oracle/oradata/oradg11g/undotbs01.dbf99,614,720YES5,242,88034,359,721,984USERS/u01/app/oracle/oradata/oradg11g/users01.dbf43,253,760YES1,310,72034,359,721,984[ CONTROL FILE ]/u01/app/oracle/flash_recovery_area/oradg11g/control02.ctl[ CONTROL FILE ]/u01/app/oracle/oradata/oradg11g/control01.ctl[ ONLINE REDO LOG ]/u01/app/oracle/oradata/oradg11g/redo01.log52,428,800[ ONLINE REDO LOG ]/u01/app/oracle/oradata/oradg11g/redo02.log52,428,800[ ONLINE REDO LOG ]/u01/app/oracle/oradata/oradg11g/redo03.log52,428,800--------------------Total:2,575,171,584FILE_ID TABLESPACE_NAME TS_SIZE_M FILE_NAME FILE_SIZE_M FILE_MAX_SIZE_G Aut INCREMENT_M AUTOEXTEND_RATIO5EXAMPLE345.63/u01/app/oracle/oradata/oradg11g/example01.dbf345.6332YES.63 1.056LOGMNRTBS355/u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf355 1.95YES517.752SYSAUX580/u01/app/oracle/oradata/oradg11g/sysaux01.dbf58032YES10 1.771SYSTEM860/u01/app/oracle/oradata/oradg11g/system01.dbf86032YES10 2.621TEMP29/u01/app/oracle/oradata/oradg11g/temp01.dbf2932YES.63.093UNDOTBS195/u01/app/oracle/oradata/oradg11g/undotbs01.dbf9532YES5.294USERS41.25/u01/app/oracle/oradata/oradg11g/users01.dbf41.2532YES 1.25.13[]表空间扩展Tablespace Name Largest Extent Smallest Extent Total Free Number of Free ExtentsEXAMPLE34,668,544589,82437,224,4483LOGMNRTBS200,278,0161,048,576267,386,88010SYSAUX35,651,58465,53652,494,33663SYSTEM132,120,576655,360132,775,9362UNDOTBS124,117,24865,53662,390,27226USERS2,359,29665,5363,080,1923----------------------------------------------------------------------------------Total:429,195,2642,490,368555,352,064107[]观察回滚段，临时段及普通段否是⾃动扩展●回滚段FILE_NAME TABLESPACE_NAME SIZE_M AUT ONLINE_ /u01/app/oracle/oradata/oradg11g/undotbs01.dbf UNDOTBS195YES ONLINE●临时段FILE_NAME SIZE_M STATUS AUT /u01/app/oracle/oradata/oradg11g/temp01.dbf29ONLINE YES●普通段FILE_NAME TABLESPACE_NAME STATUS SIZE_M AUT /u01/app/oracle/oradata/oradg11g/users01.dbf USERS AVAILABLE41.25YES/u01/app/oracle/oradata/oradg11g/undotbs01.dbf UNDOTBS1AVAILABLE95YES/u01/app/oracle/oradata/oradg11g/sysaux01.dbf SYSAUX AVAILABLE580YES/u01/app/oracle/oradata/oradg11g/system01.dbf SYSTEM AVAILABLE860YES/u01/app/oracle/oradata/oradg11g/example01.dbf EXAMPLE AVAILABLE345.625YES/u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf LOGMNRTBS AVAILABLE355YES●所有段FILE_ID TABLESPACE_NAME TS_SIZE_M FILE_NAME FILE_SIZE_M FILE_MAX_SIZE AUT INCREMENT_BY STATUS INCREMENT_BY_BLOCK 5EXAMPLE345.625/u01/app/oracle/oradata/oradg11g/example01.dbf345.62532767.984YES.625AVAILABLE6LOGMNRTBS355/u01/app/oracle/oradata/oradg11g/logmnrtbs1.dbf3552000YES5AVAILABLE2SYSAUX580/u01/app/oracle/oradata/oradg11g/sysaux01.dbf58032767.984YES10AVAILABLE1SYSTEM860/u01/app/oracle/oradata/oradg11g/system01.dbf86032767.984YES10AVAILABLE1TEMP29/u01/app/oracle/oradata/oradg11g/temp01.dbf2932767.984YES.625ONLINE3UNDOTBS195/u01/app/oracle/oradata/oradg11g/undotbs01.dbf9532767.984YES5AVAILABLE4USERS41.25/u01/app/oracle/oradata/oradg11g/users01.dbf41.2532767.984YES 1.25AVAILABLE[]表空间所有者Tablespace Name Owner Segment Type Size (in Bytes)Segment Count EXAMPLE HR INDEX1,245,18419HR TABLE393,2166IX INDEX917,50414IX LOBINDEX196,6083IX LOBSEGMENT196,6083IX TABLE524,2888OE INDEX2,162,68822OE LOBINDEX327,6805OE LOBSEGMENT393,2165OE TABLE3,735,5528PM INDEX262,1444PM LOBINDEX1,114,11217PM LOBSEGMENT11,206,65617PM NESTED TABLE65,5361PM TABLE196,6082SH INDEX PARTITION11,141,120112SH INDEX2,490,36819SH LOBINDEX131,0722SH LOBSEGMENT131,0722SH TABLE PARTITION268,435,45632SH TABLE18,874,36812 LOGMNRTBS SYSTEM INDEX PARTITION23,199,744104SYSTEM INDEX917,50414SYSTEM LOBINDEX589,8246SYSTEM LOBSEGMENT4,521,9846SYSTEM TABLE PARTITION73,662,46476SYSTEM TABLE917,50414 SYSAUX APEX_030200INDEX39,976,960262APEX_030200LOBINDEX3,276,80050APEX_030200LOBSEGMENT10,420,22450APEX_030200TABLE35,913,728105CTXSYS INDEX2,490,36838CTXSYS LOBINDEX131,0722CTXSYS LOBSEGMENT131,0722CTXSYS TABLE1,179,64817DBSNMP INDEX327,6805DBSNMP TABLE196,6083EXFSYS INDEX2,424,83237EXFSYS LOBINDEX65,5361EXFSYS LOBSEGMENT65,5361EXFSYS TABLE1,245,18419MDSYS INDEX7,405,56898MDSYS LOBINDEX12,976,128197MDSYS LOBSEGMENT41,877,504197MDSYS NESTED TABLE1,048,57616MDSYS TABLE14,221,31264OLAPSYS INDEX5,242,88080OLAPSYS TABLE3,997,69661ORDDATA INDEX6,946,81695ORDDATA LOBINDEX393,2166ORDDATA LOBSEGMENT3,014,6566ORDDATA NESTED TABLE131,0722ORDDATA TABLE3,735,55251ORDSYS INDEX196,6083ORDSYS TABLE262,1444SYS CLUSTER2,097,1521SYS INDEX PARTITION4,521,98454SYS INDEX37,355,520358SYS LOB PARTITION65,5361SYS LOBINDEX4,063,23262SYS LOBSEGMENT45,744,12862SYS TABLE PARTITION4,784,12851SYS TABLE SUBPARTITION2,097,15232SYS TABLE35,913,728302SYSMAN INDEX24,969,216301SYSMAN LOBINDEX2,818,04843SYSMAN LOBSEGMENT3,407,87243SYSMAN NESTED TABLE131,0722SYSMAN TABLE16,842,752190SYSTEM INDEX524,2888SYSTEM LOBINDEX131,0722SYSTEM LOBSEGMENT131,0722SYSTEM TABLE PARTITION65,5361SYSTEM TABLE655,36010WMSYS INDEX1,966,08030WMSYS LOBINDEX327,6805WMSYS LOBSEGMENT327,6805WMSYS NESTED TABLE131,0722。
Oracle Healthcare Data Repository 安全配置指南说明书
Oracle® Healthcare Data RepositorySecure Configuration GuideRelease 8.0E98319-01February 2019The Secure Configuration Guide provides an overview of the security features providedwith the Oracle® Healthcare Data Repository application, including details about thegeneral principles of application security, and how to install, configure, and use theHealthcare Data Repository application securely.This guide is for users who install and configure the Healthcare Data Repositoryapplication.■Security Overview■Secure installation and configuration■Security Features■Documentation Accessibility1 Security Overview■Application security overview■General security principles1.1 Application security overviewTo ensure security in the Healthcare Data Repository application, carefully configureall system components:■Firewalls■Load balancers■Virtual Private Networks (VPNs)1.2 General security principlesRequire complex and secure passwordsAny user who is configured in the WebLogic server where HDR application isdeployed can access its APIs. It is recommended that strong password is used for theWebLogic user account that will be used to access HDR APIs.Keep passwords private and secureTell users never to share passwords, write down passwords, or store passwords in fileson their computers.Lock computers to protect dataEncourage users to lock computers that are left unattended.Provide only the necessary rights to perform an operationCreate necessary user roles for users accessing the application developed using HDR APIs to provide necessary access control to access different types of clinical data stored in HDR.2 Secure installation and configuration■Installation overview■Post-installation configuration2.1 Installation overviewUse the information in this chapter to ensure the Healthcare Data Repository application is installed and configured securely. For information about installing and configuring the Healthcare Data Repository application, see the Installation Guide. Secure Socket Layer (SSL)To encrypt the transmission of data between the application server and the applications that consume HDR APIs, you must enable the Secure Socket Layer (SSL) port on the HDR managed server and obtain an X.509 certificate using your company certificate store or a third party to configure the HDR managed server SSL certificates. Configure strong database passwordsWhen you install the Healthcare Data Repository application, a system database administrator user is created. Only a system database administrator can perform the installation. Ensure all your database schema passwords for HDR, ETS and HDR_ CONFIG users are strong passwords.Close all unused portsKeep only the minimum number of ports open. You should close all ports not in use. The Healthcare Data Repository application uses the following ports:■WebLogic admin server SSL port for users who administer the HDR application.■WebLogic managed server SSL port for accessing the HDR.Disable all unused servicesDisable all unknown, unused services running on the HDR WebLogic instance.2.2 Post-installation configurationRestrict access to Healthcare Data Repository server machinesAllow only administrator and system accounts access to the Healthcare Data Repository application server and database server machines.Limit the number of users with access to the server machines. Disable or delete any unnecessary users.Configure strong user passwordsConfigure password options to require a secure level of complexity. For example, a minimum required password length of 8 characters requires users to create more secure and complex passwords than a minimum required password length of 6 characters.3 Security Features■User security features■Application security features■Data security features3.1 User security featuresLogin securityUsers must enter their user names and passwords to access the HDR APIs during each client request.If either a user name or password is incorrect, an error message appears, but does not tell the user the value that is incorrect. Therefore, if someone else is using the account to attempt to log in, the message does not confirm either a user name or password.No data loss after a session transactionAll HDR services are stateless and none of the services maintain any kind of session information after the API call ends.Automatically deactivated user accountsUserLockout can be enabled for the HDR WebLogic user. Refer tohttps:///middleware/12213/wls/WLACH/pagehelp/Securitysecuri tyrealmrealmuserlockouttitle.html.Security event logsUser authentication logging for HDR application can be done by configuring the WebLogic Auditing Provider. Refer tohttps:///middleware/12213/wls/SECMG/audit.htm#SECMG137.3.2 Application security featuresOracle Healthcare Data Repository relies on WebLogic user authentication to access all its APIs. There is no authorization mandated since more elaborate user authentication and authorization are implemented in the application developed using HDR APIs. Default userThe Healthcare Data Repository application installs the WebLogic admin user by default. During the installation, you configure a password for this user.Oracle recommends that you create administrator accounts for individual users and delete the system user after the initial application configuration.3.3 Data security featuresProtecting study objectsYou can protect a library or a study to prevent users from making changes to study objects that you do not want to be modified.When you protect a study or library, changes cannot be made to study objects or to the structure of the study or library.When a study object is protected, its icon changes to reflect its protected state.For more information, see the Implementation Guide.Audit trails for data securityAudit trails are comprehensive records that include information about each change that occurs in the Healthcare Data Repository application.The audit trail for the Healthcare Data Repository application records each change, and for each change:■Person who made the change.■Date and time of the change.You cannot modify data in an audit trail. For more information, see the User Guide.4 Documentation AccessibilityFor information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at/pls/topic/lookup?ctx=acc&id=docacc.Access to Oracle SupportOracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit/pls/topic/lookup?ctx=acc&id=info or visit/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.Oracle Healthcare Data Repository Secure Configuration Guide, Release 8.0E98319-01Copyright © 2018, Oracle and/or its affiliates. All rights reserved.This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.。
Oracle数据库健康检查及其评估
XXXXXXXXXXXXXXXXXXXXOracle数据库健康检查与评估XXXX巡检人：报告生成日期：yyyy-mm-dd文档控制此文档仅供江苏移动审阅，不得向与此无关的个人或机构传阅或复制。
修改记录分发者审阅记录相关文档目录1.检查介绍1.1检查系统系统主要包括1个数据库，具体情况如下：1.2检查范围本次检查仅限于数据库。
在这次检查中对数据库配置和数据库性能进行了分析。
本报告提供的检查和建议不涉及具体的安全分析和应用程序的具体细节。
以下提请注意：本次检查仅历时1天，其中还包括了提交分析报告的时间，所以在具体的应用程序性能方面并不加以深入。
以下列出系统主机的主要配置情况2.1主机配置建议：目前系统配置满足数据库要求，操作系统参数设置合理。
和数据库相关的操作系统配置将被检查，包括以下方面：●操作系统数据库相关要求补丁●存放oracle文件的硬盘区可用空间(oracle文件包括：数据文件，控制文件，在线redo logs，归档redo logs，运行情况文件和跟踪文件)。
●硬盘利用率。
●CPU利用率。
3.1操作系统数据库相关要求补丁建议：3.2硬盘可用空间硬盘可用情况如下示：数据库XXXX的硬盘使用率情况如下：Filesystem kbytes used avail %used Mounted on数据库YYYY的硬盘使用率情况如下：Filesystem kbytes used avail %used Mounted on建议：目前该数据库服务器中还没有其他硬盘空间使用率超过90%的分区。
如果有需要引起注意并且及时增加硬盘空间的容量。
3.3CPU 利用率CPU利用率的统计时间是：yyyy-mm-dd hh:mi---- yyyy-mm-dd hh:mi1.top / glance2.vmstat 2 20参考值：1.最大CPU使用率：60%--70%2.系统进程与用户进程占用CPU最大比率：40/60数据库XXXX:数据库YYYY:从上述的情况中看出，数据库:服务器CPU idle基本在75%以上，CPU资源较为空闲。
Oracle Exadata Database Machine 11g 管理指南说明书
• Identify and resolve issues • Validate performance gains
Monitor
• Exadata service • Database • Storage cells
Manage
• Performance diagnostics • Application SQL tuning
Exadata Management
Exadata Management
Deploy
• Provision Database
• Configure monitoring
Test
• Validate application performance • Test for response time • Test for throughput
Storage OS
• Migrating application to Exadata involves multiple changes:
• O/S migrations • Storage subsystem changes • Database upgrades • Single database instance to RAC
SQL Performance Analyzer (SPA)
SQL Plans + Stats on current system
SQL Workload STS
SQL Plans + Stats on Exadata DB Machine
Compare SQL Performance
Analysis Report
Maintain
• Patch automation
Exadata系统检测维护文档
Exadata系统检测维护⽂档xxxx技术服务有限公司xxxxExadata数据库健康检查报告作者:xxxx创建⽇期:2014年x⽉xx⽇最后修改⽇期: 2014年x⽉xx⽇1 ⽂档控制1.1 修改记录1.2 分发者2 ⽬录1 ⽂档控制 ................................................................................................................... I I 1.1修改记录. (II)1.2分发者 (II)2 ⽬录.......................................................................................................................... I II3 检查总结 (5)3.1概要 (5)3.2建议 (5)4 介绍 (6)4.1⽬标 (6)4.2检查⽅法 (6)4.3检查范围 (6)5 EXADATA配置概要 (7)6 计算节点检查 (7)6.1硬件检查 (8)6.1.1 物理磁盘驱动器配置 (8)6.1.2 磁盘状态 (9)6.1.3 RAID控制器电池 (9)6.1.4 以太⽹⽹络连接 (10)6.1.5 IB私⽹⽹络连接 (10)6.1.6 RAID控制器电池温度 (11)6.1.7 磁盘控制器写⼊模式 (11)6.2操作系统配置检查 (12)6.2.1 hugepages配置 (12)6.2.2 OSwatcher运⾏情况 (13)6.2.3 Shell Limit配置情况 (14)6.2.4 集群RDS协议配置 (14)6.2.5 NUMA功能配置 (15)6.2.6 关闭SELinux (15)6.2.7 内核参数配置 (16)6.2.8 ILOM配置 (16)6.2.9 关闭磁盘的cache策略 (17)7 存储节点检查 (17)7.1硬件检查 (18)7.1.1 RAID控制器电池温度 (18)7.1.2 Flash disk状态 (18)7.1.3 Hard disk状态 (20)7.1.4 关闭磁盘cache策略 (21)7.2存储软件配置检查 (22)7.2.1 存储节点ipconf⽹络配置 (22)7.2.2 Smart Flash log 是否创建 (24)8 IB交换机检查 (26)8.1.1 ⼦⽹管理器是否运⾏ (26)9 数据库配置 (26)9.1数据库版本 (26)9.2数据库初始化参数 (26)9.3控制⽂件 (28)9.4联机⽇志(O NLINE R EDO L OG) (28) 9.5数据⽂件管理(包括临时⽂件) (29) 9.6表空间管理 (32)9.7回滚段 (33)9.8数据库对象管理 (33)9.9JOB管理 (34)9.10安全性管理 (34)9.11D ISK G ROUP空间管理 (35)10 数据库集群状态 (36)10.1集群状态检查 (36)U SING: CRSCTL CHECK CRS (36)10.2OCR检查 (36)U SING: OCRCHECK (36)10.3VOTTE DISK检查 (37)U SING: CRSCTL QUERY CSS VOTEDISK (37)10.4CRS软件版本 (37)U SING: CRSCTL QUERY CRS ACTIVEVERSION (37)10.5集群资源检查 (38)U SING: CRSCTL STATUS RESOURCE -T (38)11 备份与恢复 (40)11.1备份 (40)11.2恢复 (40)12 数据库性能 (41)12.1系统负载情况 (41)12.2⽐较消耗资源的SQL语句 (42)12.3E XADATA上索引情况 (42)3 检查总结3.1 概要此次数据库检查包括以下内容：如果⼯程师在检查中发现ORACLE配置或性能⽅⾯的问题，我们将对检查范围内的情况进⾏记录，并提出建议。
oracle数据库健康检查方案
目录目录 (1)操作系统检查 (2)1.查看本地磁盘和挂载的华为存储磁盘使用率 (2)2.查看内存使用率 (2)3.查看CPU使用率 (2)4.查看10情况 (2)5.查看当前系统时间、运行天数 (3)6.查看系统日志、远程登录日志 (3)7.查看服务器负载情况 (3)8.查看数据库日志 (3)9.查看数据库监听日志大小，超过2G就要处理 (3)Oracle数据库健康检查 (3)10.检查oracle数据库的运行情况 (3)11.检查oracle数据库的实例运行情况 (4)12.检查当前数据库的实例状态、归档模式、实例己运行时间、实例名称、数据库名称和归档进程状态等运行时的重要信息。
(4)13.查看oracle数据库端设置的字符集 (4)14.查看oracle客户端设置的字符集 (4)15.检查各个表空间的数据文件总大小'G, (5)16.检查表空间总个数 (5)17.检查各个表空间的数据文件总个数 (5)18.检查数据库表空间的使用情况 (5)19.检查数据库表空间的剩余空间大小'G, (6)20.检查数据库表空间的运行状态等信息 (6)21.检查数据库表空间的数据文件状态等信息 (6)22.检查数据库表空间异常状态的数据文件 (7)25.检查数据库归档模式相关信息 (8)26.检查数据库的JOB运行情况 (8)27.检查数据库的对象信息 (8)28.检查数据库索引not analyzed (9)29.检查数据库的会话信息 (9)30.检查数据库中行迁移的表 (9)31.检查数据库中表的碎片大小 (10)32.检查数据库回收站的信息 (10)33.用awr工具来检查数据库的性能情况 (10)LINUX操作系统检查1. 查看本地磁盘和挂载的华为存储磁盘使用率执行命令:df -h2.查看内存使用率执行命令：free -m3. 查看CPU使用率执行命令：top4∙查看10情况执行命令：iostat 2 105.查看当前系统时间、运行天数执行命令：date, uptime6.查看系统日志、远程登录日志执行命令：cat ∕var∕log∕messages> cat ∕var∕log∕secure7.查看服务器负载情况执行命令：sar 2 10或者vmstat 2 108.查看数据库日志切换到oracle 用户，进入口志目录cd ∕u01∕app∕θracle∕admin∕MICSPROD∕bdump∕查看日志有没有报错命令tail -300 alert_micspord.log∣grep 'ORA'tail -300 alert_micspord.log ∣grep z Err,9∙查看数据库监听日志大小，超过2G就要处理切换到oracle用户，进入日志目录cd $ORACLE_HOME/network/log查看日志大小命令Is -1thOracle数据库健康检查10.检查。
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
0.作业概述
运行EXADATA Database Machine HealthCheck，检查软件、硬件、固件版本、配置等，生成健康检查报告。
1.作业对象
EXADATA Database Machine上的软件、硬件、固件版本、配置等。
2.作业前确认事项
3.作业具体操作步骤
3.1.下载最新软件
登录ORACLE SUPPORT网站： ，找到并打开ID为1070954.1的文章，下载最新的HealthCheck软件。
3.2.安装并做健康检查
1）将exachk.zip上传到一台数据库服务器上，如：hdexdb01；
2）以“oracle”用户登录数据库服务器，并执行：
•$ unzip exachk.zip
•$ chmod +x exachk
3）查看readme.txt 和UserGuide：
4）运行Exachk工具（必须以“oracle”用户执行）
•$./exachk
5） 确认clusterware home (CRS_HOME)
6） 检查数据库服务器上的SSH 设置是否正确
7） 选择要检查的数据库
8） 软件环境检查结果显示
9） 输入Storage Server 上root 的密码
10）
输入Database Server 上root 的密码
11）
输入Infiniband switch 上root 的密码
12）
收集database server, storage server 和 infiniband switche 上的配置信息
13）
分析系统状况
14）
检查结果输出到文件
15）查看结果并处理错误
---手册完---。