We're considering putting an Oracle (9i) instance in a separate memory
window on HP-UX 11.00 to get over the 1.75Gb (32-bit) shared memory
limit.

This looks easy to set up, but I can't find a positive confirmation
that clients of the instance need *not* be in the same window - we
would have a mixture of SQLJ and Pro*C clients running.

Does anyone know whether you can have instances and their clients in
separate memory windows?

Cheers,
-nick

nick.battle@gmail.com wrote:
> We're considering putting an Oracle (9i) instance in a separate
memory
> window on HP-UX 11.00 to get over the 1.75Gb (32-bit) shared memory
> limit.
>
> This looks easy to set up, but I can't find a positive confirmation
> that clients of the instance need *not* be in the same window - we
> would have a mixture of SQLJ and Pro*C clients running.
>
> Does anyone know whether you can have instances and their clients in
> separate memory windows?

This shared memory is for the server only. There are several Oracle
server processes that need to intercommunicate. The server and client
communicate via a protocol such as BEQ or TCP. If you have clients
using Gb of memory, there is something wrong.

You might check the Oracle certification matrix to see that only 64-bit
Oracle is supported for 9i on hp-ux. That memory window stuff is
irrelevant in 64-bit oracle. There are 32-bit libraries for linking to
if your clients need it.

When you install the hp-ux OS, if your hardware allows a particular
number of bits it gives you the option to install it, but if it
doesn't, you don't get the option. So I take it you are on an old K or
T? There used to be a matrix on hp.com that showed which boxes run
which bits, but I couldn't find it just now.

The chatr command on the oracle executable, once it is installed, can
be enlightening.

jg
--
@home.com is bogus.
'But hey, I'm making the best of the situation. I wrote my
own tools, and as usual (conceited bastard that I am), I
named the new project after myself: "git".' - Linus Torvalds

Joel Garry wrote:
> You might check the Oracle certification matrix to see that only 64-bit
> Oracle is supported for 9i on hp-ux. That memory window stuff is
> irrelevant in 64-bit oracle. There are 32-bit libraries for linking to
> if your clients need it.

Ah! That would make all this irrelevant, as you say. Sorry, I should
have checked this first.

Thanks for the pointers.

--
Cheers,
-nick