Sap Pandit !!

Complete SAP-BASIS Solution

Oracle DB Performance Issue


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’, );

: 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

Advertisements

April 13, 2009 - Posted by | Oracle DB Performance Issue

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: