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

SAP Performance and Tuning Tools

Dear All,

Any time you must have come across some performance issue with your SAP System, So here i am mentioning some approach that you can follow to avoid the same....

Most Commonly Used Tools and Monitors –AS ABAP

1) Hardware : Application server
OS06 (ST06), OS07

2) Database Gener DBACOCKPIT
DB accesses ST10 ST05, STAD
3) Application :
Shared memory & buffers ST02, SHMM
User memory analysis SM04 S_MEMORY_INSPECTOR
Work process overview SM50, SM66
Workload analysis ST03N STAD
Enqueue monitoring SM12 ST05

4) Communication
HTTP traffic SMICM, ST03G
Remote Function Calls ST03N ST05


Most Commonly Used Tools and Monitors –AS JAVA :

1) Hardware :Application server OS06 (ST06), OS07, SAP MC

2) Database: General DBACOCKPIT, DB02 (Java schema)
DB accesses NWA: Open SQL Monitors, Wily Introscope, SAP JVM Profiler

3) Application: Global Buffers and Caches --> SAP MC, NWA: Open SQL Monitors
JAVA runtime-->Wily Introscope, SAP JVM Profiler
User memory analysis SAP JVM Profiler
Server nodes / thread overview NWA: Operations Management, SAP MC
Workload analysis Wily Introscope
Enqueue monitoring NWA: Open SQL Monitors, SAP MC

4) Communication: HTTP traffic --> HTTPwatch, NWA, SAP MC
Remote Function Calls --> NWA, SAP JVM Profiler, Wily Introscope