专栏首页杨建荣的学习笔记alert日志中出现ash size的警告

alert日志中出现ash size的警告

今天查看数据库的alert日志总出现了如下的警告。

Archived Log entry 202 added for thread 1 sequence 202 ID 0x1ed7a02c dest 1:
Sat Mar 15 01:37:30 2014
Completed checkpoint up to RBA [0xca.2.10], SCN: 267711453
Sat Mar 15 01:44:58 2014
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 67108864 bytes. Both ASH size and the total number of emergency flushe
s since instance startup can be monitored by running the following query:
 select total_size,awr_flush_emergency_count from v$ash_info;
Sat Mar 15 01:45:00 2014
Beginning log switch checkpoint up to RBA [0xcc.2.10], SCN: 270149004
Thread 1 advanced to log sequence 204 (LGWR switch)
  Current log# 4 seq# 204 mem# 0: /TEST1/db03/oradata/PRDTEST1/redo_g4_m1.dbf
  Current log# 4 seq# 204 mem# 1: /TEST1/db04/oradata/PRDTEST1/redo_g4_m2.dbf
Sat Mar 15 01:45:11 2014

ash的size大小设置是隐含参数_ash_size中设置的。查看metalink(文档 ID 1385872.1)

CAUSE

Typically some activity on system causes more active sessions, therefore filling the ASH buffers faster than usual causing this message to be displayed. It is not a problem per se, just indicates the buffers might need to be increased to support peak activity on the database.

SOLUTION

The current ASH size is displayed in the message in the alert log, or can be found using the following SQL statement.

select total_size from v$ash_info;

Then increase the value for _ash_size by some value, like 50% more than what is currently allocated. For example if total_size = 16MB, then an increase of 50% more would be (16MB + (16MB * 50%)) = 24MB.

sqlplus / as sysdba alter system set "_ash_size"=25165824;

You can verify the change using the following select:

select total_size from v$ash_info;

本文分享自微信公众号 - 杨建荣的学习笔记(jianrong-notes),作者:笔记16天

原文出处及转载信息见文内详细说明,如有侵权,请联系 yunjia_community@tencent.com 删除。

原始发表时间:2014-03-19

本文参与腾讯云自媒体分享计划,欢迎正在阅读的你也加入,一起分享。

我来说两句

0 条评论
登录 后参与评论

相关文章

  • 关于db_files和maxdatafiles的问题(r4笔记第31天)

    昨天在做生产监控的时候发现有个库的表空间不够了,就发邮件给客户的dba去处理,但是得到的反馈是尝试添加的时候发现已经超过了数据文件的最大数限制。这个错误毫无疑问...

    jeanron100
  • 探究AWR 第一篇

    statspack相比awr算是比较通用,而且免费,可以在标准版,企业版中使用,awr是新企业版本中才有的,算是statspack的一个升级版,而且代码不公开。...

    jeanron100
  • merge语句导致的性能问题紧急优化 (r9笔记第85天)

    晚上正在休息的时候,突然收到一封报警邮件。 报警内容: CPU utilization is too high ------------------------...

    jeanron100
  • 利用pytorch实现GAN(生成对抗网络)-MNIST图像-cs231n-assignment3

    In 2014, Goodfellow et al. presented a method for training generative models cal...

    OLDPAN
  • 为联合调度带来线程间缓存的好处-扩展结果和技术报告(CS OS)

    基于有向无环图(DAGs)的硬实时任务多处理器调度利用了该模型固有的并行性。对于DAG任务,节点表示在一个可用处理器上执行一个对象的请求。在一个DAG任务中,可...

    非过度曝光
  • NGINX Server Push服务器推送

    Support for HTTP/2 server push is also included in NGINX Plus R15.

    javascript.shop
  • 有趣的应用 | 使用RNN预测股票价格系列一

    01 概述 我们将解释如何建立一个有LSTM单元的RNN模型来预测S&P500指数的价格。 数据集可以从Yahoo!下载。 在例子中,使用了从1950年1月3日...

    用户1332428
  • 卷积神经网络第四周作业2: Art Generation with Neural Style Transfer - v1

    Welcome to the second assignment of this week. In this assignment, you will lear...

    Steve Wang
  • 【翻译】在Visual Studio中使用Asp.Net Core MVC创建第一个Web Api应用(二)

    运行应用 In Visual Studio, press CTRL+F5 to launch the app. Visual Studio launches a...

    脑洞的蜂蜜
  • 聊聊flink StreamOperator的initializeState方法

    本文主要研究一下flink StreamOperator的initializeState方法

    codecraft

扫码关注云+社区

领取腾讯云代金券