Friday, July 8, 2011

Oracle Database Performance Issue

Here i am sharing some steps that can help you to improve your oracle Performance ,Performance slow down has its own reasons on different sites but still you can try these common steps ....

1) Update statistics (The most common thing you can do first update you DB statistics if you are not doing this on regular basis.

2) Collect No work load statistics by using sqlplus command "

EXEC DBMS_STATS.GATHER_SYSTEM_STATS;


3) Collect workload statistics :

EXEC DBMS_STATS.GATHER_SYSTEM_STATS('INTERVAL', < minutes>);


: Number of minutes during which you are to determine the WORKLOAD statistics.

4) Check alert log file for any warning errors common scenario:

a) ORA-01654: unable to extend
b) ORA-00600: internal error code, arguments:
To resolve these check your table space and increase them appropriately.

c) Check Point not complete ...Its a major issue that can effect your performance

No comments: