9iR2 to 10gR2 migration - Script running too slow
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: 9iR2 to 10gR2 migration - Script running too slow

Hybrid View

  1. #1
    Join Date
    Feb 2008
    Posts
    1

    9iR2 to 10gR2 migration - Script running too slow

    Hi,
    Currently we are doing 9iR2 to 10gR2 migration. As part of manual migration activity, am currently executing the script u0902000.sql. But this script is running (or could be hanging) since 24 hours.
    Please please let me know is this normal? or is it hanging? How I can check?

    script is hanging after this point
    _____________________________________
    grant insert, delete on drv$unindexed2 to public
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist
    __________________________________

    My database in Unix server & 160 GB size

    Thanks a lot for your inputs & help

  2. #2
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    TAke the trace of the session and find out the problematic SQL, Then check it out why it's slowing down. Seems like sql's using different explain plan in 10g.
    http://www.perf-engg.com
    A performance engineering forum

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    I would restore from the backup the database and then once again run
    utlu102i.sql

    and then spool and run
    SQL> @utlu102i.sql

    and see if you are missing something obivious.

    regards
    Hrishy

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