dbi services: Database Infrastructure Services - Engineering, Implementation, Operation, Modernization

Tag: Redo log

dbi services Blog

Welcome to the dbi services Blog! This blog focuses on database infrastructure and middleware topics. It covers technologies such as Oracle, Microsoft SQL Server, MySQL, Sybase, Linux, or Documentum (etc.). The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on the postings!

Compression advisor: excessive redo log file generation

Thursday, 01 September 2011 Posted by Saïd Mendi Category Development & Performance 0 comment

Last week at a customer site, we experienced an excessive redo log generation rapidly filling up the FRA (Flash/Fast Recovery Area) with archivelog files. This eventually caused the database to crash.

Tags: dbms_scheduler, Segments, Troubleshooting, LOB, Oracle 11g, Redo log, Oracle support

Oracle Basics (1): Oracle Database vs Oracle Instance

Wednesday, 08 December 2010 Posted by David Hueber Category Database Administration & Monitoring 1 comment

While beginning to work with Oracle, one of the most common confusions is between Oracle Database and Oracle Instance. The term Oracle Database is mainly used to designate the whole Oracle RDBMS architecture. However, taking a closer look at Oracle RDBMS Server, we can see that it is composed of two entities, the Database and the Instance. What is really the difference between them? Let's find out.

Tags: Oracle instance, Data file, Controlfile, CKPT, PMON, SMON, Log buffer, Redo log, Buffer cache, LGW, ARC, DBW, Oracle 11g, Oracle 10g to 8i