topic Re: Oracle Redo logs processes in Operating System - HP-UX

Oracle Redo logs processes

Sanjay Verma — Wed, 06 Aug 2003 04:22:35 GMT

Hi Friends,
I've noticed that my system has redo log processes running as below:

$: ps -ef | grep -i rc
oracle 27956 1 0 Jun 1 ? 5:01 ora_arc0_DB1
oracle 4688 1 0 Jul 10 ? 0:00 ora_arc1_DB1

As I understand, the processes are spawned automatically but in this case, I can see that the active time for the second process is "0.00" always. Is that a runaway process or normal to the system?

Re: Oracle Redo logs processes

Steven E. Protter — Wed, 06 Aug 2003 04:31:43 GMT

These are archive log proceses.

If you have the database in archive log mode, there should be some activity.

If archive log mode is on and they are being created, there is nothing to worry about. If you let the database run long enough, you'll eventually get some cpu time.

I suspect the database is not in archive log mode.

Lets check it.

su - oracle # the user that owns the database binaries.

sqlplus internal
select * from v$database;

It indicates the mode the database is in.

SEP

Re: Oracle Redo logs processes

malay boy — Wed, 06 Aug 2003 04:34:37 GMT

Hi,

This is not redolog process but achiver process.

I guest you set the log_archive_max_process=2 in oracle init.ora file.

It means that oracle will start two archiver upon instance start even though you only need one(due to low activity).

And this is not a running process.

regards
mB

Re: Oracle Redo logs processes

malay boy — Wed, 06 Aug 2003 04:36:43 GMT

Re: Oracle Redo logs processes

malay boy — Wed, 06 Aug 2003 04:38:42 GMT

Re: Oracle Redo logs processes

malay boy — Wed, 06 Aug 2003 04:39:03 GMT

Re: Oracle Redo logs processes

malay boy — Wed, 06 Aug 2003 04:39:51 GMT

Re: Oracle Redo logs processes

malay boy — Wed, 06 Aug 2003 04:40:39 GMT

Re: Oracle Redo logs processes

malay boy — Wed, 06 Aug 2003 04:43:10 GMT

Re: Oracle Redo logs processes

malay boy — Wed, 06 Aug 2003 04:45:17 GMT

Re: Oracle Redo logs processes

malay boy — Wed, 06 Aug 2003 04:47:34 GMT

Re: Oracle Redo logs processes

malay boy — Wed, 06 Aug 2003 04:49:43 GMT

Re: Oracle Redo logs processes

malay boy — Wed, 06 Aug 2003 04:55:53 GMT

wow!!! so many reply from me.Sorry guy's my IE browser just back from lunch.That's why a bit wacko.

regards
mB

Re: Oracle Redo logs processes

Sanjay Verma — Wed, 06 Aug 2003 05:02:18 GMT

Hi Steven/Malay,
As you can see, it's "0:00" since Jul10. Is that of any concern?

Re: Oracle Redo logs processes

T G Manikandan — Wed, 06 Aug 2003 05:06:30 GMT

you have specified multiple archiver processes which should be helpful for archiving to multiple destinations.

For example if you are archiving the files to multiple destinations then the single process cannot take that load or it should do the task simultaneously.

Re: Oracle Redo logs processes

twang — Wed, 06 Aug 2003 05:09:03 GMT

Since Oracle 8i supports multiple archive destinations it also supports multiple archiver processes to ease the load on a single archiver.
LOG_ARCHIVE_MAX_PROCESSES specifies the number of ARCH processes to be invoked.
This value is evaluated at instance startup if the LOG_ARCHIVE_START initialization parameter has the value TRUE. If the LOG_ARCHIVE_START is true and LOG_ARCHIVE_MAX_PROCESSES is not set explicitly it will start the arc0 process. Otherwise if LOG_ARCHIVE_MAX_PROCESSES is explicitly set to a value (range 1-10) then it will start additional archiver processes named arc0, arc1, arc2 . . . . . etc. There is no need to change this parameter from its default value of 1, because the system determines how many ARCn processes are needed and LGWR automatically starts up more ARCn processes when the database workload requires more.

If LOG_ARCHIVE_START is set to true, Oracle starts up a single archiver
process names ARC0. Subsequently if the parameter is changed using the ALTER
SYSTEM command it will start the specified number of archive processes. For
example:
SVRMGRL>alter system set LOG_ARCHIVE_MAX_PROCESSES=4;
will invoke additional processes ARC1 , ARC2 and ARC3, I guess the ora_arc1_DB1 is started then.

Re: Oracle Redo logs processes

malay boy — Wed, 06 Aug 2003 05:10:39 GMT

Hi,
If it was me.I would'nt worry to much.But may I know what is your LOG_ARCHIVE_MAX_PROCESSES parameter in init.ora file or you can run below sql :

select name,value from v$parameter where name like '%log%archive%max%'

select * from v$database;

regards
mB

Re: Oracle Redo logs processes

T G Manikandan — Wed, 06 Aug 2003 05:11:56 GMT

This should not worry you!

Also,this is done by the LGWR
which automatically spawns processes for more load.

This happens also when the log switches are happening at a faster rate.

The parameter setting LOG_ARCHIVE_MAX_PROCESSES in init.ora file is the initial amount of processes to be started.

Re: Oracle Redo logs processes

Alexander M. Ermes — Wed, 06 Aug 2003 05:14:32 GMT

Hi there.
I think, there is a parameter in the init.ora
activated called 'LOG_ARCHIVE_MAX_PROCESSES'.

You can check it with the query on v$archive_processes. It should show the arc1 as idle.

These multiple archive processes come in handy, if you have several redo logs to archive. If the change goes fast, one process can handle the first log and so on.
This helps with your performance.
If you have the Oracle online documnetation, look for this :

file:///disk/doc/server.817/a76956/archredo.htm#12156

If you need more info, let us know.
Rgds
Alexander M. Ermes

Re: Oracle Redo logs processes

malay boy — Wed, 06 Aug 2003 05:20:53 GMT

Alex,
Yap you are the guru.here are the result from our development database :

SQL> select * from v$archive_processes;

PROCESS STATUS LOG_SEQUENCE STAT
---------- ---------- ------------ ----
0 STOPPED 0 IDLE
1 STOPPED 0 IDLE
2 STOPPED 0 IDLE
3 STOPPED 0 IDLE
4 STOPPED 0 IDLE
5 STOPPED 0 IDLE
6 STOPPED 0 IDLE
7 STOPPED 0 IDLE
8 STOPPED 0 IDLE
9 STOPPED 0 IDLE

10 rows selected.

I guest in your case you will see 2 process with status running and stat for one of them are idle.

In my case,all the arc process are not running that's why it showed all stopped.

regards
mB