Oracle Cloud Infrastructure Documentation
Try Free Tier

Autoscaling Common Types

DBMS_CLOUD_OCI_AUTOSCALING_VARCHAR2_TBL Type

Nested table type of varchar2(32767).

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_varchar2_tbl FORCE IS TABLE OF (varchar2(32767)) NOT PERSISTABLE;

DBMS_CLOUD_OCI_AUTOSCALING_ACTION_T Type

The action to take when autoscaling is triggered.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_action_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_type varchar2(32767),
  value number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_action_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_action_t (
    l_type varchar2,
    value number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

l_type

(required) The type of action to take.

Allowed values are: 'CHANGE_COUNT_BY'

value

(required) To scale out (increase the number of instances), provide a positive value. To scale in (decrease the number of instances), provide a negative value.

DBMS_CLOUD_OCI_AUTOSCALING_RESOURCE_T Type

A resource that is managed by an autoscaling configuration. The only supported type is `instancePool`. Each instance pool can have one autoscaling configuration.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_resource_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_type varchar2(32767),
  id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_resource_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_resource_t (
    l_type varchar2,
    id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Field Description

l_type

(required) The type of resource.

id

(required) The OCID of the resource that is managed by the autoscaling configuration.

DBMS_CLOUD_OCI_AUTOSCALING_CAPACITY_T Type

Capacity limits for the instance pool.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_capacity_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_max number,
  l_min number,
  l_initial number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_capacity_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_capacity_t (
    l_max number,
    l_min number,
    l_initial number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

l_max

(optional) For a threshold-based autoscaling policy, this value is the maximum number of instances the instance pool is allowed to increase to (scale out). For a schedule-based autoscaling policy, this value is not used.

l_min

(optional) For a threshold-based autoscaling policy, this value is the minimum number of instances the instance pool is allowed to decrease to (scale in). For a schedule-based autoscaling policy, this value is not used.

l_initial

(optional) For a threshold-based autoscaling policy, this value is the initial number of instances to launch in the instance pool immediately after autoscaling is enabled. After autoscaling retrieves performance metrics, the number of instances is automatically adjusted from this initial number to a number that is based on the limits that you set. For a schedule-based autoscaling policy, this value is the target pool size to scale to when executing the schedule that's defined in the autoscaling policy.

DBMS_CLOUD_OCI_AUTOSCALING_AUTO_SCALING_POLICY_T Type

Autoscaling policies define the criteria that trigger autoscaling actions and the actions to take. An autoscaling policy is part of an autoscaling configuration. For more information, see Autoscaling. You can create the following types of autoscaling policies: - **Schedule-based:** Autoscaling events take place at the specific times that you schedule. - **Threshold-based:** An autoscaling action is triggered when a performance metric meets or exceeds a threshold.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_auto_scaling_policy_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_capacity dbms_cloud_oci_autoscaling_capacity_t,
  id varchar2(32767),
  display_name varchar2(32767),
  policy_type varchar2(32767),
  time_created timestamp with time zone,
  is_enabled number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_auto_scaling_policy_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_auto_scaling_policy_t (
    l_capacity dbms_cloud_oci_autoscaling_capacity_t,
    id varchar2,
    display_name varchar2,
    policy_type varchar2,
    time_created timestamp with time zone,
    is_enabled number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Field Description

l_capacity

(optional) The capacity requirements of the autoscaling policy.

id

(optional) The ID of the autoscaling policy that is assigned after creation.

display_name

(optional) A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.

policy_type

(required) The type of autoscaling policy.

time_created

(required) The date and time the autoscaling configuration was created, in the format defined by RFC3339. Example: `2016-08-25T21:10:29.600Z`

is_enabled

(optional) Whether the autoscaling policy is enabled.

DBMS_CLOUD_OCI_AUTOSCALING_AUTO_SCALING_POLICY_TBL Type

Nested table type of dbms_cloud_oci_autoscaling_auto_scaling_policy_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_auto_scaling_policy_tbl FORCE IS TABLE OF (dbms_cloud_oci_autoscaling_auto_scaling_policy_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_AUTOSCALING_AUTO_SCALING_CONFIGURATION_T Type

An autoscaling configuration lets you dynamically scale the resources in a Compute instance pool. For more information, see Autoscaling.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_auto_scaling_configuration_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  defined_tags json_element_t,
  display_name varchar2(32767),
  freeform_tags json_element_t,
  id varchar2(32767),
  cool_down_in_seconds number,
  is_enabled number,
  l_resource dbms_cloud_oci_autoscaling_resource_t,
  policies dbms_cloud_oci_autoscaling_auto_scaling_policy_tbl,
  time_created timestamp with time zone,
  max_resource_count number,
  min_resource_count number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_auto_scaling_configuration_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_auto_scaling_configuration_t (
    compartment_id varchar2,
    defined_tags json_element_t,
    display_name varchar2,
    freeform_tags json_element_t,
    id varchar2,
    cool_down_in_seconds number,
    is_enabled number,
    l_resource dbms_cloud_oci_autoscaling_resource_t,
    policies dbms_cloud_oci_autoscaling_auto_scaling_policy_tbl,
    time_created timestamp with time zone,
    max_resource_count number,
    min_resource_count number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

compartment_id

(required) The OCID of the compartment containing the autoscaling configuration.

defined_tags

(optional) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: `{\"Operations\": {\"CostCenter\": \"42\"}}`

display_name

(optional) A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.

freeform_tags

(optional) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: `{\"Department\": \"Finance\"}`

id

(required) The OCID of the autoscaling configuration.

cool_down_in_seconds

(optional) For threshold-based autoscaling policies, this value is the minimum period of time to wait between scaling actions. The cooldown period gives the system time to stabilize before rescaling. The minimum value is 300 seconds, which is also the default. The cooldown period starts when the instance pool reaches the running state. For schedule-based autoscaling policies, this value is not used.

is_enabled

(optional) Whether the autoscaling configuration is enabled.

l_resource

(required)

policies

(required) Autoscaling policy definitions for the autoscaling configuration. An autoscaling policy defines the criteria that trigger autoscaling actions and the actions to take.

time_created

(required) The date and time the autoscaling configuration was created, in the format defined by RFC3339. Example: `2016-08-25T21:10:29.600Z`

max_resource_count

(optional) The maximum number of resources to scale out to.

min_resource_count

(optional) The minimum number of resources to scale in to.

DBMS_CLOUD_OCI_AUTOSCALING_AUTO_SCALING_CONFIGURATION_SUMMARY_T Type

Summary information for an autoscaling configuration.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_auto_scaling_configuration_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  id varchar2(32767),
  cool_down_in_seconds number,
  is_enabled number,
  l_resource dbms_cloud_oci_autoscaling_resource_t,
  defined_tags json_element_t,
  freeform_tags json_element_t,
  time_created timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_auto_scaling_configuration_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_auto_scaling_configuration_summary_t (
    compartment_id varchar2,
    display_name varchar2,
    id varchar2,
    cool_down_in_seconds number,
    is_enabled number,
    l_resource dbms_cloud_oci_autoscaling_resource_t,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    time_created timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

compartment_id

(required) The OCID of the compartment containing the autoscaling configuration.

display_name

(optional) A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.

id

(required) The OCID of the autoscaling configuration.

cool_down_in_seconds

(optional) For threshold-based autoscaling policies, this value is the minimum period of time to wait between scaling actions. The cooldown period gives the system time to stabilize before rescaling. The minimum value is 300 seconds, which is also the default. The cooldown period starts when the instance pool reaches the running state. For schedule-based autoscaling policies, this value is not used.

is_enabled

(optional) Whether the autoscaling configuration is enabled.

l_resource

(required)

defined_tags

(optional) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: `{\"Operations\": {\"CostCenter\": \"42\"}}`

freeform_tags

(optional) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: `{\"Department\": \"Finance\"}`

time_created

(required) The date and time the autoscaling configuration was created, in the format defined by RFC3339. Example: `2016-08-25T21:10:29.600Z`

DBMS_CLOUD_OCI_AUTOSCALING_AUTO_SCALING_POLICY_SUMMARY_T Type

Summary information for an autoscaling policy.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_auto_scaling_policy_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  policy_type varchar2(32767),
  is_enabled number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_auto_scaling_policy_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_auto_scaling_policy_summary_t (
    id varchar2,
    display_name varchar2,
    policy_type varchar2,
    is_enabled number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

id

(required) The ID of the autoscaling policy that is assigned after creation.

display_name

(optional) A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.

policy_type

(required) The type of autoscaling policy.

is_enabled

(optional) Whether the autoscaling policy is enabled.

DBMS_CLOUD_OCI_AUTOSCALING_CHANGE_AUTO_SCALING_COMPARTMENT_DETAILS_T Type

The configuration details for the move operation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_change_auto_scaling_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_change_auto_scaling_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_change_auto_scaling_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

compartment_id

(required) The OCID of the compartment to move the autoscaling configuration to.

DBMS_CLOUD_OCI_AUTOSCALING_THRESHOLD_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_threshold_t FORCE AUTHID CURRENT_USER IS OBJECT (
  operator varchar2(32767),
  value number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_threshold_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_threshold_t (
    operator varchar2,
    value number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

operator

(required) The comparison operator to use. Options are greater than (`GT`), greater than or equal to (`GTE`), less than (`LT`), and less than or equal to (`LTE`).

Allowed values are: 'GT', 'GTE', 'LT', 'LTE'

value

(required)

DBMS_CLOUD_OCI_AUTOSCALING_METRIC_T Type

Metric and threshold details for triggering an autoscaling action.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_metric_t FORCE AUTHID CURRENT_USER IS OBJECT (
  metric_type varchar2(32767),
  threshold dbms_cloud_oci_autoscaling_threshold_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_metric_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_metric_t (
    metric_type varchar2,
    threshold dbms_cloud_oci_autoscaling_threshold_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

metric_type

(required)

Allowed values are: 'CPU_UTILIZATION', 'MEMORY_UTILIZATION'

threshold

(required)

DBMS_CLOUD_OCI_AUTOSCALING_CONDITION_T Type

A rule that defines a specific autoscaling action to take (scale in or scale out) and the metric that triggers that action.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_condition_t FORCE AUTHID CURRENT_USER IS OBJECT (
  action dbms_cloud_oci_autoscaling_action_t,
  display_name varchar2(32767),
  id varchar2(32767),
  metric dbms_cloud_oci_autoscaling_metric_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_condition_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_condition_t (
    action dbms_cloud_oci_autoscaling_action_t,
    display_name varchar2,
    id varchar2,
    metric dbms_cloud_oci_autoscaling_metric_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

action

(required)

display_name

(optional) A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.

id

(optional) ID of the condition that is assigned after creation.

metric

(required)

DBMS_CLOUD_OCI_AUTOSCALING_CREATE_AUTO_SCALING_POLICY_DETAILS_T Type

Creation details for an autoscaling policy. You can create the following types of autoscaling policies: - **Schedule-based:** Autoscaling events take place at the specific times that you schedule. - **Threshold-based:** An autoscaling action is triggered when a performance metric meets or exceeds a threshold. An autoscaling configuration can either have multiple schedule-based autoscaling policies, or one threshold-based autoscaling policy.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_create_auto_scaling_policy_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_capacity dbms_cloud_oci_autoscaling_capacity_t,
  display_name varchar2(32767),
  policy_type varchar2(32767),
  is_enabled number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_create_auto_scaling_policy_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_create_auto_scaling_policy_details_t (
    l_capacity dbms_cloud_oci_autoscaling_capacity_t,
    display_name varchar2,
    policy_type varchar2,
    is_enabled number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Field Description

l_capacity

(optional) The capacity requirements of the autoscaling policy.

display_name

(optional) A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.

policy_type

(required) The type of autoscaling policy.

is_enabled

(optional) Whether the autoscaling policy is enabled.

DBMS_CLOUD_OCI_AUTOSCALING_CREATE_AUTO_SCALING_POLICY_DETAILS_TBL Type

Nested table type of dbms_cloud_oci_autoscaling_create_auto_scaling_policy_details_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_create_auto_scaling_policy_details_tbl FORCE IS TABLE OF (dbms_cloud_oci_autoscaling_create_auto_scaling_policy_details_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_AUTOSCALING_CREATE_AUTO_SCALING_CONFIGURATION_DETAILS_T Type

Creation details for an autoscaling configuration.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_create_auto_scaling_configuration_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  defined_tags json_element_t,
  display_name varchar2(32767),
  freeform_tags json_element_t,
  cool_down_in_seconds number,
  is_enabled number,
  policies dbms_cloud_oci_autoscaling_create_auto_scaling_policy_details_tbl,
  l_resource dbms_cloud_oci_autoscaling_resource_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_create_auto_scaling_configuration_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_create_auto_scaling_configuration_details_t (
    compartment_id varchar2,
    defined_tags json_element_t,
    display_name varchar2,
    freeform_tags json_element_t,
    cool_down_in_seconds number,
    is_enabled number,
    policies dbms_cloud_oci_autoscaling_create_auto_scaling_policy_details_tbl,
    l_resource dbms_cloud_oci_autoscaling_resource_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

compartment_id

(required) The OCID of the compartment containing the autoscaling configuration.

defined_tags

(optional) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: `{\"Operations\": {\"CostCenter\": \"42\"}}`

display_name

(optional) A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.

freeform_tags

(optional) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: `{\"Department\": \"Finance\"}`

cool_down_in_seconds

(optional) For threshold-based autoscaling policies, this value is the minimum period of time to wait between scaling actions. The cooldown period gives the system time to stabilize before rescaling. The minimum value is 300 seconds, which is also the default. The cooldown period starts when the instance pool reaches the running state. For schedule-based autoscaling policies, this value is not used.

is_enabled

(optional) Whether the autoscaling configuration is enabled.

policies

(required)

l_resource

(required)

DBMS_CLOUD_OCI_AUTOSCALING_CREATE_CONDITION_DETAILS_T Type

Creation details for a condition in a threshold-based autoscaling policy.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_create_condition_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  action dbms_cloud_oci_autoscaling_action_t,
  display_name varchar2(32767),
  metric dbms_cloud_oci_autoscaling_metric_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_create_condition_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_create_condition_details_t (
    action dbms_cloud_oci_autoscaling_action_t,
    display_name varchar2,
    metric dbms_cloud_oci_autoscaling_metric_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

action

(required)

display_name

(optional) A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.

metric

(required)

DBMS_CLOUD_OCI_AUTOSCALING_EXECUTION_SCHEDULE_T Type

An execution schedule for an autoscaling policy.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_execution_schedule_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_type varchar2(32767),
  timezone varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_execution_schedule_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_execution_schedule_t (
    l_type varchar2,
    timezone varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Field Description

l_type

(required) The type of execution schedule.

timezone

(required) The time zone for the execution schedule.

Allowed values are: 'UTC'

DBMS_CLOUD_OCI_AUTOSCALING_RESOURCE_ACTION_T Type

An action that can be executed against a resource.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_resource_action_t FORCE AUTHID CURRENT_USER IS OBJECT (
  action_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_resource_action_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_resource_action_t (
    action_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Field Description

action_type

(optional) The type of resource action.

DBMS_CLOUD_OCI_AUTOSCALING_CREATE_SCHEDULED_POLICY_DETAILS_T Type

Creation details for a schedule-based autoscaling policy. In a schedule-based autoscaling policy, an autoscaling action is triggered at the scheduled execution time.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_create_scheduled_policy_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_autoscaling_create_auto_scaling_policy_details_t (
  execution_schedule dbms_cloud_oci_autoscaling_execution_schedule_t,
  resource_action dbms_cloud_oci_autoscaling_resource_action_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_create_scheduled_policy_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_create_scheduled_policy_details_t (
    l_capacity dbms_cloud_oci_autoscaling_capacity_t,
    display_name varchar2,
    policy_type varchar2,
    is_enabled number,
    execution_schedule dbms_cloud_oci_autoscaling_execution_schedule_t,
    resource_action dbms_cloud_oci_autoscaling_resource_action_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_autoscaling_create_scheduled_policy_details_t is a subtype of the dbms_cloud_oci_autoscaling_create_auto_scaling_policy_details_t type.

Fields

Field Description

execution_schedule

(required)

resource_action

(optional)

DBMS_CLOUD_OCI_AUTOSCALING_CREATE_CONDITION_DETAILS_TBL Type

Nested table type of dbms_cloud_oci_autoscaling_create_condition_details_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_create_condition_details_tbl FORCE IS TABLE OF (dbms_cloud_oci_autoscaling_create_condition_details_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_AUTOSCALING_CREATE_THRESHOLD_POLICY_DETAILS_T Type

Creation details for a threshold-based autoscaling policy. In a threshold-based autoscaling policy, an autoscaling action is triggered when a performance metric meets or exceeds a threshold.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_create_threshold_policy_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_autoscaling_create_auto_scaling_policy_details_t (
  rules dbms_cloud_oci_autoscaling_create_condition_details_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_create_threshold_policy_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_create_threshold_policy_details_t (
    l_capacity dbms_cloud_oci_autoscaling_capacity_t,
    display_name varchar2,
    policy_type varchar2,
    is_enabled number,
    rules dbms_cloud_oci_autoscaling_create_condition_details_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_autoscaling_create_threshold_policy_details_t is a subtype of the dbms_cloud_oci_autoscaling_create_auto_scaling_policy_details_t type.

Fields

Field Description

rules

(required)

DBMS_CLOUD_OCI_AUTOSCALING_CRON_EXECUTION_SCHEDULE_T Type

An autoscaling execution schedule that uses a cron expression.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_cron_execution_schedule_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_autoscaling_execution_schedule_t (
  expression varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_cron_execution_schedule_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_cron_execution_schedule_t (
    l_type varchar2,
    timezone varchar2,
    expression varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_autoscaling_cron_execution_schedule_t is a subtype of the dbms_cloud_oci_autoscaling_execution_schedule_t type.

Fields

Field Description

expression

(required) A cron expression that represents the time at which to execute the autoscaling policy. Cron expressions have this format: `<second> <minute> <hour> <day of month> <month> <day of week> <year>` You can use special characters that are supported with the Quartz cron implementation. You must specify `0` as the value for seconds. Example: `0 15 10 ? * *`

DBMS_CLOUD_OCI_AUTOSCALING_ERROR_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_error_t FORCE AUTHID CURRENT_USER IS OBJECT (
  code varchar2(32767),
  message varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_error_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_error_t (
    code varchar2,
    message varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

code

(required) A short error code that defines the error, meant for programmatic parsing. See API Errors.

message

(required) A human-readable error string.

DBMS_CLOUD_OCI_AUTOSCALING_INSTANCE_POOL_RESOURCE_T Type

A Compute instance pool.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_instance_pool_resource_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_autoscaling_resource_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_instance_pool_resource_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_instance_pool_resource_t (
    l_type varchar2,
    id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_autoscaling_instance_pool_resource_t is a subtype of the dbms_cloud_oci_autoscaling_resource_t type.

DBMS_CLOUD_OCI_AUTOSCALING_RESOURCE_POWER_ACTION_T Type

A power action against a resource.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_resource_power_action_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_autoscaling_resource_action_t (
  action varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_resource_power_action_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_resource_power_action_t (
    action_type varchar2,
    action varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_autoscaling_resource_power_action_t is a subtype of the dbms_cloud_oci_autoscaling_resource_action_t type.

Fields

Field Description

action

(required)

Allowed values are: 'STOP', 'START', 'SOFTRESET', 'RESET'

DBMS_CLOUD_OCI_AUTOSCALING_SCHEDULED_POLICY_T Type

An autoscaling policy that defines execution schedules for an autoscaling configuration.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_scheduled_policy_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_autoscaling_auto_scaling_policy_t (
  execution_schedule dbms_cloud_oci_autoscaling_execution_schedule_t,
  resource_action dbms_cloud_oci_autoscaling_resource_action_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_scheduled_policy_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_scheduled_policy_t (
    l_capacity dbms_cloud_oci_autoscaling_capacity_t,
    id varchar2,
    display_name varchar2,
    policy_type varchar2,
    time_created timestamp with time zone,
    is_enabled number,
    execution_schedule dbms_cloud_oci_autoscaling_execution_schedule_t,
    resource_action dbms_cloud_oci_autoscaling_resource_action_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_autoscaling_scheduled_policy_t is a subtype of the dbms_cloud_oci_autoscaling_auto_scaling_policy_t type.

Fields

Field Description

execution_schedule

(required) The schedule for executing the autoscaling policy.

resource_action

(optional)

DBMS_CLOUD_OCI_AUTOSCALING_CONDITION_TBL Type

Nested table type of dbms_cloud_oci_autoscaling_condition_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_condition_tbl FORCE IS TABLE OF (dbms_cloud_oci_autoscaling_condition_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_AUTOSCALING_THRESHOLD_POLICY_T Type

An autoscaling policy that defines threshold-based rules for an autoscaling configuration.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_threshold_policy_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_autoscaling_auto_scaling_policy_t (
  rules dbms_cloud_oci_autoscaling_condition_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_threshold_policy_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_threshold_policy_t (
    l_capacity dbms_cloud_oci_autoscaling_capacity_t,
    id varchar2,
    display_name varchar2,
    policy_type varchar2,
    time_created timestamp with time zone,
    is_enabled number,
    rules dbms_cloud_oci_autoscaling_condition_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_autoscaling_threshold_policy_t is a subtype of the dbms_cloud_oci_autoscaling_auto_scaling_policy_t type.

Fields

Field Description

rules

(required)

DBMS_CLOUD_OCI_AUTOSCALING_UPDATE_AUTO_SCALING_CONFIGURATION_DETAILS_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_update_auto_scaling_configuration_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  defined_tags json_element_t,
  display_name varchar2(32767),
  freeform_tags json_element_t,
  is_enabled number,
  cool_down_in_seconds number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_update_auto_scaling_configuration_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_update_auto_scaling_configuration_details_t (
    defined_tags json_element_t,
    display_name varchar2,
    freeform_tags json_element_t,
    is_enabled number,
    cool_down_in_seconds number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

defined_tags

(optional) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: `{\"Operations\": {\"CostCenter\": \"42\"}}`

display_name

(optional) A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.

freeform_tags

(optional) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: `{\"Department\": \"Finance\"}`

is_enabled

(optional) Whether the autoscaling configuration is enabled.

cool_down_in_seconds

(optional)

DBMS_CLOUD_OCI_AUTOSCALING_UPDATE_AUTO_SCALING_POLICY_DETAILS_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_update_auto_scaling_policy_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  l_capacity dbms_cloud_oci_autoscaling_capacity_t,
  policy_type varchar2(32767),
  is_enabled number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_update_auto_scaling_policy_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_update_auto_scaling_policy_details_t (
    display_name varchar2,
    l_capacity dbms_cloud_oci_autoscaling_capacity_t,
    policy_type varchar2,
    is_enabled number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Field Description

display_name

(optional) A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.

l_capacity

(optional) The capacity requirements of the autoscaling policy.

policy_type

(required) Indicates the type of autoscaling policy.

is_enabled

(optional) Whether the autoscaling policy is enabled.

DBMS_CLOUD_OCI_AUTOSCALING_UPDATE_CONDITION_DETAILS_T Type

Update details for a condition in a threshold-based autoscaling policy.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_update_condition_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  action dbms_cloud_oci_autoscaling_action_t,
  display_name varchar2(32767),
  metric dbms_cloud_oci_autoscaling_metric_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_update_condition_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_update_condition_details_t (
    action dbms_cloud_oci_autoscaling_action_t,
    display_name varchar2,
    metric dbms_cloud_oci_autoscaling_metric_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

action

(required)

display_name

(optional) A user-friendly name. Does not have to be unique, and it's changeable. Avoid entering confidential information.

metric

(required)

DBMS_CLOUD_OCI_AUTOSCALING_UPDATE_SCHEDULED_POLICY_DETAILS_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_update_scheduled_policy_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_autoscaling_update_auto_scaling_policy_details_t (
  execution_schedule dbms_cloud_oci_autoscaling_execution_schedule_t,
  resource_action dbms_cloud_oci_autoscaling_resource_action_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_update_scheduled_policy_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_update_scheduled_policy_details_t (
    display_name varchar2,
    l_capacity dbms_cloud_oci_autoscaling_capacity_t,
    policy_type varchar2,
    is_enabled number,
    execution_schedule dbms_cloud_oci_autoscaling_execution_schedule_t,
    resource_action dbms_cloud_oci_autoscaling_resource_action_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_autoscaling_update_scheduled_policy_details_t is a subtype of the dbms_cloud_oci_autoscaling_update_auto_scaling_policy_details_t type.

Fields

Field Description

execution_schedule

(optional) The schedule for executing the autoscaling policy.

resource_action

(optional)

DBMS_CLOUD_OCI_AUTOSCALING_UPDATE_CONDITION_DETAILS_TBL Type

Nested table type of dbms_cloud_oci_autoscaling_update_condition_details_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_update_condition_details_tbl FORCE IS TABLE OF (dbms_cloud_oci_autoscaling_update_condition_details_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_AUTOSCALING_UPDATE_THRESHOLD_POLICY_DETAILS_T Type

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_autoscaling_update_threshold_policy_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_autoscaling_update_auto_scaling_policy_details_t (
  rules dbms_cloud_oci_autoscaling_update_condition_details_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_update_threshold_policy_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_autoscaling_update_threshold_policy_details_t (
    display_name varchar2,
    l_capacity dbms_cloud_oci_autoscaling_capacity_t,
    policy_type varchar2,
    is_enabled number,
    rules dbms_cloud_oci_autoscaling_update_condition_details_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_autoscaling_update_threshold_policy_details_t is a subtype of the dbms_cloud_oci_autoscaling_update_auto_scaling_policy_details_t type.

Fields

Field Description

rules

(optional)

Was this article helpful?