Skip to content

datacartondotcom

inside data management

  • About

hidden

ORA-00494: enqueue [CF] held for too long crashes the database when the enqueue blocker is LGWR

November 4, 2014April 24, 2016 ~ datacarton ~ Leave a comment

Problem

en español
 
The Database crashed
 
This is what was found in the alert_SID.log

Mon Feb 24 14:35:49 2014
Errors in file /u01/app/oracle/diag/rdbms/oradb/oradb/trace/oradb_j002_30015710.trc  (incident=57308):
ORA-00494: enqueue [CF] held for too long (more than 900 seconds) by ‘inst 1, osid 40304748’

Continue reading →

ORA-00494: enqueue [CF] hace que el banco de datos se caiga cuando LGWR obstaculiza enqueue

November 4, 2014April 24, 2016 ~ datacarton ~ Leave a comment

Problema

in English

El banco de datos se calló.

Lo que fue encontrado en alert_SID.log
Mon Feb 24 14:35:49 2014
Errors in file /u01/app/oracle/diag/rdbms/oradb/oradb/trace/oradb_j002_30015710.trc  (incident=57308):
ORA-00494: enqueue [CF] held for too long (more than 900 seconds) by ‘inst 1, osid 40304748’

Continue reading →

Recent Posts

  • Hadoop
  • Clickstream data example
  • Oracle BDA (Big Data Appliance)
  • Flashback Database
  • Exadata Database Machine

Recent Comments

Oracle BDA (Big Data… on Clickstream data example
spbutterworth.com on Drop tablespace with partition…

Archives

  • August 2016
  • April 2016
  • November 2014
  • July 2014
  • February 2014
  • January 2014
  • December 2013

Categories

  • 11gR2
  • 12c
  • aix
  • asm
  • backup
  • bda
  • big data
  • block tracking
  • carrera
  • consejos
  • crash
  • data
  • data guard
  • datapump
  • english
  • español
  • exadata
  • export
  • fast recovery area
  • hadoop
  • hidden
  • http://schemas.google.com/blogger/2008/kind#post
  • import
  • inglés
  • oracle
  • parameter
  • partitioning
  • python
  • redo log
  • respaldo
  • script
  • scripting
  • sequence
  • spanish
  • Uncategorized
Blog at WordPress.com.