| Wait Stats [message #515393] |
Mon, 11 July 2011 06:23  |
 |
gxeon
Messages: 53
Registered: January 2011
Location: Mumbai
|
Member |
|
|
Hello Sir
I am new to Oracle DBA , Need help.
When i running the fallowing query in production from v$waitstat view, i found the values as data block=3302, undo block=88, undo header=1725. from some online sites i got to know that to reduce the contention on data blocks we have to increase the DBWR process. Please let me know if there is another ways to reduce the data block values apart from increasing the DBWR process by adding 'db_writer_processes' parameter in my init file.
select CLASS,COUNT,TIME from v$waitstat order by CLASS;
please help
GG
|
|
|
|
|
|
|
|
|
|
| Re: Wait Stats [message #515871 is a reply to message #515393] |
Wed, 13 July 2011 22:24  |
hkchital
Messages: 128
Registered: September 2008
Location: Singapore
|
Senior Member |
|
|
Those figures are *cumulative* wait counts since the database instance was started up. So, if the database instance was started only 60 minutes ago, 3300 and 1700 waits are a concern.
If the database was started up a few days ago, would you consider 3300 occurrences of wait in X days high ?
That is why StatsPack and AWR (if you have the Diagnostic Pack licence) come in hand. You can generate reports for intervals -- e.g. a report showing database activity, statistics and waits over a defined 1 hour. Then, you can consider if X waits in 1 hour is a high count.
Hemant K Chitale
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
