| db statistics after db abnormal shutdown [message #220894] |
Thu, 22 February 2007 11:49  |
vinu_raj
Messages: 26
Registered: April 2005
Location: Bangalore INDIA
|
Junior Member |
|
|
Not sure this is the forum i should post this question, still
We had a power outage last week and one of our performance testing database went down without proper shutdown and when it came back ( normal db startup ) the application performance was found to be degraded drastically. When I checked, the CPU utilization was 100% and disk I/O almost nil. I ran the gather db statistics and everything came back to normal.
Now the question is, how did the db statistics got invalidated ? Does this has something to do with abnormal shotdown ? We are using oracle 9i release 2 as below.
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.5.0 - Production
regards
Vinu
|
|
|
|
|
|
| Re: db statistics after db abnormal shutdown [message #220930 is a reply to message #220894] |
Thu, 22 February 2007 15:12  |
vinu_raj
Messages: 26
Registered: April 2005
Location: Bangalore INDIA
|
Junior Member |
|
|
I started looking at CPU utilization and disk I/O after noticing that, one of the processes which use to complete with in 10-15 minutes previously was running for ever after the restart. The process use to complete with in 10-15 minutes before the shutdown, and after the shutdown it didn't come out for 2 hours and I killed it. This process just do selects and does not make any changes in the database.
Once I run db statistics gathering for the schema everything came back to normal.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
