Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Poor database performance

Hi,

We are running on Oracle 11.2.0.3. We are facing significant increase in database time.

Database time is 80% of the Average response time.

Below are the other perameters  ---

Data Buffer Quality [%]  -    94.8%

DD-cache Quality [%]  -    80.4%

SQL area getratio [%]  -    98.9%

SQL area pinratio [%]  -    94.3%

SQLA.Reloads/pins [%] -    3.1983%

All seems ok except reload/pins, which is very high.

I am clue less why database time is so high ? Need your suggestions to improve the database time.

Regards

Amit

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question