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)

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

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

发表于

我来说两句

0 条评论
登录 后参与评论

相关文章

来自专栏小白的技术客栈

你不得不会的MarkDown

如何快速掌握MarkDown 好久没有更新内容了,也好久没有给大家打个招呼了,小白想死你们了。 Markdown显然已经成为每个IT人的标配了。如果不会点儿Ma...

3395
来自专栏程序员与猫

Log system architecture

Keywords: Collector, Processor, Aggregator

941
来自专栏宋凯伦的技术小栈

Android UsageStatsService(应用使用统计服务)的学习与调研

一. 简介 UsageStatsService是一个系统服务,其主要通过AMS等,来监测并记录各个应用的使用数据,如上次调用com.android.settin...

4995
来自专栏Kubernetes

Kubernetes 1.8抢占式调

Author: xidianwangtao@gmail.com 阅读本博文前,建议先阅读解析Kubernetes 1.8中的基于Pod优先级的抢占式调度...

43814
来自专栏张善友的专栏

How to Add an API to your Web Service

Introduction APIs are a great way to extend your application, build a community,...

2287
来自专栏宋凯伦的技术小栈

Android UsageStatsService(应用使用统计服务)的学习与调研

UsageStatsService是一个系统服务,其主要通过AMS等,来监测并记录各个应用的使用数据,如上次调用com.android.settings的时间等...

830
来自专栏WOLFRAM

用 Wolfram 语言来做2017年高考数学试题之新课标Ⅲ理科卷

1964
来自专栏张善友的专栏

Building a Middle Tier Component using NHibernate and Spring.NET

http://www.codeproject.com/csharp/SpringPlusHibernate.asp Download demo project ...

1887
来自专栏码匠的流水账

java9 gc log参数迁移

有如上三种,其中指定file的话,可以使用%p变量表示当前jvm的pid,用%t表示jvm的启动时间戳。比如

1001
来自专栏安富莱嵌入式技术分享

【RL-TCPnet网络教程】第5章 PHY芯片和STM32的MAC基础知识

本章节为大家讲解STM32自带的MAC和PHY芯片的基础知识,为下一章底层驱动的讲解做一个铺垫。

1333

扫码关注云+社区