| 10g Database Performance [message #343939] |
Thu, 28 August 2008 08:37  |
Asma123
Messages: 19
Registered: November 2007
|
Junior Member |
|
|
SCENARIO # 1
-------------
On one server, we installed 10g database and imported dump from 9i DB. It had some performance issues initially, but they were resolved after dbms_stats was run for the database.
SCENARIO # 2
-------------
On another server, we migrated 9i database to 10g database using database migration assistant. After that we performed the following actions
1)Rebuilt all indexes
2)Run dbms_stats for the database
The overall performance of the database has been enhanced but performance of some of the screens and functionalities have been reduced e.g. a screen used for creating users is very slow. Time taken to create one user and granting user privileges to access all the objects in the user schema is 8 minutes. The same process is taking 10 seconds in scenario # 1(dump).
What can we do about it...
Regards..
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
