Home » RDBMS Server » Backup & Recovery » db 10gr2,windows xp
db 10gr2,windows xp [message #484213] Mon, 29 November 2010 01:57 Go to next message
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 #484226 is a reply to message #484213] Mon, 29 November 2010 02:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which "processes" parameter?

Regards
Michel
Re: db 10gr2,windows xp [message #484287 is a reply to message #484226] Mon, 29 November 2010 06:22 Go to previous messageGo to next message
kamransagri
Messages: 13
Registered: May 2006
Location: india
Junior Member
there is processes parameter in the "initialization parameters" list in Enterprise Manager , about which i read that it has an impact on RMAN.
Re: db 10gr2,windows xp [message #484297 is a reply to message #484287] Mon, 29 November 2010 07:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Where did you read this?
How could we know that you correctly read and understood what you read if you don't post what you read.
Post a link to it.

Regards
Michel
Re: db 10gr2,windows xp [message #484371 is a reply to message #484297] Tue, 30 November 2010 01:25 Go to previous messageGo to next message
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 #484374 is a reply to message #484371] Tue, 30 November 2010 01:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, it must be sufficient high to support your workload AND rman processes.
Nothing about performances themselves.

Quote:
For the operating systemresources, this means that shared memory and semaphore settings may need to be increased.

They need to be configured for the number of processes you choose to have.

Regards
Michel
Re: db 10gr2,windows xp [message #484376 is a reply to message #484371] Tue, 30 November 2010 01:52 Go to previous message
John Watson
Messages: 8929
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

Previous Topic: Tablespace OFFLINE - Drop tables + clear UNDO&TEMPORARY - Tablespace ONLINE - HANGS! blocked by
Next Topic: flash recovery area
Goto Forum:
  


Current Time: Thu Apr 18 23:36:37 CDT 2024