| |
 |
|
Oracle Tips by Burleson Consulting
|
The archiver background
process (ARCH)
The ARCH background process is invoked when your database is running
in ARCHIVELOG mode. If you are archiving your redo logs, the redo
logs are touched by several background processes. First, the LGWR
process copies the log_buffer contents to the online redo log files,
and then the ARCH process copies the online redo log files to the
archived redo log filesystem on UNIX. The ARCH process commonly
offloads the most recent online redo log file whenever a log switch
operation occurs in Oracle. You can observe a log switch in the
Oracle alert log, and the online redo logs should be sized such that
you do not experience a log switch more than once every 15 minutes.
In UNIX, the ARCH process is I/O intensive and you can use top,
glance or watch to observe the ARCH process writing the data blocks
to the archived redo log file.
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
