• Creator
  • #2148316

    Limitations of Oracle 9i database (32-bit)


    by lazy.daisy1106 ·


    Please help me with this one. I am trying to consolidate known limitations and/or repercussions of running an Oracle 9i ( database (32-bit) running on Windows Server 2K3 (also a 32-bit) on top of a 64-bit hardware and so far all I get is the memory usage. Besides not fully utilizing the allocated memory (since the database will only use not more than 2G and the alloted for the hardware is 16G), what other issues should we be expecting?

    Thanks a lot!

All Answers

  • Author
    • #2565747


      by lazy.daisy1106 ·

      In reply to Limitations of Oracle 9i database (32-bit)


    • #2565736

      How many CPU or Cores are available?

      by oh smeg ·

      In reply to Limitations of Oracle 9i database (32-bit)

      There will be a upper limit on the available number of CPU’s that Oracle can use as well. But there should be nothing else that gives problems.


      • #2565730

        32-bit to 64-bit

        by lazy.daisy1106 ·

        In reply to How many CPU or Cores are available?

        But would it be better if we migrate both database and OS to 64-bit so that we could maximize the RAM allocated? The database to be migrated is a heavily loaded system (too many selects, inserts, updates, deletes) and that millions of data are loaded every night on it. Or setting the AWE would do the trick (but I think these are only for the data buffer components of the SGA)?

        • #2565704

          Depends on what you have available

          by oh smeg ·

          In reply to 32-bit to 64-bit

          And what the need is. While 64 Bit Applications allow for more resources to be used they may not be necessary at the moment be the best option available. Sure eventually we will all move to 64 Bit Applications just like we did when moving from 8 to 16 Bit and then onto 32 Bit. But the problem here is that 64 Bit Hardware has been around for a long time but the software to use all of it’s abilities hasn’t.

          As a result the driver Base and so on for 64 Bit Applications isn’t well developed so while technically 64 Bit is Superior when it comes time to implement a 64 Bit system it may not be piratical. There are still numerous Driver issues with all forms of 64 Bit Windows Server Platforms so while it is the way to go it may not currently be the time to switch.

          As the existing 32 Bit application is working and I’m assuming satisfactorily there is no need to change it unless there are currently problems or you have a need to move to 64 Bit Systems. Just moving to 64 Bit because Oracle needs it and no other applications do isn’t enough of a reason. But if you are using 2007 Exchange which is a native 64 Bit System then adding a 64 Bit version of Oracle to that server may be worth the effort.

          Really it depends on the current implementing as to what is the best option now. It’s useless to switch just because the 64 Bit version is available and it’s not needed. Also you need to test the 64 Bit application before deploying it to see if there are any issues with Data Loss or Corruption involved.

          For instance a F1 car is technically better than a clapped out 1950 mini but that doesn’t mean that it works better in most applications just in one set of circumstances, and in many it will prove to be a drawback to have.

          [i]Edited to improve clarity I hope.[/i]


        • #2565645

          Thanks so much!=)

          by lazy.daisy1106 ·

          In reply to Depends on what you have available

, if it’s only Oracle that needs the 64-bit (to make it run smoother and more efficient), I can forego the idea of migrating both my OS and database? But if our main concern is to make the database run efficiently (it’s a 24×7 production database), should I consider the migration idea? I read somewhere (sorry I forgot the article) that sooner or later, I would might get ORA errors such as ORA-4030, ORA-12500, ORA-12560. I think this leads back to the fact that memory is not enough to support the database’s (and other user threads) activities. Thanks so much again!

        • #2567206

          Re [i], if it’s only Oracle that needs the 64-bit

          by oh smeg ·

          In reply to Thanks so much!=)

          That is what I would do as it’s possible to have a complete loss of function changing the version of Oracle or for that matter any other application. At the current time 64 Bit OS’s are not well supported and there are issues involved in migrating to this form of Computing. While it will eventually be the normal it’s currently not quite time for full scale migration.

          As for the ORA Errors yes you could get them but that would require a massive size D Bade file measured in Terabytes. Even then it would be better to rework the Layout to cut out unnecessary fields to make the file smaller.

          This is more to do with the size of the actual files not the hardware involved or the up time.


Viewing 1 reply thread