Re: Oracle Parallel Server implementation questions

Answers embedded

Hth,

Sybrand Bakker, Senior Oracle DBA

"tony sheng" <tonys_at_csee.umbc.edu> wrote in message news:aa15d4ec.0108061123.6bda30b2_at_posting.google.com...
> Hi everyone,
>
> I have recently been asked to implement Oracle Parallel Server.
> I am an ex-Sybase DBA and little knowledge about Oracle,
> but figured this would certainly be a fun experience...
>
> Anyway, I have a few questions about implementation:
>
> 1. Tips on administration?
> is this much more difficult than Oracle without the
> parallel option?

No

You will need to assign public rollback segments though, make sure each instance still has some private rollback segments. If you are forced to perform recovery, remember to recover *both* instances.

>
> 2. disk layout and user activity?
> i take it being careful how you layout the disks,
> objects, etc. is important.
> is oracle pretty good about managing multiple
> instances trying to write to the same disks?
> can you monitor how much thrashing is going on to the
> same disk?
>

The operative word here is many OPS implementation on Unixes force you to use RAW filesystems (ie non-cooked)
This doesn't apply however, AFAIK, to NT and OpenVMS
> 3. any other best practices or big caveats?
>
> thanks in advance,
> tony
Received on Mon Aug 06 2001 - 14:59:06 CDT