Re: Oracle with HP-UX memory windows

nick.battle_at_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