Performance: 32-bit SE vs. 64-bit EE 
Author Message
 Performance: 32-bit SE vs. 64-bit EE

We just upgraded a copy of an 8.1.6.0 64-bit Enterprise Ed. test PeopleSoft
database to 8.1.7.1 32-bit Standard Ed. to create our production PS db on a
production host that is basically the same hardware config. as the test
machine.  Users are now telling us that everything seems to run faster. I
have seen some postings that suggest 32-bit Oracle is faster than 64-bit.
I'm wondering if 32-bit Oracle SE really could be so much faster than 64-bit
EE that it would be apparent to end-users.  Has anyone seen this? Has anyone
seen anything published on the subject?

It would be most interesting if this proves to be true -- Oracle really gave
us a lot of grief when we downgraded our license from EE to SE!!!
--
Vincent Ventrone
DBA
Information Technology Services
Brandeis University
MS 017
Waltham, MA 02454

781 736-4517



Tue, 02 Dec 2003 02:32:22 GMT
 Performance: 32-bit SE vs. 64-bit EE

Afaik, the only advantage of using 64bit Oracle, is being able to address
more memory than 4GB, for example for huge data warehouse's SGA, or for
system with 10k users.

But the code execution part itself is slower (never tested, only heard).
I saw that you upgraded from 8.1.6 to 8.1.7. The CBO could have some fixes
and optimizations, so it'll pick better execution plans for queries.

Or did you do any reorganizing / rebuilding during the migration?

Tanel Poder
a DBA



Tue, 02 Dec 2003 06:21:27 GMT
 Performance: 32-bit SE vs. 64-bit EE


Quote:
> We just upgraded a copy of an 8.1.6.0 64-bit Enterprise Ed. test PeopleSoft
> database to 8.1.7.1 32-bit Standard Ed. to create our production PS db on a
> production host that is basically the same hardware config. as the test
> machine.  Users are now telling us that everything seems to run faster. I
> have seen some postings that suggest 32-bit Oracle is faster than 64-bit.
> I'm wondering if 32-bit Oracle SE really could be so much faster than 64-bit
> EE that it would be apparent to end-users.  Has anyone seen this? Has anyone
> seen anything published on the subject?

> It would be most interesting if this proves to be true -- Oracle really gave
> us a lot of grief when we downgraded our license from EE to SE!!!
> --
> Vincent Ventrone
> DBA
> Information Technology Services
> Brandeis University
> MS 017
> Waltham, MA 02454

> 781 736-4517

Is your hardware 32bit or 64bit?  I'll bet its 32bit.  
64bit would then be done in emulation, which is always
slower than native modes.

Liz



Mon, 08 Dec 2003 22:45:12 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. 32 bit Vs 64 bit

2. ??: 32 bit vs. 64 bit Informix

3. 32-bit vs 64-bit on AIX 4.3.3

4. 32 bit vs. 64 bit Informix

5. 32 bit vs. 64 bit Informix

6. 答复: 32 bit vs. 64 bit Informix

7. 32 bit vs 64 bit

8. 64-bit vs 32-bit

9. 64-bit SQL Server and 32-bit dlls question

10. 32-bit Oracle Server on 64-bit Solaris?

11. Changes in 64 bit Oracle from 32 bit

12. Moving from 8.1.7 32-bit to 8.1.7 64-bit


 
Powered by phpBB® Forum Software