Home » RDBMS Server » Server Administration » Metrics "Database Time Spent Waiting (%)" is at 30.09256 for event class "Commit" (solaris10/oracle10g standard edition)
Metrics "Database Time Spent Waiting (%)" is at 30.09256 for event class "Commit" [message #296587] Mon, 28 January 2008 06:07 Go to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
Hi Friends,

am having errors like this 'Metrics "Database Time Spent Waiting (%)" is at 30.09256 for event class "Commit"'




Thank you,
Dirish
Re: Metrics "Database Time Spent Waiting (%)" is at 30.09256 for event class "Commit& [message #296602 is a reply to message #296587] Mon, 28 January 2008 06:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Commit less often.

Regards
Michel
Re: Metrics "Database Time Spent Waiting (%)" is at 30.09256 for event class "Commit& [message #296752 is a reply to message #296602] Mon, 28 January 2008 23:37 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
it's a production database, I can't ask them to commit less
Re: Metrics "Database Time Spent Waiting (%)" is at 30.09256 for event class "Commit& [message #296772 is a reply to message #296752] Tue, 29 January 2008 00:39 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
But this is the solution, so stay with your waits.

Regards
Michel
Previous Topic: sqlplus
Next Topic: cannot startup database from sqlplus client
Goto Forum:
  


Current Time: Fri Dec 09 05:36:10 CST 2016

Total time taken to generate the page: 0.15077 seconds