Entries in Troubleshooting (2)
When enough is enough? - how to estimate I/O Performance
Posted on Thursday, July 31, 2008 at 03:33PM
by
Karl Reitschuster
in Troubleshooting
|
Post a Comment
| 
Email
Karl Reitschuster
in Troubleshooting
|
Post a Comment
| Email
Hello reader,
Last week we faced performance problems also shown on the Oracle 10g Db-Console as 'SQL found consuming ...'; The users of the application mourned everything is going slow. Hm ...
The strange thing was that the same kind of SQL run without problems before. I started to monitor I/O with iostat on the Sun Solaris Database Server. The Storage was based on SAN. The I/O rates were from 5m/s - 10m/s. The devices were about 95%-100% busy and this with an I/O rate with only about 10M/second? Usually 100m/s and more were possible.
The database is gone!!
Posted on Friday, August 17, 2007 at 01:04PM
by
Karl Reitschuster
in Troubleshooting
|
Post a Comment
|
3 References
| Email
Karl Reitschuster
in Troubleshooting
|
Post a Comment
|
3 References
| Email
Dear reader, got a call from user of a web based application that the database was gone!! Now first I checked if the user's message really hit the root cause.
