You can click Show
SQL if you are curious or if you want to use the SQL statements in your own custom batch job.
FIGURE 6-6 OEM home page-related links
202 Oracle Database 11g DBA Handbook
FIGURE 6-7 Segment Advisor Step 1: select analysis type
FIGURE 6-8 Segment Advisor Step 2: select objects
As you might suspect, clicking Submit in Figure 6-10 submits the job to be run either
immediately or at the specified time. The next page you see is the Advisors tab in Figure 6-11.
Chapter 6: Monitoring Space Usage 203
FIGURE 6-9 Segment Advisor Step 3: scheduling options
FIGURE 6-10 Segment Advisor Step 4: review
204 Oracle Database 11g DBA Handbook
In Figure 6-11, you see the Segment Advisor task you just initiated. In this case, all of the recent
Advisor tasks are Segment Advisor tasks; depending on the time of day and other jobs you have
scheduled, this can be a mix of Memory Advisor tasks, SQL Advisor tasks, and so forth. Most of
the tasks in Figure 6-11 are created with the default Oracle installation and are run on a regular
basis, such as the Auto Space Advisor. As a result, any results you see in your ad hoc analysis task
would show up eventually in one of the periodic Segment Advisor task results.
When the Status column for your Segment Advisor job changes to COMPLETED (you can
refresh the list by refreshing the browser window or clicking Refresh), you can click the job name
to see the results of the job; you can see the results of this job in Figure 6-12.
Pages:
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360