Skip Headers

Oracle Discoverer Administrator Administration Guide 10g (9.0.4) Part Number B10270-01 |
Home | Contents | Index

## Summary Wizard (ASM): Step 3 Allocate Space dialog

Use this dialog to specify the ASM performance required against the amount of tablespace available for ASM. For example, to maximize ASM performance using the minimum of tablespace. You can also analyze the performance gain achieved by increasing the amount of tablespace.

For more information, see:

"Managing summary folders"

#### Performance vs. Space (KB)

Use this graph to evaluate the performance gain achieved by using the specified amount of allocated tablespace. As you change the amount of tablespace, you can see the performance impact displayed as a factor value.

- The dotted line indicates the amount of tablespace available.

- The red line indicates the amount of tablespace selected.

- The plot line shows the performance gain achieved by selecting various amounts of tablespace.

- To change the selected space setting, either:

  - click the graph area and drag the red line to the left or right

  - drag the triangle above the Space (KB) axis to the left or right

  - click the graph area to the left of right of the red line

  - enter the amount of tablespace you wish to use (in KB) in the Create summaries to fill field

#### Tablespace to use for summaries

Use this drop down list to specify which tablespace you want to use to store the summary tables.

#### Create summaries to fill

Use this field when you know how much tablespace is available and you want to evaluate the performance for the value.

#### Estimated performance gain

This figure is a factor value that represents the number of times faster that queries will run if ASM creates the recommended summaries.

#### Recommended Summaries

Use this button to display the "Summary Wizard (ASM): Recommended Summaries dialog", where you specify which summaries will be created/removed for optimum performance gain given the space currently allocated.

#### Advanced Settings

Use this button to display the "Summary Wizard (ASM): Change default settings: List of dialog tabs", where you define the ASM policy.

#### Notes

- When choosing a tablespace, it is recommended that you place summaries in a separate tablespace specifically intended for summary data. If such a tablespace does not exist, we strongly recommend you do not use the SYSTEM or TEMP tablespaces.

| Copyright © 1996, 2003 Oracle Corporation. All Rights Reserved. |
Home | Contents | Index