DB slow [message #9208] |
Mon, 27 October 2003 06:04 |
Suresh.H.T
Messages: 9 Registered: February 2002
|
Junior Member |
|
|
Hi,
When the database is slow,what are the things i have to look in to?.What are all the V$ tables/views i have to look in to?
Suresh.H.T
|
|
|
Re: DB slow [message #9221 is a reply to message #9208] |
Mon, 27 October 2003 16:10 |
Rock
Messages: 18 Registered: February 2002
|
Junior Member |
|
|
look at the server performance. check cpu and memory utilization. This is the first step i take if overall database performance goes down. If this is ok. check the various hit ratios like buffer cache/library cache/dictionary cache and so on.. There are various other v$ views at database level that you can look at namely v$system_event/v$session_event/v$session_wait each will give you wealth of information about different aspects of your db health. But for this you need to have good understanding of these view.
-Rock
|
|
|