on 01-08-2015 6:50 PM
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
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"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.