In this section, we??™ll cover the OEM-equivalent functionality to Segment Advisor and
Undo Advisor, covered previously in this chapter.
Segment Advisor
Figure 6-5 shows the home page for OEM. Many of the space management functions, including
Segment Advisor, are available directly from this home page, especially when there is a pending alert.
The top portion of the home page lists general availability information of the instance, including
the instance name, host name, CPU usage, and session information. The bottom half of the home
page contains direct links to status pages and advisors. Figure 6-6 shows the bottom half of the
home page from Figure 6-5.
FIGURE 6-5 OEM home page
Chapter 6: Monitoring Space Usage 201
If there is not an outstanding space-related alert, and you want to run Segment Advisor, click
the Advisor Central link in Figure 6-6, and then click the Segment Advisor link; you will see the
page in Figure 6-7.
In Figure 6-7, select the Tablespaces radio button; you suspect that one or more tables in the
USERS tablespace might need reorganization. Click Next; you will see Step 2 in Figure 6-8. Add
the USERS tablespace to the list of objects to be analyzed.
When you click Next in Figure 6-8, you can change the scheduling for the analysis job; by
default, the job runs immediately, which is what you want to do in this case. Figure 6-9 shows the
other scheduling options.
When you click Next in Figure 6-9, you see the review page in Figure 6-10.
Pages:
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359