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

Thread: upgrade my db?

Hybrid View

  1. 03-01-2002, 04:43 AM #1
    nbiketi
    nbiketi is offline Junior Member
    Join Date
    Sep 2000
    Posts
    33
    I am currently running an Oracle 7.3 database. Would it be wise for me to upgrade my database to 8i or 9i. If so what are the advantages?
    Reply With Quote Reply With Quote
  2. 03-01-2002, 04:48 AM #2
    shadow21
    shadow21 is offline Locally self-managed
    Join Date
    Apr 2001
    Posts
    107
    - Support from Oracle !
    - Locally managed tablespaces...
    ...
    ...

    Reply With Quote Reply With Quote
  3. 03-01-2002, 05:28 AM #3
    Sureshy's Avatar
    Sureshy
    Sureshy is offline Advisor
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    If it aint broken don't fix it...

    It would be advantageous for your knowledge/career.
    It may provide extra functionlity which could be advantageous to your company. You will need to research what extra functionality applies to your system.
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.
    Reply With Quote Reply With Quote
  4. 03-01-2002, 05:38 AM #4
    TimHall
    TimHall is offline Senior Advisor
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    If you have no desire to use the new functionality it is quite hard to justify from a developmental point of view. That said, once the new features are available you will more than likely start using them since some of them are very useful.

    I've done many 7.3 -> 8i and a few 8i -> 9i migrations and I've rarely seen an performance increases. Typically, the kernel is a bit faster in the newer versions, but also a bit more resource hungry. The net result is approxiamtely the same performance.

    I've only had one project that suffered significant performance problems as a result of migration. I'm still working on that one now The optimizers are quite different between versions and it seems to have an adverse affect on this project. In this case it's a very big, badly written web system. It's worth spending some time assessing the affect of the migration on your systems.

    The administration and stability of 8i and 9i are significantly improved compared to 7.3. Initially your DBA will thank you more than your developers.

    Make the move sooner rather than later. As the previous post suggested, support is a major factor.

    You could move to 9i straight away, but it might be wise to wait until Release 2, due about May-ish. That's not to say there's anything wrong with the current version. I've had no problems so far.

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog
    Reply With Quote Reply With Quote
  5. 03-01-2002, 10:00 AM #5
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by TimHall
    As the previous post suggested, support is a major factor.
    Support, IMHO, is the major reason why you would want to upgrade.
    Jeff Hunter
    Reply With Quote Reply With Quote
  6. 03-01-2002, 12:02 PM #6
    julian
    julian is offline Senior Advisor
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Support is the major factor as Jeff said. Be sure that your DBA knows the newer version (8i or 9i). Some people run 8i or 9i using the features of Oracle 7 only which I find rediculuos. If the DBA, the organization is not familiar with the new version of Oracle you might run into trouble with ssomething at some point.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width