- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle on 64bit UX vs 32bit Windows
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-31-2003 03:55 PM
тАО01-31-2003 03:55 PM
Oracle on 64bit UX vs 32bit Windows
Can anyone out there describe the advantages/disadvantages of running Oracle on 64bit UX vs 32bit win2000(In either general or detailed terms)???
i.e. SGA limitations on 32bit windows or advantages of threaded vs process architecture on windows?
Or perhaps you know of whitepapers or discussions of this comparison?
We're trying to make a decision on moving a database off win2000 to UX and I need some views, be they objective or subjective...
Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-31-2003 04:14 PM
тАО01-31-2003 04:14 PM
Re: Oracle on 64bit UX vs 32bit Windows
Well... you should get a lot of answers to this question...
In general, the disk I/O of HP-UX is superior to that of Windows. Also, CPU speed and memory capacity are significant factors in DB performance - and you can get a faster CPU and more memory in UX systems than you can get in Windows.
I think that by far, most people use UX or other unixes because it's more stable and provides better error recovery than Windows.
There are several other things you can point out that may or may not be limiting your performance on your Win2K, including backplane speed, bandwidth to memory, thread mechanisms (Windows does have threads), kernel performance, filesystem performance, memory management techniques, etc..
There's lots of things we can pick on in Windows. ;-}
I hope this helps!
Vince
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-31-2003 04:21 PM
тАО01-31-2003 04:21 PM
Re: Oracle on 64bit UX vs 32bit Windows
I'll give you the best advantage of all....
UPTIME !!!!!
You could keep an HP-UX / Oracle system up all year if you didn't have to patch it.
We only patch twice a year & in our clustered systems, we can still EASILY get >99.9% uptime - planned or unplanned outages combined.
You'll have a VERY hard time doing that with a Micro$oft OS.
Why anyone would put mission-critical apps on a M$ system is beyond me.
I won't even touch performance, security, etc.......
Rgds,
Jeff
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-31-2003 04:32 PM
тАО01-31-2003 04:32 PM
Re: Oracle on 64bit UX vs 32bit Windows
Besides the advantage of uptime in HP-UX box, you have the economic advantage because normally a Windows 2000 box use more CPU than UNIX box. Oracle database is licensed in a per CPU basis, so, in Windows 2000 you will have a more expensive cost.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2003 01:00 AM
тАО02-01-2003 01:00 AM
Re: Oracle on 64bit UX vs 32bit Windows
Hi,
You'll gain a lot with UNIX:
- stability
- better memory management (efficient)
- long uptime
- availability
- scalability
and more.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2003 02:29 AM
тАО02-01-2003 02:29 AM
Re: Oracle on 64bit UX vs 32bit Windows
Thanks!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2003 05:57 AM
тАО02-01-2003 05:57 AM
Re: Oracle on 64bit UX vs 32bit Windows
A win32 process can address up to 2 GB, so you can have process+SGA=2 GB.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-02-2003 10:44 AM
тАО02-02-2003 10:44 AM
Re: Oracle on 64bit UX vs 32bit Windows
even though there is a version of Windows permitting up to 3GB of RAM dedicated/usable for one process (Enterprise Server or so), with UNIX and 64bit you can use as much RAM as you can pay for - like dozens of GB of RAM!
Then on Windows a single process can occupy the CPU for y long, long time, but the UNIX process scheduler is much "fairer" there - and you can have many more CPUs on UNIXs.
Then there are still problems with M$'s implementation of TCP/IP (how did your clients connect to the instance?), you can have a local firewall by running "IPFilter/9000", much better than what M$ delivers on W2K (W2003 Server is not here, yet, is it?).
Then the whole I/O subsystem on UNIX systems is much more optimized, the filesystems (like Online-VxFS) are more stable (and fast), the logical volumes and file-systems can be resized on-line.
Think about online backup, then RMAN on seems to be in favour of UNIX, too.
Enough for today?
FWIW,
Wodisch
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-02-2003 02:19 PM
тАО02-02-2003 02:19 PM
Re: Oracle on 64bit UX vs 32bit Windows
All of the recent Oracle transaction records were on HP Superdome computers.
Here are some things to think about with regards to moving a 32 bit database to a 64 bit environment.
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xa1285bd3782dd711abdc0090277a778c,00.html
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x5e76ef70e827d711abdc0090277a778c,00.html
Good Luck.
P
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-02-2003 11:06 PM
тАО02-02-2003 11:06 PM
Re: Oracle on 64bit UX vs 32bit Windows
The answers pro UNIX don't need another posting.
About thge memory on a 32-bit system :
The SGA limit is 1.75 GB for all instances togehther, so if you run several databases on the same system, the sum of SGA sizes must not exceed 1.75 GB ( No matter UNIX or whatsoever ). We have upgraded or even replaced some ouf oru machines for that reason.
Rgds
Alexander M. Ermes