, 2003 12:54 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: 32 or 64?
There are no performance benefits from the software change; in fact,
anecdotal evidence is that there might even be a hit, since we're now moving
more data about (i.e. 64-bit integers instead of 32-bit integers
If you run the Enterprise Edition of Windows Server you can use more then
2GB for Oracle.
Check metalink:
Note:46001.1
Bulletin
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, August 18, 2003 7:49 PM
We are running
You could always move to W2K AS which will let you address upto 8GB of RAM (maybe
more), we have our current servers with 8G of RAM. There are some changes you need to
make also if you want a single Oracle instance over 2GB in size.
We are using the 8GB of RAM to run 8 small Oracle databases (
To sell more sun kit? To add to a resume?
As for bugs, I'll bet my hat there are more bugs on any newer, limited
circulation release than there are on wide circulation popular releases.
Niall
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Daniel
Has anyone tests / benchmarks showing a multiuser
OLTP Oracle database performs better with
64-bit 8.1.7 on 64-bit Solaris8 then
32-bit 8.1.7 on 64-bit Solaris8 ?
ie, the default Solaris8 install is 64-bit.
If the DB is less than 100GB with db_block_buffers
of less than 1GB and db_block_size
A bigger SGA comes to mind as one immediate benefit.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, August 18, 2003 12:14 PM
From a technical and business perspective, what are the reasons to migrate
from 32-bit to 64-bit Oracle? Are
well some OS you're forced to at some level, but my understanding is
UNLESS you build the database with 64 bit binaies, just chaging the word
size supposedly doesn't let you gain any of the 64 bit performance
enhancements, fact or fiction, someone willing to elaborate?
joe
Daniel Fink wrote:
There are no performance benefits from the software change; in fact,
anecdotal evidence is that there might even be a hit, since we're now moving
more data about (i.e. 64-bit integers instead of 32-bit integers), but that
is certainly debatable. Some very simple testing with C programs on
Fiction. I migrated a 32 bit database to 64 and did not change anything else. DB
definitely runs better. As in WEB pages returning in 10 second vs. 40 seconds
before the migration.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Monday, August 18,
You want to migrate to 64 bit for several reasons:
a) That's in, so you'll be the coolest guy in the pub.
b) You can have a very large SGA, which will dramatically improve
BCHR (Buffer Cache Hit Ratio), which will, in turn, make all your queries
run blindingly fast, according to old oracle
We are running oracle 9i on Windows 2000 Server. I recently started
administering Oracle on Windows 2000 and noticed that when the oracle.exe
process consumes 1450+ Mb of memory, we run into out of process memory
error. We ended up recycling application servers every time this has
happened and
To: Multiple recipients of list ORACLE-L
Subject: RE: 32 or 64?
Fiction. I migrated a 32 bit database to 64 and did not
change anything else. DB definitely runs better. As in WEB
pages returning in 10 second vs. 40 seconds before the migration.
Dick Goulet
Senior Oracle DBA
Oracle
] Quad/Tech Inc, Sussex, WI USA
-Original Message-
From: Goulet, Dick [mailto:[EMAIL PROTECTED]
Sent: Monday, August 18, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: 32 or 64?
Fiction. I migrated a 32 bit database to 64 and did not
change
To: Multiple recipients of list ORACLE-L
Subject:Re: 32 or 64?
There are no performance benefits from the software change; in fact,
anecdotal evidence is that there might even be a hit, since we're now moving
more data about (i.e. 64-bit integers instead of 32-bit integers
Title: Re: 32 to 64 Bit Upgrade -- need info
Munish,
Essentially, you can use the same datafiles, controlfiles, and redologfiles. All of the PL/SQL has to be recompiled (including STANDARD and DBMS_STANDARD, which makes the task something of a chicken-and-egg situation)...
Short story: you
read the migration guide
Munish Bajaj wrote:
Hi All,
I'd like to get some information on how to upgrade a 9iR2 32 Bit
Installation to 9iR2 64 Bit.
Can I Upgrade just the software and use the same datafiles and control
file etc. or do I need to create a new database again and do
Title: Message
There are several ways to know about the
oracle S/W installed is 32 or 64-bit
1- check V$VERSION
2- use the UNIX command FILE for oracle
3- invoke server manager
pls refer to Note:119707.1 on metalink
Hope this helps.
Sandeep.
-Original
Message-
From:
Hrvinder
Plese reach to $ORACLE_HOME/bin directory and run
file oracle
U will see which bit ur oracle is?
Thx
-Seema
From: Harvinder Singh [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: 32 or 64 bit
Date: Thu, 28 Feb 2002
http://www.vampired.net/forums/viewtopic.php?topic=32forum=150
Harvinder Singh wrote:
Hi,
How to check the database and sun unix system is 32 bit or 64 bit.
Thanks
--Harvinder
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Suzy Vordos
INET: [EMAIL
19 matches
Mail list logo