cancel
Showing results for 
Search instead for 
Did you mean: 

Poor database performance

0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Hi,

You mention:

Database time is 80% of the Average response time.

and then you star talking about database ratios "ratios".

Lets make you think a little ....

Find out what is doing your database, where is spending that time.

Tuning is about TIME, not ratio. You want the operations to be FASTER or do more operations in the same amount of TIME.

Forget about prehistoric TUNING. Please, ratios are (mostly) useless.

read this and see if you can continue without any "useless silver bullet"

http://www.oracle.com/technetwork/database/manageability/diag-techniques-presentation-ow07-128491.pd...

manumohandas82
Active Contributor
0 Kudos

Hi Amit ,

Are u seeing high DB performance for all the  transactions or some .

Can you share the  CPU  memory  stats of the database server 

Thanks ,

Manu

0 Kudos

Hi Manu,

Thanks for the reply..

I got the DB Performance from the Tx st03n and EWA report also suggest the same. DB time is high for Dialog steps.

Below is the Memory stat --

SAP Memory      Curr.Use % CurUse[KB] MaxUse[KB] In Mem[KB] OnDisk[KB] SAPCurCach HitRatio %

Roll area            3,99     10.448     47.584    131.072    131.072   IDs           97,18
Page area            0,02        322     63.464    131.072  1.869.824   Statement     74,00
Extended memory      3,61    303.104  1.785.856  8.388.608          0                  0,00
Heap memory                    2.093  3.404.858          0          0                  0,00

Regards

Amit