We have a couple of independent applications running over the same instance
now (it's better to do it because our resources cant' support two instances
over the same machine), we think if we use parallel server, we can make
partition of this applications, one for each node or someting like that...
And, of course, we are thinking about automatic failover and high
availability over parallel server...
--
Fernando O. Papa
DBA
El Sitio - Infraestructura
(54-11) 4339-3854
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Rachel
Carmichael
Enviado el: miƩrcoles, 30 de mayo de 2001 23:50
Para: Multiple recipients of list ORACLE-L
Asunto: Re:About parallel server
Even more importantly, if you are planning on implementing
parallel server
just to increase your processing power then you are going to be in
trouble!
If you haven't specifically designed your application for
parallel server,
you can end up DECREASING performance by increasing locking and pings.
This is not something you do lightly once an app has been
installed into
production.
Rachel
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re:About parallel server
Date: Wed, 30 May 2001 14:48:03 -0800
Fernando,
Replies included in your original mail, but in addition:
Parallel server is a separately priced option from
Oracle and it is
pricey.
Second you may need specific software from you OS vendor to
coordinate the
file
sharing between the servers, again an additional expense.
Dick Goulet
Reply Separator
Author: Fernando Papa [EMAIL PROTECTED]
Date: 5/30/2001 2:07 PM
Hi everybody!
I have some questions about parallel server. Now we have
only one instance
stand-alone (no parallel), but we are thinking to switch
to parallel
server because we have a couple of sparc 3500 and nobody are
using it, and
we think it's good for increase our processing power.
The problem is I didn't work with parallel server and I have a lot of
questions about it:
1) Is mandatory to use raw devices for control files, redo
logs data
files?
-- Data files yes, redo and control files can be on cooked
file system.
2) How we transfer our cooked data files to raw devices data files?
import/export? or exist another better (fast) method?
-- To the best of my knowledge your going to have to
rebuild the database
from
scratch so imp/exp is your only option.
3) If I start with only one node, performance will be the
same of one
single
instance (no parallel)?
-- Yes and NO, raw devices run a little faster than cooked
files since the
OS's
buffer cache is not in the middle.
4) Somebody know how to work with raw devices under solaris?
any link? I
try
to found someting in metalink but there's no samples...
-- Working with raw devices is very different from cooked
file systems.
If you
don't have an experienced Unix admin you could be in serious trouble.
5) What about backup? I can't put tablespaces in backup mode
and copy with
cp... maybe it's time to use rman?
-- Rman can handle the backups, but a file system level backup is
different.
CP does not work anymore, nor does fbackup, or tar. You'll need
specialized
software for the purpose.
Thanks in advance!
--
Fernando O. Papa
DBA
El Sitio - Infraestructura
(54-11) 4339-3854
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Fernando Papa
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access /
Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access /
Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com