Optimizer Functions

Package: DBMS_CLOUD_OCI_OP_OPTIMIZER

BULK_APPLY_RECOMMENDATIONS Function

Applies the specified recommendations to the resources.

Syntax

FUNCTION bulk_apply_recommendations (
  recommendation_id varchar2,
  bulk_apply_recommendations_details dbms_cloud_oci_optimizer_bulk_apply_recommendations_details_t,
  opc_request_id varchar2 DEFAULT NULL,
  opc_retry_token varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_bulk_apply_recommendations_response_t;

Parameters

Parameter	Description
`recommendation_id`	(required) The unique OCID associated with the recommendation.
`bulk_apply_recommendations_details`	(required) Details about bulk recommendation actions.
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`opc_retry_token`	(optional) A token that uniquely identifies a request so it can be retried in case of a timeout or server error without risk of executing that same action again. Retry tokens expire after 24 hours, but can be invalidated before then due to conflicting operations (for example, if a resource has been deleted and purged from the system, then a retry of the original creation request may be rejected).
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

CREATE_PROFILE Function

Creates a new profile.

Syntax

FUNCTION create_profile (
  create_profile_details dbms_cloud_oci_optimizer_create_profile_details_t,
  opc_request_id varchar2 DEFAULT NULL,
  opc_retry_token varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_create_profile_response_t;

Parameters

Parameter	Description
`create_profile_details`	(required) Details for creating the profile.
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`opc_retry_token`	(optional) A token that uniquely identifies a request so it can be retried in case of a timeout or server error without risk of executing that same action again. Retry tokens expire after 24 hours, but can be invalidated before then due to conflicting operations (for example, if a resource has been deleted and purged from the system, then a retry of the original creation request may be rejected).
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

DELETE_PROFILE Function

Deletes the specified profile. Uses the profile's OCID to determine which profile to delete.

Syntax

FUNCTION delete_profile (
  profile_id varchar2,
  if_match varchar2 DEFAULT NULL,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_delete_profile_response_t;

Parameters

Parameter	Description
`profile_id`	(required) The unique OCID of the profile.
`if_match`	(optional) For optimistic concurrency control. In the PUT or DELETE call for a resource, set the `if-match` parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value.
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

FILTER_RESOURCE_ACTIONS Function

Queries the Cloud Advisor resource actions that are supported.

Syntax

FUNCTION filter_resource_actions (
  compartment_id varchar2,
  compartment_id_in_subtree number,
  query_details dbms_cloud_oci_optimizer_query_details_t,
  recommendation_id varchar2 DEFAULT NULL,
  recommendation_name varchar2 DEFAULT NULL,
  child_tenancy_ids dbms_cloud_oci_optimizer_varchar2_tbl DEFAULT NULL,
  include_organization number DEFAULT NULL,
  include_resource_metadata number DEFAULT NULL,
  limit number DEFAULT NULL,
  page varchar2 DEFAULT NULL,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_filter_resource_actions_response_t;

Parameters

Parameter	Description
`compartment_id`	(required) The OCID of the compartment.
`compartment_id_in_subtree`	(required) When set to true, the hierarchy of compartments is traversed and all compartments and subcompartments in the tenancy are returned depending on the the setting of `accessLevel`. Can only be set to true when performing ListCompartments on the tenancy (root compartment).
`query_details`	(required) The request parameters that describe the query criteria.
`recommendation_id`	(optional) The unique OCID associated with the recommendation.
`recommendation_name`	(optional) Optional. A filter that returns results that match the recommendation name specified.
`child_tenancy_ids`	(optional) A list of child tenancies for which the respective data will be returned. Please note that the parent tenancy id can also be included in this list. For example, if there is a parent P with two children A and B, to return results of only parent P and child A, this list should be populated with tenancy id of parent P and child A. If this list contains a tenancy id that isn't part of the organization of parent P, the request will fail. That is, let's say there is an organization with parent P with children A and B, and also one other tenant T that isn't part of the organization. If T is included in the list of childTenancyIds, the request will fail. It is important to note that if you are setting the includeOrganization parameter value as true and also populating the childTenancyIds parameter with a list of child tenancies, the request will fail. The childTenancyIds and includeOrganization should be used exclusively. When using this parameter, please make sure to set the compartmentId with the parent tenancy ID.
`include_organization`	(optional) When set to true, the data for all child tenancies including the parent is returned. That is, if there is an organization with parent P and children A and B, to return the data for the parent P, child A and child B, this parameter value should be set to true. Please note that this parameter shouldn't be used along with childTenancyIds parameter. If you would like to get results specifically for parent P and only child A, use the childTenancyIds parameter and populate the list with tenancy id of P and A. When using this parameter, please make sure to set the compartmentId with the parent tenancy ID.
`include_resource_metadata`	(optional) Supplement additional resource information in extended metadata response.
`limit`	(optional) The maximum number of items to return in a paginated \"List\" call.
`page`	(optional) The value of the `opc-next-page` response header from the previous \"List\" call.
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

GET_CATEGORY Function

Gets the category that corresponds to the specified OCID.

Syntax

FUNCTION get_category (
  category_id varchar2,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_get_category_response_t;

Parameters

Parameter	Description
`category_id`	(required) The unique OCID associated with the category.
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

GET_ENROLLMENT_STATUS Function

Gets the Cloud Advisor enrollment status.

Syntax

FUNCTION get_enrollment_status (
  enrollment_status_id varchar2,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_get_enrollment_status_response_t;

Parameters

Parameter	Description
`enrollment_status_id`	(required) The unique OCID associated with the enrollment status.
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

GET_PROFILE Function

Gets the specified profile's information. Uses the profile's OCID to determine which profile to retrieve.

Syntax

FUNCTION get_profile (
  profile_id varchar2,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_get_profile_response_t;

Parameters

Parameter	Description
`profile_id`	(required) The unique OCID of the profile.
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

GET_RECOMMENDATION Function

Gets the recommendation for the specified OCID.

Syntax

FUNCTION get_recommendation (
  recommendation_id varchar2,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_get_recommendation_response_t;

Parameters

Parameter	Description
`recommendation_id`	(required) The unique OCID associated with the recommendation.
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

GET_RESOURCE_ACTION Function

Gets the resource action that corresponds to the specified OCID.

Syntax

FUNCTION get_resource_action (
  resource_action_id varchar2,
  include_resource_metadata number DEFAULT NULL,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_get_resource_action_response_t;

Parameters

Parameter	Description
`resource_action_id`	(required) The unique OCID associated with the resource action.
`include_resource_metadata`	(optional) Supplement additional resource information in extended metadata response.
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

GET_WORK_REQUEST Function

Gets the status of the work request associated with the specified ID.

Syntax

FUNCTION get_work_request (
  work_request_id varchar2,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_get_work_request_response_t;

Parameters

Parameter	Description
`work_request_id`	(required) The OCID of the work request.
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

LIST_CATEGORIES Function

Lists the supported Cloud Advisor categories.

Syntax

FUNCTION list_categories (
  compartment_id varchar2,
  compartment_id_in_subtree number,
  child_tenancy_ids dbms_cloud_oci_optimizer_varchar2_tbl DEFAULT NULL,
  include_organization number DEFAULT NULL,
  name varchar2 DEFAULT NULL,
  limit number DEFAULT NULL,
  page varchar2 DEFAULT NULL,
  sort_order varchar2 DEFAULT NULL,
  sort_by varchar2 DEFAULT NULL,
  lifecycle_state varchar2 DEFAULT NULL,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_list_categories_response_t;

Parameters

Parameter	Description
`compartment_id`	(required) The OCID of the compartment.
`compartment_id_in_subtree`	(required) When set to true, the hierarchy of compartments is traversed and all compartments and subcompartments in the tenancy are returned depending on the the setting of `accessLevel`. Can only be set to true when performing ListCompartments on the tenancy (root compartment).
`child_tenancy_ids`	(optional) A list of child tenancies for which the respective data will be returned. Please note that the parent tenancy id can also be included in this list. For example, if there is a parent P with two children A and B, to return results of only parent P and child A, this list should be populated with tenancy id of parent P and child A. If this list contains a tenancy id that isn't part of the organization of parent P, the request will fail. That is, let's say there is an organization with parent P with children A and B, and also one other tenant T that isn't part of the organization. If T is included in the list of childTenancyIds, the request will fail. It is important to note that if you are setting the includeOrganization parameter value as true and also populating the childTenancyIds parameter with a list of child tenancies, the request will fail. The childTenancyIds and includeOrganization should be used exclusively. When using this parameter, please make sure to set the compartmentId with the parent tenancy ID.
`include_organization`	(optional) When set to true, the data for all child tenancies including the parent is returned. That is, if there is an organization with parent P and children A and B, to return the data for the parent P, child A and child B, this parameter value should be set to true. Please note that this parameter shouldn't be used along with childTenancyIds parameter. If you would like to get results specifically for parent P and only child A, use the childTenancyIds parameter and populate the list with tenancy id of P and A. When using this parameter, please make sure to set the compartmentId with the parent tenancy ID.
`name`	(optional) Optional. A filter that returns results that match the name specified.
`limit`	(optional) The maximum number of items to return in a paginated \"List\" call.
`page`	(optional) The value of the `opc-next-page` response header from the previous \"List\" call.
`sort_order`	(optional) The sort order to use, either ascending (`ASC`) or descending (`DESC`). Allowed values are: 'ASC', 'DESC'
`sort_by`	(optional) The field to sort by. You can provide one sort order (`sortOrder`). Default order for TIMECREATED is descending. Default order for NAME is ascending. The NAME sort order is case sensitive. Allowed values are: 'NAME', 'TIMECREATED'
`lifecycle_state`	(optional) A filter that returns results that match the lifecycle state specified. Allowed values are: 'ACTIVE', 'FAILED', 'INACTIVE', 'ATTACHING', 'DETACHING', 'DELETING', 'DELETED', 'UPDATING', 'CREATING'
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

LIST_ENROLLMENT_STATUSES Function

Lists the Cloud Advisor enrollment statuses.

Syntax

FUNCTION list_enrollment_statuses (
  compartment_id varchar2,
  limit number DEFAULT NULL,
  page varchar2 DEFAULT NULL,
  sort_order varchar2 DEFAULT NULL,
  sort_by varchar2 DEFAULT NULL,
  lifecycle_state varchar2 DEFAULT NULL,
  status varchar2 DEFAULT NULL,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_list_enrollment_statuses_response_t;

Parameters

Parameter	Description
`compartment_id`	(required) The OCID of the compartment.
`limit`	(optional) The maximum number of items to return in a paginated \"List\" call.
`page`	(optional) The value of the `opc-next-page` response header from the previous \"List\" call.
`sort_order`	(optional) The sort order to use, either ascending (`ASC`) or descending (`DESC`). Allowed values are: 'ASC', 'DESC'
`sort_by`	(optional) The field to sort by. You can provide one sort order (`sortOrder`). Default order for TIMECREATED is descending. Default order for NAME is ascending. The NAME sort order is case sensitive. Allowed values are: 'NAME', 'TIMECREATED'
`lifecycle_state`	(optional) A filter that returns results that match the lifecycle state specified. Allowed values are: 'ACTIVE', 'FAILED', 'INACTIVE', 'ATTACHING', 'DETACHING', 'DELETING', 'DELETED', 'UPDATING', 'CREATING'
`status`	(optional) A filter that returns results that match the Cloud Advisor enrollment status specified. Allowed values are: 'ACTIVE', 'INACTIVE'
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

LIST_HISTORIES Function

Lists changes to the recommendations based on user activity. For example, lists when recommendations have been implemented, dismissed, postponed, or reactivated.

Syntax

FUNCTION list_histories (
  compartment_id varchar2,
  compartment_id_in_subtree number,
  name varchar2 DEFAULT NULL,
  recommendation_name varchar2 DEFAULT NULL,
  recommendation_id varchar2 DEFAULT NULL,
  resource_type varchar2 DEFAULT NULL,
  limit number DEFAULT NULL,
  page varchar2 DEFAULT NULL,
  sort_order varchar2 DEFAULT NULL,
  sort_by varchar2 DEFAULT NULL,
  lifecycle_state varchar2 DEFAULT NULL,
  status varchar2 DEFAULT NULL,
  include_resource_metadata number DEFAULT NULL,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_list_histories_response_t;

Parameters

Parameter	Description
`compartment_id`	(required) The OCID of the compartment.
`compartment_id_in_subtree`	(required) When set to true, the hierarchy of compartments is traversed and all compartments and subcompartments in the tenancy are returned depending on the the setting of `accessLevel`. Can only be set to true when performing ListCompartments on the tenancy (root compartment).
`name`	(optional) Optional. A filter that returns results that match the name specified.
`recommendation_name`	(optional) Optional. A filter that returns results that match the recommendation name specified.
`recommendation_id`	(optional) The unique OCID associated with the recommendation.
`resource_type`	(optional) Optional. A filter that returns results that match the resource type specified.
`limit`	(optional) The maximum number of items to return in a paginated \"List\" call.
`page`	(optional) The value of the `opc-next-page` response header from the previous \"List\" call.
`sort_order`	(optional) The sort order to use, either ascending (`ASC`) or descending (`DESC`). Allowed values are: 'ASC', 'DESC'
`sort_by`	(optional) The field to sort by. You can provide one sort order (`sortOrder`). Default order for TIMECREATED is descending. Default order for NAME is ascending. The NAME sort order is case sensitive. Allowed values are: 'NAME', 'TIMECREATED'
`lifecycle_state`	(optional) A filter that returns results that match the lifecycle state specified. Allowed values are: 'ACTIVE', 'FAILED', 'INACTIVE', 'ATTACHING', 'DETACHING', 'DELETING', 'DELETED', 'UPDATING', 'CREATING'
`status`	(optional) A filter that returns recommendations that match the status specified. Allowed values are: 'PENDING', 'DISMISSED', 'POSTPONED', 'IMPLEMENTED'
`include_resource_metadata`	(optional) Supplement additional resource information in extended metadata response.
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

LIST_PROFILE_LEVELS Function

Lists the existing profile levels.

Syntax

FUNCTION list_profile_levels (
  compartment_id varchar2,
  compartment_id_in_subtree number,
  name varchar2 DEFAULT NULL,
  recommendation_name varchar2 DEFAULT NULL,
  limit number DEFAULT NULL,
  page varchar2 DEFAULT NULL,
  sort_order varchar2 DEFAULT NULL,
  sort_by varchar2 DEFAULT NULL,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_list_profile_levels_response_t;

Parameters

Parameter	Description
`compartment_id`	(required) The OCID of the compartment.
`compartment_id_in_subtree`	(required) When set to true, the hierarchy of compartments is traversed and all compartments and subcompartments in the tenancy are returned depending on the the setting of `accessLevel`. Can only be set to true when performing ListCompartments on the tenancy (root compartment).
`name`	(optional) Optional. A filter that returns results that match the name specified.
`recommendation_name`	(optional) Optional. A filter that returns results that match the recommendation name specified.
`limit`	(optional) The maximum number of items to return in a paginated \"List\" call.
`page`	(optional) The value of the `opc-next-page` response header from the previous \"List\" call.
`sort_order`	(optional) The sort order to use, either ascending (`ASC`) or descending (`DESC`). Allowed values are: 'ASC', 'DESC'
`sort_by`	(optional) The field to sort by. You can provide one sort order (`sortOrder`). Default order for TIMECREATED is descending. Default order for NAME is ascending. The NAME sort order is case sensitive. Allowed values are: 'NAME', 'TIMECREATED'
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

LIST_PROFILES Function

Lists the existing profiles.

Syntax

FUNCTION list_profiles (
  compartment_id varchar2,
  name varchar2 DEFAULT NULL,
  limit number DEFAULT NULL,
  page varchar2 DEFAULT NULL,
  sort_order varchar2 DEFAULT NULL,
  sort_by varchar2 DEFAULT NULL,
  lifecycle_state varchar2 DEFAULT NULL,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_list_profiles_response_t;

Parameters

Parameter	Description
`compartment_id`	(required) The OCID of the compartment.
`name`	(optional) Optional. A filter that returns results that match the name specified.
`limit`	(optional) The maximum number of items to return in a paginated \"List\" call.
`page`	(optional) The value of the `opc-next-page` response header from the previous \"List\" call.
`sort_order`	(optional) The sort order to use, either ascending (`ASC`) or descending (`DESC`). Allowed values are: 'ASC', 'DESC'
`sort_by`	(optional) The field to sort by. You can provide one sort order (`sortOrder`). Default order for TIMECREATED is descending. Default order for NAME is ascending. The NAME sort order is case sensitive. Allowed values are: 'NAME', 'TIMECREATED'
`lifecycle_state`	(optional) A filter that returns results that match the lifecycle state specified. Allowed values are: 'ACTIVE', 'FAILED', 'INACTIVE', 'ATTACHING', 'DETACHING', 'DELETING', 'DELETED', 'UPDATING', 'CREATING'
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

LIST_RECOMMENDATION_STRATEGIES Function

Lists the existing strategies.

Syntax

FUNCTION list_recommendation_strategies (
  compartment_id varchar2,
  compartment_id_in_subtree number,
  name varchar2 DEFAULT NULL,
  recommendation_name varchar2 DEFAULT NULL,
  limit number DEFAULT NULL,
  page varchar2 DEFAULT NULL,
  sort_order varchar2 DEFAULT NULL,
  sort_by varchar2 DEFAULT NULL,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_list_recommendation_strategies_response_t;

Parameters

Parameter	Description
`compartment_id`	(required) The OCID of the compartment.
`compartment_id_in_subtree`	(required) When set to true, the hierarchy of compartments is traversed and all compartments and subcompartments in the tenancy are returned depending on the the setting of `accessLevel`. Can only be set to true when performing ListCompartments on the tenancy (root compartment).
`name`	(optional) Optional. A filter that returns results that match the name specified.
`recommendation_name`	(optional) Optional. A filter that returns results that match the recommendation name specified.
`limit`	(optional) The maximum number of items to return in a paginated \"List\" call.
`page`	(optional) The value of the `opc-next-page` response header from the previous \"List\" call.
`sort_order`	(optional) The sort order to use, either ascending (`ASC`) or descending (`DESC`). Allowed values are: 'ASC', 'DESC'
`sort_by`	(optional) The field to sort by. You can provide one sort order (`sortOrder`). Default order for TIMECREATED is descending. Default order for NAME is ascending. The NAME sort order is case sensitive. Allowed values are: 'NAME', 'TIMECREATED'
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

LIST_RECOMMENDATIONS Function

Lists the Cloud Advisor recommendations that are currently supported.

Syntax

FUNCTION list_recommendations (
  compartment_id varchar2,
  compartment_id_in_subtree number,
  category_id varchar2 DEFAULT NULL,
  category_name varchar2 DEFAULT NULL,
  child_tenancy_ids dbms_cloud_oci_optimizer_varchar2_tbl DEFAULT NULL,
  include_organization number DEFAULT NULL,
  name varchar2 DEFAULT NULL,
  limit number DEFAULT NULL,
  page varchar2 DEFAULT NULL,
  sort_order varchar2 DEFAULT NULL,
  sort_by varchar2 DEFAULT NULL,
  lifecycle_state varchar2 DEFAULT NULL,
  status varchar2 DEFAULT NULL,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_list_recommendations_response_t;

Parameters

Parameter	Description
`compartment_id`	(required) The OCID of the compartment.
`compartment_id_in_subtree`	(required) When set to true, the hierarchy of compartments is traversed and all compartments and subcompartments in the tenancy are returned depending on the the setting of `accessLevel`. Can only be set to true when performing ListCompartments on the tenancy (root compartment).
`category_id`	(optional) The unique OCID associated with the category.
`category_name`	(optional) Optional. A filter that returns results that match the category name specified.
`child_tenancy_ids`	(optional) A list of child tenancies for which the respective data will be returned. Please note that the parent tenancy id can also be included in this list. For example, if there is a parent P with two children A and B, to return results of only parent P and child A, this list should be populated with tenancy id of parent P and child A. If this list contains a tenancy id that isn't part of the organization of parent P, the request will fail. That is, let's say there is an organization with parent P with children A and B, and also one other tenant T that isn't part of the organization. If T is included in the list of childTenancyIds, the request will fail. It is important to note that if you are setting the includeOrganization parameter value as true and also populating the childTenancyIds parameter with a list of child tenancies, the request will fail. The childTenancyIds and includeOrganization should be used exclusively. When using this parameter, please make sure to set the compartmentId with the parent tenancy ID.
`include_organization`	(optional) When set to true, the data for all child tenancies including the parent is returned. That is, if there is an organization with parent P and children A and B, to return the data for the parent P, child A and child B, this parameter value should be set to true. Please note that this parameter shouldn't be used along with childTenancyIds parameter. If you would like to get results specifically for parent P and only child A, use the childTenancyIds parameter and populate the list with tenancy id of P and A. When using this parameter, please make sure to set the compartmentId with the parent tenancy ID.
`name`	(optional) Optional. A filter that returns results that match the name specified.
`limit`	(optional) The maximum number of items to return in a paginated \"List\" call.
`page`	(optional) The value of the `opc-next-page` response header from the previous \"List\" call.
`sort_order`	(optional) The sort order to use, either ascending (`ASC`) or descending (`DESC`). Allowed values are: 'ASC', 'DESC'
`sort_by`	(optional) The field to sort by. You can provide one sort order (`sortOrder`). Default order for TIMECREATED is descending. Default order for NAME is ascending. The NAME sort order is case sensitive. Allowed values are: 'NAME', 'TIMECREATED'
`lifecycle_state`	(optional) A filter that returns results that match the lifecycle state specified. Allowed values are: 'ACTIVE', 'FAILED', 'INACTIVE', 'ATTACHING', 'DETACHING', 'DELETING', 'DELETED', 'UPDATING', 'CREATING'
`status`	(optional) A filter that returns recommendations that match the status specified. Allowed values are: 'PENDING', 'DISMISSED', 'POSTPONED', 'IMPLEMENTED'
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

LIST_RESOURCE_ACTION_QUERYABLE_FIELDS Function

Lists the fields that are indexed for querying and their associated value types.

Syntax

FUNCTION list_resource_action_queryable_fields (
  compartment_id varchar2,
  compartment_id_in_subtree number,
  limit number DEFAULT NULL,
  page varchar2 DEFAULT NULL,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_list_resource_action_queryable_fields_response_t;

Parameters

Parameter	Description
`compartment_id`	(required) The OCID of the compartment.
`compartment_id_in_subtree`	(required) When set to true, the hierarchy of compartments is traversed and all compartments and subcompartments in the tenancy are returned depending on the the setting of `accessLevel`. Can only be set to true when performing ListCompartments on the tenancy (root compartment).
`limit`	(optional) The maximum number of items to return in a paginated \"List\" call.
`page`	(optional) The value of the `opc-next-page` response header from the previous \"List\" call.
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

LIST_RESOURCE_ACTIONS Function

Lists the Cloud Advisor resource actions that are supported.

Syntax

FUNCTION list_resource_actions (
  compartment_id varchar2,
  compartment_id_in_subtree number,
  recommendation_id varchar2 DEFAULT NULL,
  recommendation_name varchar2 DEFAULT NULL,
  child_tenancy_ids dbms_cloud_oci_optimizer_varchar2_tbl DEFAULT NULL,
  include_organization number DEFAULT NULL,
  name varchar2 DEFAULT NULL,
  resource_type varchar2 DEFAULT NULL,
  limit number DEFAULT NULL,
  page varchar2 DEFAULT NULL,
  sort_order varchar2 DEFAULT NULL,
  sort_by varchar2 DEFAULT NULL,
  lifecycle_state varchar2 DEFAULT NULL,
  status varchar2 DEFAULT NULL,
  include_resource_metadata number DEFAULT NULL,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_list_resource_actions_response_t;

Parameters

Parameter	Description
`compartment_id`	(required) The OCID of the compartment.
`compartment_id_in_subtree`	(required) When set to true, the hierarchy of compartments is traversed and all compartments and subcompartments in the tenancy are returned depending on the the setting of `accessLevel`. Can only be set to true when performing ListCompartments on the tenancy (root compartment).
`recommendation_id`	(optional) The unique OCID associated with the recommendation.
`recommendation_name`	(optional) Optional. A filter that returns results that match the recommendation name specified.
`child_tenancy_ids`	(optional) A list of child tenancies for which the respective data will be returned. Please note that the parent tenancy id can also be included in this list. For example, if there is a parent P with two children A and B, to return results of only parent P and child A, this list should be populated with tenancy id of parent P and child A. If this list contains a tenancy id that isn't part of the organization of parent P, the request will fail. That is, let's say there is an organization with parent P with children A and B, and also one other tenant T that isn't part of the organization. If T is included in the list of childTenancyIds, the request will fail. It is important to note that if you are setting the includeOrganization parameter value as true and also populating the childTenancyIds parameter with a list of child tenancies, the request will fail. The childTenancyIds and includeOrganization should be used exclusively. When using this parameter, please make sure to set the compartmentId with the parent tenancy ID.
`include_organization`	(optional) When set to true, the data for all child tenancies including the parent is returned. That is, if there is an organization with parent P and children A and B, to return the data for the parent P, child A and child B, this parameter value should be set to true. Please note that this parameter shouldn't be used along with childTenancyIds parameter. If you would like to get results specifically for parent P and only child A, use the childTenancyIds parameter and populate the list with tenancy id of P and A. When using this parameter, please make sure to set the compartmentId with the parent tenancy ID.
`name`	(optional) Optional. A filter that returns results that match the name specified.
`resource_type`	(optional) Optional. A filter that returns results that match the resource type specified.
`limit`	(optional) The maximum number of items to return in a paginated \"List\" call.
`page`	(optional) The value of the `opc-next-page` response header from the previous \"List\" call.
`sort_order`	(optional) The sort order to use, either ascending (`ASC`) or descending (`DESC`). Allowed values are: 'ASC', 'DESC'
`sort_by`	(optional) The field to sort by. You can provide one sort order (`sortOrder`). Default order for TIMECREATED is descending. Default order for NAME is ascending. The NAME sort order is case sensitive. Allowed values are: 'NAME', 'TIMECREATED'
`lifecycle_state`	(optional) A filter that returns results that match the lifecycle state specified. Allowed values are: 'ACTIVE', 'FAILED', 'INACTIVE', 'ATTACHING', 'DETACHING', 'DELETING', 'DELETED', 'UPDATING', 'CREATING'
`status`	(optional) A filter that returns recommendations that match the status specified. Allowed values are: 'PENDING', 'DISMISSED', 'POSTPONED', 'IMPLEMENTED'
`include_resource_metadata`	(optional) Supplement additional resource information in extended metadata response.
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

LIST_WORK_REQUEST_ERRORS Function

Lists errors associated with the specified work request.

Syntax

FUNCTION list_work_request_errors (
  work_request_id varchar2,
  page varchar2 DEFAULT NULL,
  limit number DEFAULT NULL,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_list_work_request_errors_response_t;

Parameters

Parameter	Description
`work_request_id`	(required) The OCID of the work request.
`page`	(optional) The value of the `opc-next-page` response header from the previous \"List\" call.
`limit`	(optional) The maximum number of items to return in a paginated \"List\" call.
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

LIST_WORK_REQUEST_LOGS Function

Lists the logs associated with the specified work request.

Syntax

FUNCTION list_work_request_logs (
  work_request_id varchar2,
  page varchar2 DEFAULT NULL,
  limit number DEFAULT NULL,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_list_work_request_logs_response_t;

Parameters

Parameter	Description
`work_request_id`	(required) The OCID of the work request.
`page`	(optional) The value of the `opc-next-page` response header from the previous \"List\" call.
`limit`	(optional) The maximum number of items to return in a paginated \"List\" call.
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

LIST_WORK_REQUESTS Function

Lists the work requests in the tenancy. The tenancy is the root compartment.

Syntax

FUNCTION list_work_requests (
  compartment_id varchar2,
  page varchar2 DEFAULT NULL,
  limit number DEFAULT NULL,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_list_work_requests_response_t;

Parameters

Parameter	Description
`compartment_id`	(required) The OCID of the compartment.
`page`	(optional) The value of the `opc-next-page` response header from the previous \"List\" call.
`limit`	(optional) The maximum number of items to return in a paginated \"List\" call.
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

UPDATE_ENROLLMENT_STATUS Function

Updates the enrollment status of the tenancy.

Syntax

FUNCTION update_enrollment_status (
  enrollment_status_id varchar2,
  update_enrollment_status_details dbms_cloud_oci_optimizer_update_enrollment_status_details_t,
  opc_request_id varchar2 DEFAULT NULL,
  if_match varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_update_enrollment_status_response_t;

Parameters

Parameter	Description
`enrollment_status_id`	(required) The unique OCID associated with the enrollment status.
`update_enrollment_status_details`	(required) The request object for updating the enrollment status.
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`if_match`	(optional) For optimistic concurrency control. In the PUT or DELETE call for a resource, set the `if-match` parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

UPDATE_PROFILE Function

Updates the specified profile. Uses the profile's OCID to determine which profile to update.

Syntax

FUNCTION update_profile (
  profile_id varchar2,
  update_profile_details dbms_cloud_oci_optimizer_update_profile_details_t,
  if_match varchar2 DEFAULT NULL,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_update_profile_response_t;

Parameters

Parameter	Description
`profile_id`	(required) The unique OCID of the profile.
`update_profile_details`	(required) The profile information to use for the update.
`if_match`	(optional) For optimistic concurrency control. In the PUT or DELETE call for a resource, set the `if-match` parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value.
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

UPDATE_RECOMMENDATION Function

Updates the recommendation that corresponds to the specified OCID. Use this operation to implement the following actions: * Postpone recommendation * Dismiss recommendation * Reactivate recommendation

Syntax

FUNCTION update_recommendation (
  recommendation_id varchar2,
  update_recommendation_details dbms_cloud_oci_optimizer_update_recommendation_details_t,
  opc_request_id varchar2 DEFAULT NULL,
  if_match varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_update_recommendation_response_t;

Parameters

Parameter	Description
`recommendation_id`	(required) The unique OCID associated with the recommendation.
`update_recommendation_details`	(required) The request object for updating the recommendation details.
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`if_match`	(optional) For optimistic concurrency control. In the PUT or DELETE call for a resource, set the `if-match` parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

UPDATE_RESOURCE_ACTION Function

Updates the resource action that corresponds to the specified OCID. Use this operation to implement the following actions: * Postpone resource action * Ignore resource action * Reactivate resource action

Syntax

FUNCTION update_resource_action (
  resource_action_id varchar2,
  update_resource_action_details dbms_cloud_oci_optimizer_update_resource_action_details_t,
  opc_request_id varchar2 DEFAULT NULL,
  if_match varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_op_optimizer_update_resource_action_response_t;

Parameters

Parameter	Description
`resource_action_id`	(required) The unique OCID associated with the resource action.
`update_resource_action_details`	(required) The resource action information to be updated.
`opc_request_id`	(optional) Unique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
`if_match`	(optional) For optimistic concurrency control. In the PUT or DELETE call for a resource, set the `if-match` parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://optimizer.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

Oracle Cloud Infrastructure Documentation Try Free Tier

BULK_APPLY_RECOMMENDATIONS Function 🔗

CREATE_PROFILE Function 🔗

DELETE_PROFILE Function 🔗

FILTER_RESOURCE_ACTIONS Function 🔗

GET_CATEGORY Function 🔗

GET_ENROLLMENT_STATUS Function 🔗

GET_PROFILE Function 🔗

GET_RECOMMENDATION Function 🔗

GET_RESOURCE_ACTION Function 🔗

GET_WORK_REQUEST Function 🔗

LIST_CATEGORIES Function 🔗

LIST_ENROLLMENT_STATUSES Function 🔗

LIST_HISTORIES Function 🔗

LIST_PROFILE_LEVELS Function 🔗

LIST_PROFILES Function 🔗

LIST_RECOMMENDATION_STRATEGIES Function 🔗

LIST_RECOMMENDATIONS Function 🔗

LIST_RESOURCE_ACTION_QUERYABLE_FIELDS Function 🔗

LIST_RESOURCE_ACTIONS Function 🔗

LIST_WORK_REQUEST_ERRORS Function 🔗

LIST_WORK_REQUEST_LOGS Function 🔗

LIST_WORK_REQUESTS Function 🔗

UPDATE_ENROLLMENT_STATUS Function 🔗

UPDATE_PROFILE Function 🔗

UPDATE_RECOMMENDATION Function 🔗

UPDATE_RESOURCE_ACTION Function 🔗

Oracle Cloud Infrastructure Documentation
Try Free Tier

BULK_APPLY_RECOMMENDATIONS Function

CREATE_PROFILE Function

DELETE_PROFILE Function

FILTER_RESOURCE_ACTIONS Function

GET_CATEGORY Function

GET_ENROLLMENT_STATUS Function

GET_PROFILE Function

GET_RECOMMENDATION Function

GET_RESOURCE_ACTION Function

GET_WORK_REQUEST Function

LIST_CATEGORIES Function

LIST_ENROLLMENT_STATUSES Function

LIST_HISTORIES Function

LIST_PROFILE_LEVELS Function

LIST_PROFILES Function

LIST_RECOMMENDATION_STRATEGIES Function

LIST_RECOMMENDATIONS Function

LIST_RESOURCE_ACTION_QUERYABLE_FIELDS Function

LIST_RESOURCE_ACTIONS Function

LIST_WORK_REQUEST_ERRORS Function

LIST_WORK_REQUEST_LOGS Function

LIST_WORK_REQUESTS Function

UPDATE_ENROLLMENT_STATUS Function

UPDATE_PROFILE Function

UPDATE_RECOMMENDATION Function

UPDATE_RESOURCE_ACTION Function