Oracle:getSpaceUsage
Gets tablespace usage information for the database.
Type
SYNC, IMPACT_INFO
Arguments
None.
Returns
|
Name |
Type |
Description |
|
File ID |
Integer |
The identifier of the datafile for the tablespace. Table is indexed on the File ID. |
|
Tablespace |
String |
The name of the tablespace. |
|
Total |
Long |
The total number of bytes allocated for each tablespace. |
|
Used |
Long |
The number of used bytes for each tablespace. |
|
Free |
Long |
The number of free bytes for each tablespace. |
|
% Used |
Integer |
The percentage of bytes allocated that are used for each tablespace. This value is |
Usage Notes
Invoking this method returns disk usage statistics for all tablespaces. This is useful for determining whether the size of a tablespace is approaching its allocated disk space. By using this method in a Hawk rulebase, you can regularly evaluate tablespace usage for the database.