I have the same issue... I exported my database from 9i - used DBCA in
10g and then imported.

(1) Should I be using the database migration tool instead?

(2) Also, can you had 10g on one server and migrate a database from
another (9i) server, or do the have to reside on the same box?

(3) Last, if I 'migrate' a database using the migration tool, does it
leave the on 9i database alone and give me a 10g 'version' of that
database, or does it render the 9i database unusable?

Any help on this would be great.


Jeffrey C. Ferrel
DMS III
State of Nevada
775.687.9327
[Email address protected]

-----Original Message-----
From: Qi cheng
[mailto:oracledba-ezmlmshield-x69521661.[Email address protected]
Sent: Monday, March 05, 2007 10:46 AM
To: LazyDBA Discussion
Subject: convert from 9i to 10g , performance problem

converted from 9i to 10g , performance is a problem now. whole system
slowdown

any one had same problem and got fixed?





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page