Database performance become slowly after 3 days
hi gurus of performance database,
My database is in version 11.2.0.4 and become slowly I executed awr and I see that I have wait time for library cache very high:
I join you my awr during the night and the day.
best regards
JP
Background Wait Events
- ordered by wait time desc, waits desc (idle events last)
- Only events with Total Wait Time (s) >= .001 are shown
- %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
| Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % bg time |
|---|---|---|---|---|---|---|
| library cache: mutex X | 156,911,078 | 0 | 11,280 | 0 | 7,740.29 | 17.09 |
| os thread startup | 1,774 | 0 | 164 | 93 | 0.09 | 0.25 |
Background Wait Events
Tagged:
2