awr report

[Arsalan]

Hello sir,


Oracle 11.2.0.3
Application developed in Oracle 10g forms
windows 2003

The database is very slow i generated awr report ,

Kindly guide me how to find the network issue,Database issue , etc

if we increase size of (SDU = values)    (TDU = values ) does it positive effect on database performance


AWR.png



Thanks in advance
Arsala khan

[ErmanArslansOracleBlog]

There is a super minimal wait for network.
So, you should concantrate on CPU & enq:TM contention waits.
For CPU, check the SQL ordered by CPU section.
For Enq TM waits; Enq TM waits are caused by missing Foreign Key (FK) index on the FK constraint columns in the Child tables. Check : Locking and Referential Integrity (Doc ID 33453.1) & Resolving Issues Where 'enq: TM - contention' Waits are Occurring (Doc ID 1905174.1)

Also, read my AWR related blog post to get a better idea about AWR interpreting;

http://ermanarslan.blogspot.com.tr/2014/05/awr-analysis-part-1.html

[Arsalan]

Hello Arslan,


if we increase size of (SDU = values)
(TDU = values ) does it positive effect on database performance





THANKS

[Arsalan]

if we increase size of (SDU = values)

(TDU = values ) IN LISTENER,TNSNAME.OR, SQLNET.ORA FILE

 does it positive effect on database performance

[ErmanArslansOracleBlog]

According to the screenshot that you sent to me, your problem is about CPU and enq TM waits.
The network wait  is minimal.. It is not a problem.

So, your SDU, TDU related actions are unrelated with that..
However, if you want to understand them better, please read the following documents;

Document 44694.1 SQL*Net Packet Sizes (SDU & TDU Parameters)"
Document 67983.1 Oracle Net Performance Tuning"

[Arsalan]

For more inquiry of Oracle database problem i generated AWR REPORT

when you find free time kindly Read AWR REPORT AND find the main problem and guide me

for solution


awr_report_24-4-2018.html


I AM VERY THANK FULL THAT FOR ALWAYS SUPPORTED ME

Arsala khan

[ErmanArslansOracleBlog]

As I said,

you should concantrate on CPU & enq:TM contention waits.
For CPU, check the SQL ordered by CPU section.
For Enq TM waits; Enq TM waits are caused by missing Foreign Key (FK) index on the FK constraint columns in the Child tables. Check : Locking and Referential Integrity (Doc ID 33453.1) & Resolving Issues Where 'enq: TM - contention' Waits are Occurring (Doc ID 1905174.1)

You sent me a 9 minute-AWR
Your CPU time as you see there, is 70 mins.
Again, you should concantrate on section named: SQL ordered by CPU Time.
Your sqls are not so long, but they are executed pretty often..

[Arsalan]

Thanks a lot for your nice guidance






ARSALA KHAN