Books for you

You may find that your problem has a simple source, such as a lower-than-expected
database buffer cache hit ratio. Since the cache is not working at its optimal level,
youcou ld simply increase the initialization parameter DB_BLOCK_BUFFERS to
increase the size of the cache and possibly improve the hit ratio. Youcan monitor the
performance of the buffer cache hit ratio in V$METRICNAME.
Performance Tuning Basics | 157
Other situations may not be quite so clear cut, using the approach of investigating
parameters exposed by views. For example, youcou ld find that it takes a relatively
long time to fetch database rows from the disk. This situation may be caused by contention
on the database server??™s disks and could be caused by less than optimal
placement of Oracle files on disk or by other applications on the server.
AWR, ADDM, and Enterprise Manager
A much better approach today is to use Enterprise Manager (also known as Grid
Control for RAC implementations) as the starting point for performance monitoring
and management.


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