| bhuppi |
Posted: Apr 05, 2008 06:55:17 AM |
Total Post: 3
Joined: Mar, 2008
|
Hi All,
can anyone tell me how to minimize the wait events as it degrades my database performance |
|
|
 Mohammed Taj |
| Posted: Apr 05, 2008 08:43:19 AM |  |
|
Total Post: 634
Joined: Jul, 2007
|
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/waitevents.htm#REFRN101
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/manproc.htm#sthref767
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/autostat.htm#CHDBCADD
|
|
|
|
|
| Murtuja |
| Posted: Apr 07, 2008 01:33:30 AM | |
|
Total Post: 588
Joined: Jan, 2006
|
Hi,
you can run statspack reports and find out performance related problems.
You can also upload your statspack reports to this site.
http://www.dbapool.com/analyzer/
|
|
|
|
|
| Gitesh |
| Posted: Apr 08, 2008 06:49:01 AM | |
|
Total Post: 157
Joined: May, 2005
|
Oracle kernel constantly update wait events in its own table like X$ tables. Wait events reflect all problems of database. If you study more depth in those event you are able to identify problems of database.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
