db 10gr2,windows xp [message #484213] |
Mon, 29 November 2010 01:57 |
kamransagri
Messages: 13 Registered: May 2006 Location: india
|
Junior Member |
|
|
what is the impact of "processes" parameter on RMAN related to performance/resources.
kind regards,
|
|
|
|
|
|
Re: db 10gr2,windows xp [message #484371 is a reply to message #484297] |
Tue, 30 November 2010 01:25 |
kamransagri
Messages: 13 Registered: May 2006 Location: india
|
Junior Member |
|
|
I read in the oracle supplied documentation which is as under.
RMAN Usage Considerations
Before Recovery Manager is used, consider the following points:
Shared resources on the system:
Most of the work of RMAN is performed through Oracle database processes. The operations can also be performed in parallel to increase throughput. This implies that the PROCESSES database parameter must be sufficiently high.
For the operating systemresources, this means that shared memory and semaphore settings may need to be increased.
|
|
|
|
Re: db 10gr2,windows xp [message #484376 is a reply to message #484371] |
Tue, 30 November 2010 01:52 |
John Watson
Messages: 8960 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
RMAN performs backups through "channels": a channel is a server session, just like any other. So if you launch a backup job with ten channels, RMAN logs on ten times, creating ten sessions. Each session needs a process, so you need to be sure that the PROCESSES parameter (which limits the number of processes permitted) must be high enough to allow these sessions in addition to the usual workload. A related parameter is SESSIONS, you should read up on that, too.
Update: I just noticed that you are working on Windows, I think semaphores and shared memory are aoplicable only to Unix/Linux.
[Updated on: Tue, 30 November 2010 02:02] Report message to a moderator
|
|
|