topic Re: Oracle 8.1.7 32b and 9i 64b in Operating System - HP-UX

Oracle 8.1.7 32b and 9i 64b

P. Overduin — Wed, 26 Feb 2003 12:38:28 GMT

Hi all,

I have a question concerning 32 and 64 bit Oracle databases.
We have a HP-UX 11.00 64bit, running Oracle 8.1.7 (32bit) and Oracle 9i (64bit). The 32 bit is limited to a max of 1,75Gb ram. The box has 2Gb. If there is a memoryproblem in the future, would it be usefull to add more ram? In other words, will the 64bit application use it? And would it have any consequenses for the 32bit application?

Re: Oracle 8.1.7 32b and 9i 64b

Steven E. Protter — Wed, 26 Feb 2003 16:44:45 GMT

Adding RAM is always a good thing.

Your system is a shared mulit-user system, so Oracle is never going to get all of the physical memory on a 2 G system.

If you double the memory, you'll increase resources for other non-oracle stuff, like writing to disks and such, improving performance.

If you add memory, the 64 Bit and 32 bit application will benefit.

I'd take a careful look at init.ora and make sure your resource allocation, SGA and all is realistic.

SEP

Re: Oracle 8.1.7 32b and 9i 64b

MANOJ SRIVASTAVA — Wed, 26 Feb 2003 16:53:51 GMT

There would not be any consequence on the 32 bit applications etc , however the addign RAM to a 2gb system will definately improve the performance . However a 23 bit oracle will continue working with the 1.75 GB limitation .

Manoj Srivastava

Re: Oracle 8.1.7 32b and 9i 64b

Stan_17 — Wed, 26 Feb 2003 17:53:57 GMT

Absolutely there won't be any consequences. Though SGA is limited to 1.75gb on 32 bit apps, you still can set sort_area_size or hash_area_size etc (8.1.7) or pga_aggregate_target (9i) accordingly to use the available memery to tune your queries, thereby improving performance.

-Stan

Re: Oracle 8.1.7 32b and 9i 64b

Stan_17 — Wed, 26 Feb 2003 17:58:35 GMT

Oops, forget to mention, be wary in setting up above mentioned parameters as they might lead to swapping which would be a performance killer.

Re: Oracle 8.1.7 32b and 9i 64b

Philippe Cussigh — Fri, 28 Feb 2003 11:44:33 GMT

As the 1.75 Gb memory limit is only a "soft" limit due to the way HPUX 32 is adressing shared memory :

- 64 bits will be able to using this RAM as the addresses used by 64 bits applications are not the same as for 32 bits applications.
(and oracle 32 bits limit will stay the same)

- If you have any application using private memory, it could use more that 1.75 Gb even with 32 bits.

So as everybody already explained it will reduce your swapping and increase your performance.

Philippe

Re: Oracle 8.1.7 32b and 9i 64b

Ravi_8 — Fri, 28 Feb 2003 11:59:53 GMT

Hi,

Oracle provided ability to build a 32-bit Oracle application on 64 bit OS.

so if 8.1.7 is running fine, there wouldn't be no problem with 9i

Re: Oracle 8.1.7 32b and 9i 64b

TwoProc — Fri, 28 Feb 2003 23:16:10 GMT

I'd suggest using the 64 bit database for the very reason that you're wanting - a bigger sga. I'm sure you'd like a bigger shared pool as well as more db_block_buffers to improve performance and caching. It's exactly what I have done for the above reasons. It's a good move to go to 64 bit. Don't look back.

Re: Oracle 8.1.7 32b and 9i 64b

Steven E. Protter — Tue, 04 Mar 2003 23:23:32 GMT

here is a 25 step Oracle migration document for migrating the database.

Attached.

SEP