Operating System - HP-UX
1748156 Members
3914 Online
108758 Solutions
New Discussion юеВ

Oracle 8.1.7 32b and 9i 64b

 
SOLVED
Go to solution
P. Overduin
Advisor

Oracle 8.1.7 32b and 9i 64b

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?
8 REPLIES 8
Steven E. Protter
Exalted Contributor

Re: Oracle 8.1.7 32b and 9i 64b

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
MANOJ SRIVASTAVA
Honored Contributor

Re: Oracle 8.1.7 32b and 9i 64b

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
Stan_17
Valued Contributor
Solution

Re: Oracle 8.1.7 32b and 9i 64b

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
Stan_17
Valued Contributor

Re: Oracle 8.1.7 32b and 9i 64b

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

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
Ravi_8
Honored Contributor

Re: Oracle 8.1.7 32b and 9i 64b

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
never give up
TwoProc
Honored Contributor

Re: Oracle 8.1.7 32b and 9i 64b

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.
We are the people our parents warned us about --Jimmy Buffett
Steven E. Protter
Exalted Contributor

Re: Oracle 8.1.7 32b and 9i 64b

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

Attached.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com