DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: 32 and 64 bits

  1. #1
    Join Date
    Jan 2001
    Posts
    157

    Thumbs up

    Can any body tell me if there are any advantages and disadvantages associated with running Oracle 32 bits and 64 bits respectively and and vice versa

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Check this site for some details,

    [url]http://dbasupport.com/forums/showthread.php?threadid=7410[/url]

    Now a days since oracle 64bit is getting most common, I hope that oracle would start to pace up with its patches for 64 bit too.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jan 2001
    Posts
    157
    Hes. I have read that but does not answer my question

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    O.K, when you run a 32bit application on a 64bit OS, your application performance might be good , but you would be failing to make us of the 64bit operation of the OS. It will not be possible to run the 64 bit application on a 32bit os because the address structure of the hardware are all different. When you run the 64 bit application on the 64bit OS, you are making use of the hardware structure and the addressing to the fullest extent, in short it would be 1:1 ration. Similarly for the 32bit application on a 32 bit os. For more information refer any system archiecture book, or refer the perticular system or vendor manual for their design detail. When you talk about the different architecture, you would be talking from the bus to the memory management and etc.

    Hope this would clear your doubts to an extent.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Reminder. Max size of Datafile is concerned with the 32-bit/64-bit OS. You can't move around your instance across boxes if you get the situation of creating TEST/DEVT instances for Production.

    Once, you 64-bit, you have to keep going with 64-bit. This does matter alot if your database grows more than 50//100GB. For smmaler size, it will not make much diffrence, as you can always export and import.
    Reddy,Sam

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width