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
Karma: 0
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: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Karma: 0
Senior Member
Account Moderator
Read How to Identify Performance Problem and Bottleneck which is at the top of the forum.

Previous Topic: SQL Tunning
Goto Forum:

Current Time: Tue Aug 22 11:57:50 CDT 2017

Total time taken to generate the page: 0.09769 seconds