Focus On Oracle

Installing, Backup & Recovery, Performance Tuning,
Troubleshooting, Upgrading, Patching, Zero-Downtime Upgrade, GoldenGate

Oracle Exadata ,Oracle ODA, Oracle ZDLRA


当前位置: 首页 » 技术文章 » 性能优化

ExaWatcher Charts

OSWatcher工具包含了一系列UNIX shell脚本,主要用于收集操作系统及网络等信息,用来诊断因为操作系统资源问题导致的性能问题。在Exadata上可以使用ExaWatcher诊断工具,她是专门针对Exadata数据库云平台而重新设计的,加入了IB网络网络的监控、LGWR、RDS、MegaRaid等模块。当出现性能问题时,找到这个时间点,可然后以通过GetExaWatcherResults来收集日志信息,在12.2.0.1中还会生成图表格式。ExaWatcher会自动调用维护模块ExaWatcherCleanup确保其磁盘空间使用维持在特定值以下。




GetExaWatcherResults帮助信息

[root@dm06dbadm01 oracle.ExaWatcher]# ./GetExaWatcherResults.sh --help
[INFO     ] "--help" option detected, GetExaWatcherResults will display the help information.
    All the other command line inputs will be ignored.

GetExaWatcherResults.sh is a convenient script to collect a specific set of
ExaWatcher data files.

Usage:
  ./GetExaWatcherResults.sh {--from <FromTime> [--to <ToTime>] |
                             --at <AtTime> [--range <Hours>]}
                             [--archivedir <ArchiveDir>]
                             [--scp        <RemoteTarget>]
                             [--filter     <FilterPhrase>]
                             [--resultdir  <ResultDir>]

  Notes on specifying timestamps:
  *  <FromTime>, <ToTime>, and <AtTime> need to be specified in a time format
     that can be parsed by \'date -d\'.

  *  To avoid using double quotes, replace space characters in the timestamps
     with the underscore character "_".

Options:
  [-h|--help] Print this usage message.

  [-f|--from] <FromTime>
    The start time and date for data file collection. Data files modified
    on or after <FromTime> are collected.
    * You need to specify either the --from option or the --at option.
    Example: --from 02/25/2012_00:00:00

  [-t|--to] <ToTime>
    The end time and date for data file collection. Data files modified
    before <ToTime> are collected.
    This option is optional.
    Default value: the current time.
    Example: --to 2012-06-16_12:12:12

  [-a|--at] <AtTime>
    The time and date for data file collection. This option is used with
    the --range option.
    * You need to specify either the --from option or the --at option.
    Example: --at 02/25/2012_00:00:00

  [-r|--range] <Hours>
    The time range in hours for data file collection. Data files modified
    between [<AtTime> - <Hours>,<AtTime> + <Hours>] will be collected.
    <Hours> is a positive integer.
    Default value: 2 hours.
    Example: --range 5

  [-l|--filter] <FilterPhrase>
    Only the files whose names contain <FilterPhrase> will be collected.
    Only a single <FilterPhrase> can be specified at a time.
    <FilterPhrase> is case sensitive.
    Example: `-l "Iostat"` will collect Iostat results only.

  [-c|--scp] <RemoteTarget>
    The collected data files will be copied to <RemoteTarget>.
    The format for <RemoteTarget> is: <User>@<ServerName>:<Directory>.
    The system may prompt for <User>'s password when using this option.
    The extracted local data files are deleted.
    Example: --scp root@adczascel02:/var/log/cellos/ExaWatcherResults

  [-d|--archivedir] <ArchiveDir>
    <ArchiveDir> specifies the source directory, that is, the directory
    from which to collect the ExaWatcher data files. If the specified directory
    does not exist, this script warns the user and exits.
    Default value: "/opt/oracle.ExaWatcher/archive"
    Example: --archivedir "/opt/oracle.ExaWatcher/ExaWatcherResults"

  [-s|--resultdir] <ResultDir>
    The local directory to place the collected data files. The
    default location of <ResultDir> is the archive directory.
    Default value: "/opt/oracle.ExaWatcher/archive"
    Example: --resultdir "/opt/oracle.ExaWatcher/ExaWatcherResults_Extracted"
[root@dm06dbadm01 oracle.ExaWatcher]#
[root@dm06dbadm01 oracle.ExaWatcher]#
收集日志
[root@dm06dbadm01 oracle.ExaWatcher]# ./GetExaWatcherResults.sh --from 2016-12-18_13:00:00 --to 2016-12-21_23:00:00
[INFO     ] Result files which are modified after 2017-08-18 13:00:00 and before 2017-08-21 23:00:00 are extracted in a zipped package in /opt/oracle.ExaWatcher/archive/ExtractedResults.
[root@dm06dbadm01 oracle.ExaWatcher]#  ./GetExaWatcherResults.sh --at 2016-12-21_21:00:00 --range 2
[INFO     ] Result files which are modified at around (~2 hours before and after) time point 2017-08-21 21:00:00 are extracted in a zipped package in /opt/oracle.ExaWatcher/archive/ExtractedResults.
[root@dm06dbadm01 oracle.ExaWatcher]#

Reference

http://docs.oracle.com/cd/E80920_01/DBMSO/exadata-whatsnew.htm#DBMSO-GUID-7FB3FBD8-6ADF-4F2F-94A2-92C105685E4C
http://docs.oracle.com/cd/E80920_01/DBMMN/exadata-general-maintenance.htm#DBMMN-GUID-5AEB3139-333D-453F-91D6-8EB09CB6E6EB

关键词:monitor exadata 

相关文章

Exadata exafusion参数在不同版本的变化
19c新特性之实时统计信息收集
Oracle Exadata x8m-2的更新
Oracle Exadata十年
Oracle Exadata x8-2的更新
终于等到你,Oracle 19c真的来了
useful mos note for exadata
Exadata最权威最完整的学习资料
Exadata上收集Cell节点的日志
Exadata上如何重置Cell节点root密码当你忘记时
Oracle性能加速之Write-Back Flash Cache
Exadata and ASM
Top