steampipe plugin install oci

Table: oci_autoscaling_auto_scaling_policy - Query OCI Autoscaling Auto Scaling Policies using SQL

An OCI Autoscaling Auto Scaling Policy is a feature of Oracle Cloud Infrastructure that automatically adjusts the number of instances in an instance pool based on performance metrics. It allows you to maintain the performance of your applications and manage costs by adjusting the number of instances in response to changes in workload patterns. OCI Autoscaling Auto Scaling Policy helps you ensure that you have the appropriate number of Oracle Cloud Infrastructure Compute instances available to handle the load for your application.

Table Usage Guide

The oci_autoscaling_auto_scaling_policy table provides insights into auto scaling policies within Oracle Cloud Infrastructure Autoscaling. As a Cloud Administrator, explore policy-specific details through this table, including the capacity, policy type, and associated metadata. Utilize it to uncover information about policies, such as their current status, the adjustments made in response to workload changes, and the verification of policy configurations.

Examples

Basic info

Assess the elements within your autoscaling policies to understand their current status. This can help in identifying if they are enabled and their capacity, which is useful for managing resource allocation and scaling operations.

select
capacity,
id,
display_name,
is_enabled,
policy_type
from
oci_autoscaling_auto_scaling_policy;
select
capacity,
id,
display_name,
is_enabled,
policy_type
from
oci_autoscaling_auto_scaling_policy;

List enabled policies

Explore which autoscaling policies are currently active. This can be useful for assessing system performance and identifying areas for optimization.

select
display_name,
id,
policy_type,
time_created,
is_enabled
from
oci_autoscaling_auto_scaling_policy
where
is_enabled;
select
display_name,
id,
policy_type,
time_created,
is_enabled
from
oci_autoscaling_auto_scaling_policy
where
is_enabled;

List threshold policies

Explore which auto-scaling policies in your OCI environment are of the 'threshold' type. This can help you manage and optimize your resource allocation, by understanding which policies are actively scaling resources based on defined thresholds.

select
display_name,
id,
policy_type,
time_created,
is_enabled
from
oci_autoscaling_auto_scaling_policy
where
policy_type = 'threshold';
select
display_name,
id,
policy_type,
time_created,
is_enabled
from
oci_autoscaling_auto_scaling_policy
where
policy_type = 'threshold';

List policies older than 30 days

Explore which autoscaling policies have been active for more than 30 days. This can help in assessing the efficiency and relevance of these policies in the current context.

select
display_name,
id,
policy_type,
time_created,
is_enabled
from
oci_autoscaling_auto_scaling_policy
where
time_created <= now() - interval '30' day;
select
display_name,
id,
policy_type,
time_created,
is_enabled
from
oci_autoscaling_auto_scaling_policy
where
time_created <= datetime('now', '-30 day');

Get capacity details of each policy

Explore the capacity details of each policy to understand the initial, maximum, and minimum capacity settings. This information can be useful for managing and optimizing the performance of your auto-scaling policies.

select
display_name,
id,
capacity ->> 'initial' as initial_capacity,
capacity ->> 'max' as maximum_capacity,
capacity ->> 'min' as minimum_capacity
from
oci_autoscaling_auto_scaling_policy;
select
display_name,
id,
json_extract(capacity, '$.initial') as initial_capacity,
json_extract(capacity, '$.max') as maximum_capacity,
json_extract(capacity, '$.min') as minimum_capacity
from
oci_autoscaling_auto_scaling_policy;

Get autoscaling configuration details of each policy

Discover the autoscaling configuration details of each policy to better understand your resource management and to assess if your current settings are optimized for your needs. This will help in managing resources efficiently and effectively, ensuring optimal performance.

select
p.display_name,
p.id,
p.auto_scaling_configuration_id,
c.cool_down_in_seconds,
c.max_resource_count,
c.min_resource_count
from
oci_autoscaling_auto_scaling_policy as p,
oci_autoscaling_auto_scaling_configuration as c
where
p.auto_scaling_configuration_id = c.id;
select
p.display_name,
p.id,
p.auto_scaling_configuration_id,
c.cool_down_in_seconds,
c.max_resource_count,
c.min_resource_count
from
oci_autoscaling_auto_scaling_policy as p,
oci_autoscaling_auto_scaling_configuration as c
where
p.auto_scaling_configuration_id = c.id;

Schema for oci_autoscaling_auto_scaling_policy

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
auto_scaling_configuration_idtext=The OCID of the autoscaling configuration.
capacityjsonbThe capacity requirements of the autoscaling policy.
compartment_idtextThe OCID of the compartment in Tenant in which the resource is located.
display_nametext=A user-friendly name. Does not have to be unique, and it's changeable.
idtext=The ID of the autoscaling policy that is assigned after creation.
is_enabledbooleanWhether the autoscaling policy is enabled.
policy_typetextThe type of autoscaling policy.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
tenant_idtext=, !=, ~~, ~~*, !~~, !~~*The OCID of the Tenant in which the resource is located.
time_createdtimestamp with time zoneTime that autoscaling policy was created.
titletextTitle of the resource.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- oci

You can pass the configuration to the command with the --config argument:

steampipe_export_oci --config '<your_config>' oci_autoscaling_auto_scaling_policy