473,403 Members | 2,354 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,403 software developers and data experts.

LGWR and ARCH

What is the relationship between LGWR and ARCH?
Jan 30 '07 #1
2 4286
What is the relationship between LGWR and ARCH?

LGWR and ARCH both are background process using for media recovery purposes.

LGWR is used to write from log buffer to redo log files. max 1 process v can set.

ARCH is used to move redo information from redo log file to archive log destination. max 10 process v can set
Oct 23 '07 #2
amitpatel66
2,367 Expert 2GB
What is the relationship between LGWR and ARCH?

More on LGWR:

1. Writes When there is a COMMIT
2. When Redo Log Buffer is one-third full or more than 1 MB
3. Before DBW0 writes
Oct 23 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Gustavo Córdova Avila | last post by:
Does anybody have an Arch archive with the current python source I could slurp it from? Thanks in advance :-) -- Gustavo Córdova Avila <gustavo.cordova@q-voz.com>...
1
by: Hari Om | last post by:
I am using Oracle 9.2.0.1 on my IBM AIX 5.1L System. I have a DB instance "prod" running on it for TESTING purposes. I have set the DB to ARCHIVELOG Mode and the archive destination to...
2
by: scott | last post by:
Hi, Does anyone know if i can upgrade: FROM: VISUAL STUDIO .NET ENTERPRISE ARCHITECT EDITION TO: Microsoft MS Visual Studio .NET Professional 2003 - Upgrade package
3
by: TedGrier | last post by:
My PC is a mess and I need to start clean. I am trying to uninstall the original version of .NET Enterprise Architect but the wizard insists How on the orginal disc which I do not have. How do I...
0
by: S Stone | last post by:
Visual Studio is unable to display the XSD for editing. When I attempt to open one from the solution explorer, part of the editing surface attempts to display the XSD but it never fully repaints...
3
by: nightolo | last post by:
Hi all, after all I have to say that I'm not a native english speaker so I pray you to excuse for my poor english. I got a trouble writing an application in a powerpc enviroment, that's the...
3
by: Benny | last post by:
Hi When I load a dataset with data obtained from a db, the dataset is stored in the memory of the client system. AFAIK the size of the dataset (which implicitly mean the number of rows that can be...
1
by: Dr. Paul Caesar - CoullByte (UK) Limited | last post by:
Hi all, Something weird is going on and has been for some time so I have decided to get some help! I have Windows Server 2003, Enterprise Edition with Service Pack 1. Installed is IIS 6 and...
22
by: nd02tsk | last post by:
Hello! I have a couple of final ( I hope, for your sake ) questions regarding PostgreSQL. I understand PostgreSQL uses processes rather than threads. I found this statement in the archives: ...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.