Oracle DB Performance Issue Monday, April 13, 2009

Hi All,

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

Proposed solution : Increase the size of redologs by following below link :


REDO LOG RESIZE/MODIFY


These are the first aid steps you can perform rest you need to analyze with oracle DBA.


Regards,
Gagan Deep Kaushal