RMAN performance on CoolThreads Servers

From: Peter McLarty <peter.mclarty_at_pacificdbms.com.au>
Date: Wed, 02 Jan 2008 16:46:30 +1000
Message-Id: <1199256390.5617.18.camel@notebook5.pacificdbms.com.au>

Hi All

Happy New Year

I am looking after a Cool Threads Sun Server that is running 10G standard edition.
Oracle with Solaris 10
>From the point of view of database serving it seems to perform
reasonably well, Oracle DB being highly threaded, I would have expected that.

A thing I have found with these servers seems to be that a lot of tasks peripheral to the database serving such as backups and file compression is not very quick and this appears to be due to to the very nature of the cool threads servers, namely that the individual cores in these are relatively slow, in this case 300MHz.

Being that RMAN cannot run parallel processes (Standard Edition) so a backup cant run across say 4 threads, this leaves us to only use scripted backups of the old style. Our Backup is currently running a hot backup script that copies the database and archivelogs to a remote server from where it goes to tape

I would like to recommend the site upgrade to Enterprise to get parallel back capabilities in RMAN, but I doubt that they will take that idea on board.

Have others found these sorts of issues with the cool threads server family, or is there something wrong with the set up of this particular system, or does someone have a suggestion to make thing run faster, parallel execution of things comes to mind, but that is limited under shell scripts.
Can I run multiple instances of rman simultaneously? I can see a lot of reasons why that may potentially come unstuck.


Peter McLarty <peter.mclarty_at_pacificdbms.com.au>
Pacific DBMS Pty Ltd

Received on Wed Jan 02 2008 - 00:46:30 CST

Original text of this message