Home » RDBMS Server » Performance Tuning » Performance Bottleneck!!! (Oracle, HP-UX v1)
Performance Bottleneck!!! [message #278936] Tue, 06 November 2007 06:32 Go to next message
Muhammad Ahmad
Messages: 30
Registered: November 2002
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,


Muhamamd Ahmad.
Re: Performance Bottleneck!!! [message #278944 is a reply to message #278936] Tue, 06 November 2007 07:13 Go to previous message
Michel Cadot
Messages: 63920
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read How to Identify Performance Problem and Bottleneck which is at the top of the forum.

Previous Topic: sql slow
Next Topic: IN Sub-query select performing poorly
Goto Forum:

Current Time: Tue Oct 25 03:49:53 CDT 2016

Total time taken to generate the page: 0.14338 seconds