Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Unanswered: Oracle Migration from 8i to 9i

    Hi !
    I want to know, what happens when a database version 8i is migrated to version 9i.
    How does this affect the performance ? Performance is increased or it is degraded ?
    Last edited by sunitakarmarkar; 01-01-04 at 05:44.

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    Obviously, the performance of your database will be increased but add some memory costs (which is minor). Also, 9i has very good enhancement in Security.

    For more information and all the benifits of using 9i over 8i, Please read the Oracle's Documents.

    http://otn.oracle.com/products/oracl...w_features.pdf

    HTH
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  3. #3
    Join Date
    Jan 2004
    Posts
    2
    Thanks for the reply.
    What about the queries written for 8i ?
    Should some changes be made for optimization ? Is there any major change in the optimizer ? i.e. Optimization technique ?
    Will the same queries work as effectively as they work on 8i ?

    Thanks in advance.

Posting Permissions

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