Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Migration and Modernization
E-Business Suite
PeopleSoft Enterprise
JD Edwards World
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums



General Questions

ASH emergency flush

Hello all,  We recently created a 11g database on Red Hat Linux 5 and are currently bechmarking our ETLs. I'm noticing the following message in the alert log quite often.  "Active Session History (ASH) performed an emergency flush"  I looked it up on metalink and the recommendation is to increase "_ash_size".   Listed below is the size on our server. Its 134 MB.  select total_size,awr_flush_emergency_count from v$ash_info;  TOTAL_SIZE             AWR_FLUSH_EMERGENCY_COUNT -------------------------  134217728              20                          Have you encountered this issue? Has anyone bumped up the size of the hidden parameter "_ash_size" to resolve this issue. I normally try to avoid setting hidden parameters as much as possible.  Thanks for your time.

I would suggest getting touch with Oracle support, confirming that yours is the same case as reported in the MOS document and then ask support only to provide a recommendation of value to be set.

Related Links

Multiple select staement in 1 query
Define percentage in dba_profile for cpu_per_session, cpu_per_call
ORA-28575: unable to open RPC connection to external procedure agent
Insert Into Select with APPEND hint
Client Needs SSO setup to access application *** oracle db..Need your help.
select data from undo tablespace?
Sadow process in oracle
disk vs tape
can not connect via URL to Oracle Enterprise Manager
Oracle: Monitoring_Out of the box Reports
patch download
Oracle client and tnsping
Multiple column update trigger
To auto-start Oracle database 10g on Linux
Issue during importing metadata for transportable tablespace
tkprof - how to read this o/p file