以下汇总的command 可以用于收集Exadata数据库一体机的诊断信息:
实例相关参数v$parameter Exadata相关的统计信息 v$sysstat 与Exadata相关的一些动态性能视图v$cell,v$cell_state,v$cell_thread_history,v$cell_request_totals - /etc/oracle/cell/network-config/cellinit.ora - /etc/oracle/cell/network-config/cellip.ora - cellcli -e list alerthistory detail - cellcli -e list cell detail - cellcli -e list celldisk detail - cellcli -e list griddisk detail - cellcli -e list iormplan detail - cellcli -e list metricdefinition detail - cellcli -e list metriccurrent detail - cellcli -e list metrichistory detail - cellcli -e list physicaldisk detail - /opt/oracle/cell/cellsrv/deploy/config/cellinit.ora - /opt/oracle/cell/log/diag/asm/cell/*/trace/alert.log - /opt/oracle/cell/log/diag/asm/cell/*/trace/ms-odl.trc - ls -alt /opt/oracle/cell/log/diag/asm/cell/*/trace/
Leave a Reply