Books for you

Performance problems occur
when there is a greater demand for a particular resource than the resources available
to service that demand, and the system slows down while applications wait to share
the resource.
156 | Chapter 7: Oracle Performance
Oracle Server Performance
The first place you??™ll likely begin looking for resource bottlenecks is in the Oracle
database software using Oracle Enterprise Manager (introduced in Chapter 5) to
identify less than optimal use of Oracle??™s internal resources. Bottlenecks within your
database result in sessions waiting unnecessarily, and performance tuning is aimed at
removing these bottlenecks.
Oracle??™s dynamic performance views provide insight into bottlenecks within your
Oracle database. Prior to the introduction of Oracle??™s Automatic Workload Repository
(AWR), the Automatic Database Diagnostics Monitor (ADDM), and Oracle
Enterprise Manager Grid Control in Oracle Database 10g, querying the performance
views often was the first step database administrators performed in determining bottlenecks.


Pages:
327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351