Hello Gurus and Gurettes:

A while back, I asked what the impact would be of
increasing the SESSIONS parameter on a database. We
doubled it with no problems, except . . . we neglected
to also increase the PROCESSES parameter, so we're
running into errors where Oracle maxes out on
processes. We're going to bounce the db to fix this.

BUT!

In the meantime, we've identified what is spawning all
of the extra processes - RMAN. We backup to disk
around 12:30 AM, and we allocate multiple channels.
Our processes error was happening around 1:15 AM every
morning, so we moved the backups to 3:00 AM. And
guess what . . . the error moved to around 3:40 AM,
too.

So, my question is, how many processes does each RMAN
channel allocate? Is there a way to control/limit
this, other than using fewer channels? Or should we
just up the PROCESSES parameter and let RMAN have its
way?

Thanks so much for your help,


Brian Mays
Padawan DBA

Oracle LazyDBA home page