Memory Advisors
The Memory Advisor is an expert system that provides automatic memory management
and eliminates manual adjustment of the SGA and PGA when enabled
(and recommended in Oracle Database 11g). If just automatic shared memory is
enabled instead, youwill have access to the Shared Pool (SGA) Advisor and PGA
Advisor. Finally, if youare manually managing shared memory, youwill have
access to the Shared Pool (SGA) Advisor, Buffer Cache Advisor, and PGA Advisor.
Manageability Features | 125
Segment Advisor
Use of the Segment Advisor eliminates the need to identify fragmented objects
and reorganize the objects using scripts. The Segment Advisor advises which
objects to shrink and allows youto simply accept the recommendations. You
might also use this information in capacity planning.
Undo Advisor
The Undo Advisor helps size the undo tablespace and can be used to set the low
threshold of undo retention for Flashback. Oracle Database 11g features automatic
undo management.
MTTR Advisor
The Mean Time to Recovery (MTTR) Advisor provides guidance regarding the
impact of MTTR settings and physical writes.
Pages:
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288