基本信息
源码名称：Exadata_Health_and_Resource_Usage_Monitoring_v10.pdf
源码大小：12.48M
文件格式：.pdf
开发语言：SQL
更新时间：2020-10-15
   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：813200300

本次赞助数额为： 2 元　
   源码介绍 

Table of Contents
Introduction ..................................................................................................................................................................... 4
Methodology ................................................................................................................................................................... 4
Steps to follow before problems occur ............................................................................................................................ 5
Exachk ........................................................................................................................................................................ 5
AWR Baselines .......................................................................................................................................................... 7
Static Baselines .......................................................................................................................................................... 7
Moving Baselines ....................................................................................................................................................... 9
Configuration File Copies ......................................................................................................................................... 10
Tunable Parameters Snapshots ............................................................................................................................... 10
How to configure DB parameters ............................................................................................................................. 11
I/O Resource Manager ............................................................................................................................................. 12
Enterprise Manager Exadata Resource Management ............................................................................................. 13
Setting limits ............................................................................................................................................................. 15
Database Metrics ..................................................................................................................................................... 15
Configure HugePages .............................................................................................................................................. 16
Configure consolidated environments ...................................................................................................................... 16
Initial quick checks to perform ...................................................................................................................................... 17
Component Up ......................................................................................................................................................... 17
Incident Manager ...................................................................................................................................................... 19
Alert Log ................................................................................................................................................................... 21
OS System Log ........................................................................................................................................................ 23
CPU Utilization ......................................................................................................................................................... 23
Examine TOP kswapd .............................................................................................................................................. 25
Memory Utilization .................................................................................................................................................... 26
Examine VMSTAT .................................................................................................................................................... 28
ILOM Events ............................................................................................................................................................. 28
Network Status ......................................................................................................................................................... 31
Disk Status ............................................................................................................................................................... 31
CheckHWnFWProfile ............................................................................................................................................... 32
Services .................................................................................................................................................................... 33
Database Free Buffer Waits ..................................................................................................................................... 34
Exachk ...................................................................................................................................................................... 34
Have Changes Occurred in the Environment? ............................................................................................................. 35
Use baseline data to troubleshoot issues ..................................................................................................................... 35
Compare Configuration Files .................................................................................................................................... 35
Checking changes to the kernel tunable parameters ............................................................................................... 36
3 | EXADATA HEALTH AND RESOURCE USAGE MONITORING
AWR Data ................................................................................................................................................................ 36
Advanced Diagnostics .................................................................................................................................................. 38
Hardware Rule out ................................................................................................................................................... 39
Check if Compute node is CPU bound ..................................................................................................................... 40
I/O Performance ....................................................................................................................................................... 41
How to analyze Cell DB HDD I/O metrics ................................................................................................................ 49
Next Steps ................................................................................................................................................................ 54
If Cells nodes are I/O bound ..................................................................................................................................... 54
If Compute node is CPU or memory bound ............................................................................................................. 55
If Cell server is not I/O bound and Compute nodes are not CPU/memory bound .................................................... 55
Cell server Target Page ........................................................................................................................................... 55
Exadata Cell Performance View ............................................................................................................................... 56
File System Information ............................................................................................................................................ 57
Common Performance use cases ............................................................................................................................ 58
Tune TOP SQLs for DW ........................................................................................................................................... 62
Database Diagnostic Tools ........................................................................................................................................... 63
ADDM ....................................................................................................................................................................... 63
Database Top Activity Page ..................................................................................................................................... 64
AWR Reports ........................................................................................................................................................... 65
New features in Exadata Plug-in 12.1.0.6 .................................................................................................................... 69
Summary ...................................................................................................................................................................... 73
References ................................................................................................................................................................... 74
Appendices ................................................................................................................................................................... 75