Re: db_Writer performance

From: Herod <herodt_at_gmail.com>
Date: 10 Mar 2006 10:09:58 -0800
Message-ID: <1142014198.700327.201760@z34g2000cwc.googlegroups.com>

Whats that... about 3% of its total time in buffer waits? Over a week that sounds great. But it could be bad, If all of that took place during a single 5 hour period. There is some very upset user(s) out there cursing the database and everyone associated with it.

You need to put it all into perspective and identify when the DB might be slow. Small time stamps.

I would recommend a monitoring tool as well as the statspack snapshots.

http://www.fourthelephant.com/

has a tool in beta mode, it also has a plug in for Oracle SQL Developer (raptor).

I am not affiliate with http://www.fourthelephant.com/ at all, and if it blows up your system, causes you to get fired and your family to disown you - tough luck.

Test test test

http://yaodba.blogspot.com/ Received on Fri Mar 10 2006 - 12:09:58 CST