• Active Session History (ASH) performed an emergency flush


    Active Session History (ASH) performed an emergency flush. This may mean that ASH is undersized. If emergency flushes are a recurring issue, you may consider increasing ASH size by setting the value of _ASH_SIZE to a sufficiently large value. Currently, ASH size is 4194304 bytes. Both ASH size and the total number of emergency flushes since instance startup can be monitored by running the following query:
    
    SQL> select total_size,awr_flush_emergency_count from v$ash_info;
    
    TOTAL_SIZE AWR_FLUSH_EMERGENCY_COUNT
    ---------- -------------------------
       4194304                         1
    
    SQL> select * from v$ash_info;
    
    TOTAL_SIZE FIXED_SIZE SAMPLING_INTERVAL OLDEST_SAMPLE_ID OLDEST_SAMPLE_TIME                                                          LATEST_SAMPLE_ID
    ---------- ---------- ----------------- ---------------- --------------------------------------------------------------------------- ----------------
    LATEST_SAMPLE_TIME                                                          SAMPLE_COUNT SAMPLED_BYTES SAMPLER_ELAPSED_TIME DISK_FILTER_RATIO
    --------------------------------------------------------------------------- ------------ ------------- -------------------- -----------------
    AWR_FLUSH_BYTES AWR_FLUSH_ELAPSED_TIME AWR_FLUSH_COUNT AWR_FLUSH_EMERGENCY_COUNT
    --------------- ---------------------- --------------- -------------------------
       4194304    4194304              1000          1168516 18-JUN-11 05.06.33.163000000 AM                                                      1490473
    21-JUN-11 10.40.34.688000000 PM                                                     9257       3104088              2883663                10
            2764680                 557774               1                         1
    
    
    This issue can be ignored.
  • 相关阅读:
    prometheus监控zookeeper
    prometheus监控mongo
    python游戏练手--乒乓球
    python游戏练手--贪吃蛇
    python爬虫练手--糗事百科图片获取
    Prometheus监控安装及使用(一)
    善用k8s explain
    k8s deployment
    k8s pod
    k8s deployment 金丝雀发布 更新的 暂停 恢复 回滚
  • 原文地址:https://www.cnblogs.com/macleanoracle/p/2967284.html
Copyright © 2020-2023  润新知