The Automatic Workload Repository (AWR) captures and stores
information about resource utilization by Oracle workloads. By default, statistics are
captured every 30 minutes and are stored for 7 days. These statistics are accessible
through views, but Enterprise Manager provides a much simpler-to-use interface.
The AWR helps the Oracle database identify potential performance issues by
comparing workloads over time. It also acts as the foundation for many of the manageability
features introduced since Oracle Database 10g, such as the Automatic
Database Diagnostic Monitor (ADDM).
Oracle??™s ADDM automatically identifies and reports on resource bottlenecks, such as
CPU contention, locking issues, or poor performance from specific SQL statements.
In Oracle Database 11g, ADDM can perform analysis on clusters. Alerts sent by
ADDM to the Enterprise Manager dashboard can point to causes of contention as
they occur. Enterprise Manager provides both high-level and detailed views of
resource utilization for Oracle servers, and these can give a quick indication of the
cause of performance problems.
Pages:
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354