22.1 What is a Bottleneck?
|
| < Day Day Up > |
|
A bottleneck is quite literally an area of part of the hardware or software architecture where too much processing is being funneled through a specific area. Much more is being done in one specific place than anywhere else.
What are the causes of bottlenecks? Causes are numerous. More often than not, bottlenecks are a result of poorly designed SQL code or a poorly structured data model. Rarely is there a hardware issue. One of the most commonly occurring hardware performance issues is inappropriate disk structure for redo logs and archive logs. Hardware issues are generally beyond the scope of this book and fall under the guise of systems administration. This book is all about tuning of Oracle databases and not about tuning at the operating system level. Therefore, any hardware or operating system aspects are not particularly relevant to this text.
|
| < Day Day Up > |
|
EAN: 2147483647
Pages: 164