| Performance Bottleneck!!! [message #278936] |
Tue, 06 November 2007 06:32  |
Muhammad Ahmad
Messages: 30
Registered: November 2002
|
Member |
|
|
Hi Every Body,
We are facing performance issues in one of our servers.
In the Evening there's a 6-8 hours bulk inserts/ updates/ deletes activity performed every day.
some gathered facts for your analysis are:
Top User Events
Event Event Class % Activity Avg Active Sess.
db file sequential read User I/O 32.31 0.93
db file scattered read User I/O 29.74 0.86
CPU + Wait for CPU CPU 11.87 0.34
enq: TM - contention Application 6.99 0.20
log file sync Commit 2.27 0.07
Top Background Events
Event Event Class % Activity Avg Active Sess.
CPU + Wait for CPU CPU 9.54 0.28
log file parallel write System I/O 3.74 0.11
Please do let know for any further information or query,
Regards,
Muhamamd Ahmad.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
