Prev | Current Page 345 | Next

Rick Greenwald, Robert Stackowiak, Jonathan Stern

"Oracle Essentials: Oracle Database 11g"

In a RAC deployment,
youshou ld also pay attention to the interconnect bandwidth as excessively heavy
traffic can slow performance. But such interconnects continue to increase in speed as
well, and network bandwidth in general is much less of an issue today if proper
design choices are made.
Because of this trend, we will next focus on how Oracle uses the three key machine
resources: CPU, memory, and disk I/O. The slowest access is to disk and, as a result,
the most common database performance issues are I/O related. The majority of this
chapter therefore focuses on performance as it relates to physical disk I/O.
Network bandwidth can become a concern when using your Oracle
database to retrieve very large data sets over the network. Although
you can??™t typically surmount this type of problem simply by improving
the performance of your Oracle database; you can monitor network
and application server bottlenecks with Enterprise Manager, as
of Oracle Database 10g.
The database server machine may encounter bottlenecks caused by contention for
multiple resources.


Pages:
333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357
www.books61.hobbitstory.com tanie noclegi międzyzdroje pokoje windsurfing Władysławowo noclegi e-lady