Skip to Main Content

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!

Metrics "Database Time Spent Waiting (%)" is at ... for event class "Commit

cprieurJul 31 2009 — edited Aug 3 2009
Hi guys

I'm getting this warning every 20 minutes from Enterprise Manager 10g: Metrics "Database Time Spent Waiting (%)" is at 67.62891 for event class "Commit". My database is an Oracle 10g 10.2.0.4 (Linux x84_64) with dataguard, one physical and one standby networked at 100Mbit. I have 3 groups of 50M redo log with a low volume of transaction for now. Here are some metrics numbers:

SQL> select sum(seconds_in_wait),event from v$session_wait group by event;

SUM(SECONDS_IN_WAIT) EVENT
-------------------- -------------------------------------------------------------------------------
121210 SQL*Net message from client
0 Streams AQ: waiting for messages in the queue
18 wait for unread message on broadcast channel
6 LNS ASYNC end of log
30 jobq slave wait
37571 rdbms ipc message
384 smon timer
35090 pmon timer

I tune the my listerners for Dataguard using the documentation. I don't know what to tune anymore, is someone has a clue.

Thanks,

Chris
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 31 2009
Added on Jul 31 2009
6 comments
9,286 views