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

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: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search all the differences.

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


Current Time: Sun Dec 11 02:03:32 CST 2016

Total time taken to generate the page: 0.09754 seconds