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

    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
    Minneapolis, MN
    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.


    MS Computer Science
    OCP DBA 9i/8i

  3. #3
    Join Date
    Jan 2004
    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