| Server Tuning [message #57837] |
Thu, 10 July 2003 07:25  |
Steve Weitzman
Messages: 4
Registered: May 2003
|
Junior Member |
|
|
I inherited an Oracle server with one main application running against it. I know very little about how it was built or anything else about it. What I do know is that it runs very slow. It is an Oracle 8.1.7 server. When I run TOAD server statistics I get the following red flags
Buffer Cache Hit Ratio 66.3671 -> May need to increase DB_BLOCK_BUFFERS
Parse to Execute Ratio 408 -> high
DBWR Average Scan Depth 285 -> number of DB_FILES to high
What do these mean and how can I fix them. I know one way to reduce the parse to execute ratio is to use BIND varibles.
|
|
|
|
| Re: Server Tuning [message #57839 is a reply to message #57837] |
Thu, 10 July 2003 09:01  |
Navtej
Messages: 19
Registered: July 2003
|
Junior Member |
|
|
From database point of view
First increase the DB_BLOCK_BUFFER and Shared_Pool
second check the following things
a)Physical disk attributes (stripe size, speed, layout etc..)
b)Spreading written data across more disks/files
c)Using Asynchronous writes where available
d)Using multiple database writers where asynch. IO is not available. DB_WRITERS in Oracle7, DBWR_IO_SLAVES in Oracle8/9.
e)Using multiple DB Writer gatherer processes in Oracle8 DB_WRITER_PROCESSES
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
