estimate_cost_savings
Creates, updates, deletes, gets or lists an estimate_cost_savings resource.
Overview​
| Name | estimate_cost_savings |
| Type | Resource |
| Id | oci.database.estimate_cost_savings |
Fields​
The following fields are returned by SELECT queries:
- list
List of Cost Estimates.
| Name | Datatype | Description |
|---|---|---|
costSavingsWithElasticPool | number (double) | Estimated cost savings in percentage with elastic pool utilization. |
estimatedUsageWithoutElasticPool | integer (int64) | CPU cost for a given time period under regular billing plan, in ECPU hours. |
isCpuAutoscale | boolean | Indicates if CPU autoscaling is applied. |
timeEnded | string (date-time) | The epoch time at which cost aggregation ends. |
timeStarted | string (date-time) | The epoch time at which cost aggregation starts. |
usageWithElasticPool | integer (int64) | CPU cost for a given time period under elastic pool billing plan, in ECPU hours. |
Methods​
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
list | select | isCpuAutoscale, autonomousDatabaseId, region | opc-request-id, limit, page | Gets the estimate cost savings of the Autonomous AI Database. |
Parameters​
Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.
| Name | Datatype | Description |
|---|---|---|
autonomousDatabaseId | string | The database [OCID](/Content/General/Concepts/identifiers.htm). |
isCpuAutoscale | boolean | If provided as true, cost estimate with cpu autoscaling. |
region | string | OCI region identifier (e.g. us-ashburn-1, ap-sydney-1); resolves from OCI_REGION when not supplied in the query. (default: us-ashburn-1, x-stackQL-envVar: OCI_REGION) |
limit | integer | The maximum number of items to return per page. |
opc-request-id | string | Unique identifier for the request. |
page | string | The pagination token to continue listing from. |
SELECT examples​
- list
Gets the estimate cost savings of the Autonomous AI Database.
SELECT
costSavingsWithElasticPool,
estimatedUsageWithoutElasticPool,
isCpuAutoscale,
timeEnded,
timeStarted,
usageWithElasticPool
FROM oci.database.estimate_cost_savings
WHERE isCpuAutoscale = '{{ isCpuAutoscale }}' -- required
AND autonomousDatabaseId = '{{ autonomousDatabaseId }}' -- required
AND region = '{{ region }}' -- required
AND opc-request-id = '{{ opc-request-id }}'
AND limit = '{{ limit }}'
AND page = '{{ page }}'
;