Script:收集Exadata诊断信息

最新推荐文章于 2024-10-14 22:42:36 发布

weixin_34301307

最新推荐文章于 2024-10-14 22:42:36 发布

阅读量97

点赞数

文章标签：数据库

原文链接：https://yq.aliyun.com/articles/523502

版权

以下汇总的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/

本文转自maclean_007 51CTO博客，原文链接:http://blog.51cto.com/maclean/1278246