Home » RDBMS Server » Performance Tuning » 10g Database Performance
10g Database Performance [message #343939] Thu, 28 August 2008 08:37 Go to next message
Messages: 19
Registered: November 2007
Junior Member
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.

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...


Re: 10g Database Performance [message #344019 is a reply to message #343939] Thu, 28 August 2008 10:47 Go to previous message
Michel Cadot
Messages: 65137
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search all the differences.

Previous Topic: response time
Next Topic: AWR Service Stats
Goto Forum:

Current Time: Thu Aug 17 14:27:22 CDT 2017

Total time taken to generate the page: 0.10194 seconds