Oracle® Fusion Middleware Administrator's Guide for Oracle Business Intelligence Discoverer 11g Release 1 (11.1.1) Part Number B32519-02 |
|
|
PDF · Mobi · ePub |
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:
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 want 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.