Oracle RAC Database Growth Test
Periodic monitoring of the usage of the shared cluster storage is essential to ensure that the cluster is always adequately sized to handle current and future loads. The Ora
Target of the test : Oracle Cluster
Agent deploying the test : An internal agent
Outputs of the test : One set of results for the Oracle cluster monitored.
Configurable parameters for the test
cle RAC Database Growth test monitors the usage of a shared storage, and indicates if it requires resizing.
|
Measurement | Description | Measurement Unit | Interpretation |
---|---|---|---|
Allocated size of database: |
Indicates the amount of space currently allocated to the datafiles for use. |
GB |
|
Used space in allocated: |
Indicates the amount of allocated space currently used by the datafiles. |
GB |
|
Free space in allocated: |
Indicates the amount of allocated space that is still unused by the datafiles. |
GB |
|
Space usage in allocated: |
Indicates the percentage of allocated space that has been utilized by the datafiles.
|
Percent |
If the use max size parameter of this test has been set to No, then the value of this measure will be computed using the following formula: Used space/Total size of database * 100 If the use max size parameter of this test has been set to Yes, then the value of this measure will be computed using the following formula: Used space/Maximum size up to which the database can grow * 100 Ideally, this value should be low. A value close to 100% is a cause for concern. |
Free percentage in allocated size: |
Indicates the percentage of allocated space that is unused. |
Percent |
|
Max size of database: |
Indicates the maximum size up to which the shared cluster storage can grow. |
GB |
|
Used space in max size: |
Indicates the amount of space used by datafiles. |
GB |
|
Free space in max size: |
Indicates the amount of space that is still unused by datafiles. |
GB |
|
Space usage in max size: |
Indicates the percentage of max space that is currently used by datafiles. |
Percent |
|
Free percentage in max size: |
Indicates the percentage of max space that is available for use. |
Percent |
|
Space free: |
Indicates the percentage of free space in this database instance.
|
Percent |
If the use max size parameter of this test has been set to No, then the value of this measure will be computed using the following formula: Free space/Total size of database * 100 If the use max size parameter of this test has been set to Yes, then the value of this measure will be computed using the following formula: Free space/Maximum size up to which the database can grow * 100 Ideally, this value should be high. A sudden/consistent decrease in the value of this measure could indicate excessive utilization of the database caused by a sporadic/steady increase in database activity. Very low free space in a database instance could significantly deteriorate its performance. Under such circumstances therefore, you might want to check the measures reported by the Oracle Datafile GrowthTest to figure out which datafile is consuming too much space. You might then want to resize the datafile. |