enqueue

[itwizzkid]

Iam getting the following from statspack:

Top 5 Wait Events
~~~~~~~~~~~~~~~~~ Wait % Total
Event Waits Time (cs) Wt Time
-------------------------------------------- ------------ ------------ -------
enqueue 38,265 11,352,249 88.25
sort segment request 13,275 1,368,865 10.64
db file scattered read 1,812,406 73,436 .57
db file sequential read 693,784 22,138 .17
log file parallel write 34,170 19,253 .15

The top wait event is enqueue. Need advice on how to reduce this.

Thanks

[supower]

It was due to LOCK.
check views v$lock, v$locked_object in peak time to find which objects(tables) are frequently locked and then find problematic sql which locks the tables.