Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

os thread startup in Top 5 Timed Events AWR

788967Jan 5 2012 — edited Jan 5 2012

Hi all,

I have Oracle 10.2.0.5 for HP UX

I'm experiencing some slowness. While checking AWR I see the following:

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time 732 28.0
os thread startup 983 665 676 25.4 Concurrency
log file switch (checkpoint incomplete) 1,279 617 482 23.6 Configuration
row cache lock 98,641 577 6 22.1 Concurrency
latch: session allocation 1,377 253 184 9.7 Other

What could be the reason for os thread startup?
too many processes due to parallellism?
I have all tables in NOPARALLEL.

And regarding log file switch (checkpoint incomplete), I changed redo size from 100 MB to 200 MB to reduce the frequency of logswitching.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 2 2012

Added on Jan 5 2012

#general-database-discussions

1 comment

3,889 views