Nested table type of varchar2(32767).

Syntax

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

Details about the recommended action.

Syntax

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

Fields

The resource action that a recommendation will be applied to.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_bulk_apply_resource_action_t FORCE AUTHID CURRENT_USER IS OBJECT (
  resource_action_id varchar2(32767),
  status varchar2(32767),
  time_status_end timestamp with time zone,
  parameters json_element_t,
  strategy_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_bulk_apply_resource_action_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_bulk_apply_resource_action_t (
    resource_action_id varchar2,
    status varchar2,
    time_status_end timestamp with time zone,
    parameters json_element_t,
    strategy_name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_optimizer_bulk_apply_resource_action_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_bulk_apply_resource_action_tbl FORCE IS TABLE OF (dbms_cloud_oci_optimizer_bulk_apply_resource_action_t) NOT PERSISTABLE;

Details about bulk recommendation actions.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_bulk_apply_recommendations_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  resource_action_ids dbms_cloud_oci_optimizer_varchar2_tbl,
  actions dbms_cloud_oci_optimizer_bulk_apply_resource_action_tbl,
  status varchar2(32767),
  time_status_end timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_bulk_apply_recommendations_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_bulk_apply_recommendations_details_t (
    resource_action_ids dbms_cloud_oci_optimizer_varchar2_tbl,
    actions dbms_cloud_oci_optimizer_bulk_apply_resource_action_tbl,
    status varchar2,
    time_status_end timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The count of recommendations in a category, grouped by importance.

Syntax

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

Fields

The count of resources in a category, grouped by status.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_optimizer_recommendation_count_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_recommendation_count_tbl FORCE IS TABLE OF (dbms_cloud_oci_optimizer_recommendation_count_t) NOT PERSISTABLE;

Nested table type of dbms_cloud_oci_optimizer_resource_count_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_resource_count_tbl FORCE IS TABLE OF (dbms_cloud_oci_optimizer_resource_count_t) NOT PERSISTABLE;

The metadata associated with the category.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_category_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  compartment_name varchar2(32767),
  name varchar2(32767),
  description varchar2(32767),
  recommendation_counts dbms_cloud_oci_optimizer_recommendation_count_tbl,
  resource_counts dbms_cloud_oci_optimizer_resource_count_tbl,
  lifecycle_state varchar2(32767),
  estimated_cost_saving number,
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  extended_metadata json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_category_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_category_t (
    id varchar2,
    compartment_id varchar2,
    compartment_name varchar2,
    name varchar2,
    description varchar2,
    recommendation_counts dbms_cloud_oci_optimizer_recommendation_count_tbl,
    resource_counts dbms_cloud_oci_optimizer_resource_count_tbl,
    lifecycle_state varchar2,
    estimated_cost_saving number,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    extended_metadata json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The metadata associated with the category summary.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_category_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  compartment_name varchar2(32767),
  name varchar2(32767),
  description varchar2(32767),
  recommendation_counts dbms_cloud_oci_optimizer_recommendation_count_tbl,
  resource_counts dbms_cloud_oci_optimizer_resource_count_tbl,
  lifecycle_state varchar2(32767),
  estimated_cost_saving number,
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  extended_metadata json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_category_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_category_summary_t (
    id varchar2,
    compartment_id varchar2,
    compartment_name varchar2,
    name varchar2,
    description varchar2,
    recommendation_counts dbms_cloud_oci_optimizer_recommendation_count_tbl,
    resource_counts dbms_cloud_oci_optimizer_resource_count_tbl,
    lifecycle_state varchar2,
    estimated_cost_saving number,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    extended_metadata json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_optimizer_category_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_category_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_optimizer_category_summary_t) NOT PERSISTABLE;

A list of categories that match filter criteria, if any. Results contain `CategorySummary` objects.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_category_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_optimizer_category_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_category_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_category_collection_t (
    items dbms_cloud_oci_optimizer_category_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details about the configuration level for the recommendation.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_optimizer_level_configuration_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_level_configuration_tbl FORCE IS TABLE OF (dbms_cloud_oci_optimizer_level_configuration_t) NOT PERSISTABLE;

A list of configuration levels for each recommendation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_levels_configuration_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_optimizer_level_configuration_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_levels_configuration_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_levels_configuration_t (
    items dbms_cloud_oci_optimizer_level_configuration_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Optional. The compartments specified in the profile override for a recommendation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_target_compartments_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_optimizer_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_target_compartments_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_target_compartments_t (
    items dbms_cloud_oci_optimizer_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A tag key definition used in the current profile override, including the tag namespace, tag key, tag value type, and tag values. Only defined tags are supported. For more information about tagging, see Tagging Overview

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_target_tag_t FORCE AUTHID CURRENT_USER IS OBJECT (
  tag_namespace_name varchar2(32767),
  tag_definition_name varchar2(32767),
  tag_value_type varchar2(32767),
  tag_values dbms_cloud_oci_optimizer_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_target_tag_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_target_tag_t (
    tag_namespace_name varchar2,
    tag_definition_name varchar2,
    tag_value_type varchar2,
    tag_values dbms_cloud_oci_optimizer_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_optimizer_target_tag_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_target_tag_tbl FORCE IS TABLE OF (dbms_cloud_oci_optimizer_target_tag_t) NOT PERSISTABLE;

Optional. The tags specified in the profile override for a recommendation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_target_tags_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_optimizer_target_tag_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_target_tags_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_target_tags_t (
    items dbms_cloud_oci_optimizer_target_tag_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details for creating a profile.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_create_profile_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  name varchar2(32767),
  description varchar2(32767),
  aggregation_interval_in_days number,
  defined_tags json_element_t,
  freeform_tags json_element_t,
  system_tags json_element_t,
  levels_configuration dbms_cloud_oci_optimizer_levels_configuration_t,
  target_compartments dbms_cloud_oci_optimizer_target_compartments_t,
  target_tags dbms_cloud_oci_optimizer_target_tags_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_create_profile_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_create_profile_details_t (
    compartment_id varchar2,
    name varchar2,
    description varchar2,
    aggregation_interval_in_days number,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    system_tags json_element_t,
    levels_configuration dbms_cloud_oci_optimizer_levels_configuration_t,
    target_compartments dbms_cloud_oci_optimizer_target_compartments_t,
    target_tags dbms_cloud_oci_optimizer_target_tags_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The metadata associated with the enrollment status.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_enrollment_status_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  lifecycle_state varchar2(32767),
  status varchar2(32767),
  status_reason varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_enrollment_status_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_enrollment_status_t (
    id varchar2,
    compartment_id varchar2,
    lifecycle_state varchar2,
    status varchar2,
    status_reason varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The metadata associated with the enrollment status summary.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_enrollment_status_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  lifecycle_state varchar2(32767),
  status varchar2(32767),
  status_reason varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_enrollment_status_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_enrollment_status_summary_t (
    id varchar2,
    compartment_id varchar2,
    lifecycle_state varchar2,
    status varchar2,
    status_reason varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_optimizer_enrollment_status_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_enrollment_status_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_optimizer_enrollment_status_summary_t) NOT PERSISTABLE;

A list of enrollment statuses that match filter criteria, if any. Results contain `EnrollmentStatusSummary` objects.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_enrollment_status_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_optimizer_enrollment_status_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_enrollment_status_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_enrollment_status_collection_t (
    items dbms_cloud_oci_optimizer_enrollment_status_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The representation of an error.

Syntax

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

Fields

One of the metrics that will be evaluated by profiles using this profile level.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_evaluated_metric_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  statistic varchar2(32767),
  threshold number,
  target number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_evaluated_metric_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_evaluated_metric_t (
    name varchar2,
    statistic varchar2,
    threshold number,
    target number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The metadata associated with the recommendation history and its related resources.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_history_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  name varchar2(32767),
  resource_type varchar2(32767),
  category_id varchar2(32767),
  recommendation_id varchar2(32767),
  recommendation_name varchar2(32767),
  resource_id varchar2(32767),
  resource_action_id varchar2(32767),
  action dbms_cloud_oci_optimizer_action_t,
  compartment_id varchar2(32767),
  compartment_name varchar2(32767),
  lifecycle_state varchar2(32767),
  estimated_cost_saving number,
  status varchar2(32767),
  metadata json_element_t,
  extended_metadata json_element_t,
  time_created timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_history_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_history_summary_t (
    id varchar2,
    name varchar2,
    resource_type varchar2,
    category_id varchar2,
    recommendation_id varchar2,
    recommendation_name varchar2,
    resource_id varchar2,
    resource_action_id varchar2,
    action dbms_cloud_oci_optimizer_action_t,
    compartment_id varchar2,
    compartment_name varchar2,
    lifecycle_state varchar2,
    estimated_cost_saving number,
    status varchar2,
    metadata json_element_t,
    extended_metadata json_element_t,
    time_created timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_optimizer_history_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_history_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_optimizer_history_summary_t) NOT PERSISTABLE;

A list containing the recommendation history items that match filter criteria, if any. Results contain `HistorySummary` objects.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_history_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_optimizer_history_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_history_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_history_collection_t (
    items dbms_cloud_oci_optimizer_history_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The metadata associated with the profile.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_profile_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  name varchar2(32767),
  description varchar2(32767),
  aggregation_interval_in_days number,
  defined_tags json_element_t,
  freeform_tags json_element_t,
  system_tags json_element_t,
  levels_configuration dbms_cloud_oci_optimizer_levels_configuration_t,
  target_compartments dbms_cloud_oci_optimizer_target_compartments_t,
  target_tags dbms_cloud_oci_optimizer_target_tags_t,
  lifecycle_state varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_profile_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_profile_t (
    id varchar2,
    compartment_id varchar2,
    name varchar2,
    description varchar2,
    aggregation_interval_in_days number,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    system_tags json_element_t,
    levels_configuration dbms_cloud_oci_optimizer_levels_configuration_t,
    target_compartments dbms_cloud_oci_optimizer_target_compartments_t,
    target_tags dbms_cloud_oci_optimizer_target_tags_t,
    lifecycle_state varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The metadata associated with the profile summary.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_profile_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  name varchar2(32767),
  description varchar2(32767),
  aggregation_interval_in_days number,
  defined_tags json_element_t,
  freeform_tags json_element_t,
  system_tags json_element_t,
  lifecycle_state varchar2(32767),
  levels_configuration dbms_cloud_oci_optimizer_levels_configuration_t,
  target_compartments dbms_cloud_oci_optimizer_target_compartments_t,
  target_tags dbms_cloud_oci_optimizer_target_tags_t,
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_profile_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_profile_summary_t (
    id varchar2,
    compartment_id varchar2,
    name varchar2,
    description varchar2,
    aggregation_interval_in_days number,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    system_tags json_element_t,
    lifecycle_state varchar2,
    levels_configuration dbms_cloud_oci_optimizer_levels_configuration_t,
    target_compartments dbms_cloud_oci_optimizer_target_compartments_t,
    target_tags dbms_cloud_oci_optimizer_target_tags_t,
    time_created timestamp with time zone,
    time_updated timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_optimizer_profile_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_profile_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_optimizer_profile_summary_t) NOT PERSISTABLE;

A list of profiles that match filter criteria, if any. Results contain `ProfileSummary` objects.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_profile_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_optimizer_profile_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_profile_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_profile_collection_t (
    items dbms_cloud_oci_optimizer_profile_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_optimizer_evaluated_metric_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_evaluated_metric_tbl FORCE IS TABLE OF (dbms_cloud_oci_optimizer_evaluated_metric_t) NOT PERSISTABLE;

Nested table type of number.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_number_tbl FORCE IS TABLE OF (number) NOT PERSISTABLE;

The metadata associated with the profile level summary.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_profile_level_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  recommendation_name varchar2(32767),
  metrics dbms_cloud_oci_optimizer_evaluated_metric_tbl,
  default_interval number,
  valid_intervals dbms_cloud_oci_optimizer_number_tbl,
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_profile_level_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_profile_level_summary_t (
    name varchar2,
    recommendation_name varchar2,
    metrics dbms_cloud_oci_optimizer_evaluated_metric_tbl,
    default_interval number,
    valid_intervals dbms_cloud_oci_optimizer_number_tbl,
    time_created timestamp with time zone,
    time_updated timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_optimizer_profile_level_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_profile_level_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_optimizer_profile_level_summary_t) NOT PERSISTABLE;

A list of profile levels that match the filter criteria, if any. The result contains `ProfileLevelSummary` objects.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_profile_level_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_optimizer_profile_level_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_profile_level_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_profile_level_collection_t (
    items dbms_cloud_oci_optimizer_profile_level_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The request object for querying the resource action details.

Syntax

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

Fields

An individual field that can be used as part of a query filter.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_optimizer_queryable_field_summary_abs_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_queryable_field_summary_abs_tbl FORCE IS TABLE OF (dbms_cloud_oci_optimizer_queryable_field_summary_abs_t) NOT PERSISTABLE;

An individual field that can be used as part of a query filter.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_queryable_field_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_optimizer_queryable_field_summary_abs_t (
  object_properties dbms_cloud_oci_optimizer_queryable_field_summary_abs_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_queryable_field_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_queryable_field_summary_t (
    field_type varchar2,
    field_name varchar2,
    object_properties dbms_cloud_oci_optimizer_queryable_field_summary_abs_tbl
  ) RETURN SELF AS RESULT
);

Fields

Nested table type of dbms_cloud_oci_optimizer_queryable_field_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_queryable_field_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_optimizer_queryable_field_summary_t) NOT PERSISTABLE;

List of the fields that are indexed for querying and their associated value types. Results contain `QueryableFieldSummary` objects.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_queryable_field_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_optimizer_queryable_field_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_queryable_field_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_queryable_field_collection_t (
    items dbms_cloud_oci_optimizer_queryable_field_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A system defined profile level supported by the recommendation.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_optimizer_supported_level_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_supported_level_tbl FORCE IS TABLE OF (dbms_cloud_oci_optimizer_supported_level_t) NOT PERSISTABLE;

Optional. The profile levels supported by a recommendation. For example, profile level values could be `Low`, `Medium`, and `High`. Not all recommendations support this field.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_supported_levels_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_optimizer_supported_level_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_supported_levels_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_supported_levels_t (
    items dbms_cloud_oci_optimizer_supported_level_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The metadata associated with the recommendation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_recommendation_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  category_id varchar2(32767),
  name varchar2(32767),
  description varchar2(32767),
  importance varchar2(32767),
  resource_counts dbms_cloud_oci_optimizer_resource_count_tbl,
  lifecycle_state varchar2(32767),
  estimated_cost_saving number,
  status varchar2(32767),
  time_status_begin timestamp with time zone,
  time_status_end timestamp with time zone,
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  supported_levels dbms_cloud_oci_optimizer_supported_levels_t,
  extended_metadata json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_recommendation_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_recommendation_t (
    id varchar2,
    compartment_id varchar2,
    category_id varchar2,
    name varchar2,
    description varchar2,
    importance varchar2,
    resource_counts dbms_cloud_oci_optimizer_resource_count_tbl,
    lifecycle_state varchar2,
    estimated_cost_saving number,
    status varchar2,
    time_status_begin timestamp with time zone,
    time_status_end timestamp with time zone,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    supported_levels dbms_cloud_oci_optimizer_supported_levels_t,
    extended_metadata json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The metadata associated with the recommendation summary.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_recommendation_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  category_id varchar2(32767),
  name varchar2(32767),
  description varchar2(32767),
  importance varchar2(32767),
  resource_counts dbms_cloud_oci_optimizer_resource_count_tbl,
  lifecycle_state varchar2(32767),
  estimated_cost_saving number,
  status varchar2(32767),
  time_status_begin timestamp with time zone,
  time_status_end timestamp with time zone,
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  supported_levels dbms_cloud_oci_optimizer_supported_levels_t,
  extended_metadata json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_recommendation_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_recommendation_summary_t (
    id varchar2,
    compartment_id varchar2,
    category_id varchar2,
    name varchar2,
    description varchar2,
    importance varchar2,
    resource_counts dbms_cloud_oci_optimizer_resource_count_tbl,
    lifecycle_state varchar2,
    estimated_cost_saving number,
    status varchar2,
    time_status_begin timestamp with time zone,
    time_status_end timestamp with time zone,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    supported_levels dbms_cloud_oci_optimizer_supported_levels_t,
    extended_metadata json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_optimizer_recommendation_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_recommendation_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_optimizer_recommendation_summary_t) NOT PERSISTABLE;

A list of recommendations that match filter criteria, if any. Results contain `RecommendationSummary` objects.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_recommendation_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_optimizer_recommendation_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_recommendation_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_recommendation_collection_t (
    items dbms_cloud_oci_optimizer_recommendation_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of json_element_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_json_element_t_tbl FORCE IS TABLE OF (json_element_t) NOT PERSISTABLE;

The metadata associated with the strategy parameter.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_strategy_parameter_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  l_type varchar2(32767),
  description varchar2(32767),
  is_required number,
  default_value json_element_t,
  possible_values dbms_cloud_oci_optimizer_json_element_t_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_strategy_parameter_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_strategy_parameter_t (
    name varchar2,
    l_type varchar2,
    description varchar2,
    is_required number,
    default_value json_element_t,
    possible_values dbms_cloud_oci_optimizer_json_element_t_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_optimizer_strategy_parameter_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_strategy_parameter_tbl FORCE IS TABLE OF (dbms_cloud_oci_optimizer_strategy_parameter_t) NOT PERSISTABLE;

The metadata associated with the strategy. The strategy is the method used to apply the recommendation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_strategy_t FORCE AUTHID CURRENT_USER IS OBJECT (
  strategy_name varchar2(32767),
  is_default number,
  parameters_definition dbms_cloud_oci_optimizer_strategy_parameter_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_strategy_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_strategy_t (
    strategy_name varchar2,
    is_default number,
    parameters_definition dbms_cloud_oci_optimizer_strategy_parameter_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_optimizer_strategy_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_strategy_tbl FORCE IS TABLE OF (dbms_cloud_oci_optimizer_strategy_t) NOT PERSISTABLE;

The metadata associated with the recommendation strategy.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_optimizer_recommendation_strategy_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_recommendation_strategy_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_optimizer_recommendation_strategy_summary_t) NOT PERSISTABLE;

A list of strategies that match filter criteria, if any. Results contain `RecommendationStrategySummary` objects.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_recommendation_strategy_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_optimizer_recommendation_strategy_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_recommendation_strategy_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_recommendation_strategy_collection_t (
    items dbms_cloud_oci_optimizer_recommendation_strategy_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The metadata associated with the resource action.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_resource_action_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  category_id varchar2(32767),
  recommendation_id varchar2(32767),
  resource_id varchar2(32767),
  name varchar2(32767),
  resource_type varchar2(32767),
  compartment_id varchar2(32767),
  compartment_name varchar2(32767),
  action dbms_cloud_oci_optimizer_action_t,
  lifecycle_state varchar2(32767),
  estimated_cost_saving number,
  status varchar2(32767),
  time_status_begin timestamp with time zone,
  time_status_end timestamp with time zone,
  metadata json_element_t,
  extended_metadata json_element_t,
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_resource_action_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_resource_action_t (
    id varchar2,
    category_id varchar2,
    recommendation_id varchar2,
    resource_id varchar2,
    name varchar2,
    resource_type varchar2,
    compartment_id varchar2,
    compartment_name varchar2,
    action dbms_cloud_oci_optimizer_action_t,
    lifecycle_state varchar2,
    estimated_cost_saving number,
    status varchar2,
    time_status_begin timestamp with time zone,
    time_status_end timestamp with time zone,
    metadata json_element_t,
    extended_metadata json_element_t,
    time_created timestamp with time zone,
    time_updated timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The metadata associated with the resource action summary.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_resource_action_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  category_id varchar2(32767),
  recommendation_id varchar2(32767),
  resource_id varchar2(32767),
  name varchar2(32767),
  resource_type varchar2(32767),
  compartment_id varchar2(32767),
  compartment_name varchar2(32767),
  action dbms_cloud_oci_optimizer_action_t,
  lifecycle_state varchar2(32767),
  estimated_cost_saving number,
  status varchar2(32767),
  time_status_begin timestamp with time zone,
  time_status_end timestamp with time zone,
  metadata json_element_t,
  extended_metadata json_element_t,
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_resource_action_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_resource_action_summary_t (
    id varchar2,
    category_id varchar2,
    recommendation_id varchar2,
    resource_id varchar2,
    name varchar2,
    resource_type varchar2,
    compartment_id varchar2,
    compartment_name varchar2,
    action dbms_cloud_oci_optimizer_action_t,
    lifecycle_state varchar2,
    estimated_cost_saving number,
    status varchar2,
    time_status_begin timestamp with time zone,
    time_status_end timestamp with time zone,
    metadata json_element_t,
    extended_metadata json_element_t,
    time_created timestamp with time zone,
    time_updated timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_optimizer_resource_action_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_resource_action_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_optimizer_resource_action_summary_t) NOT PERSISTABLE;

A list of resource actions that match filter criteria, if any. Results contain `ResourceActionSummary` objects.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_resource_action_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_optimizer_resource_action_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_resource_action_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_resource_action_collection_t (
    items dbms_cloud_oci_optimizer_resource_action_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The request object for updating the enrollment status details.

Syntax

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

Fields

Details for updating a profile.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_update_profile_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  description varchar2(32767),
  aggregation_interval_in_days number,
  defined_tags json_element_t,
  freeform_tags json_element_t,
  system_tags json_element_t,
  levels_configuration dbms_cloud_oci_optimizer_levels_configuration_t,
  target_compartments dbms_cloud_oci_optimizer_target_compartments_t,
  target_tags dbms_cloud_oci_optimizer_target_tags_t,
  name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_update_profile_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_update_profile_details_t (
    description varchar2,
    aggregation_interval_in_days number,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    system_tags json_element_t,
    levels_configuration dbms_cloud_oci_optimizer_levels_configuration_t,
    target_compartments dbms_cloud_oci_optimizer_target_compartments_t,
    target_tags dbms_cloud_oci_optimizer_target_tags_t,
    name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The request object for updating the recommendation details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_update_recommendation_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  status varchar2(32767),
  time_status_end timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_update_recommendation_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_update_recommendation_details_t (
    status varchar2,
    time_status_end timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The request object for updating the resource action details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_update_resource_action_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  status varchar2(32767),
  time_status_end timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_update_resource_action_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_update_resource_action_details_t (
    status varchar2,
    time_status_end timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details about the resource entity.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_work_request_resource_t FORCE AUTHID CURRENT_USER IS OBJECT (
  entity_type varchar2(32767),
  action_type varchar2(32767),
  identifier varchar2(32767),
  entity_uri varchar2(32767),
  metadata json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_work_request_resource_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_work_request_resource_t (
    entity_type varchar2,
    action_type varchar2,
    identifier varchar2,
    entity_uri varchar2,
    metadata json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_optimizer_work_request_resource_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_work_request_resource_tbl FORCE IS TABLE OF (dbms_cloud_oci_optimizer_work_request_resource_t) NOT PERSISTABLE;

The asynchronous API request does not take effect immediately. This request spawns an asynchronous workflow to fulfill the request. WorkRequest objects provide visibility for in-progress workflows.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_work_request_t FORCE AUTHID CURRENT_USER IS OBJECT (
  operation_type varchar2(32767),
  status varchar2(32767),
  id varchar2(32767),
  compartment_id varchar2(32767),
  resources dbms_cloud_oci_optimizer_work_request_resource_tbl,
  percent_complete number,
  time_accepted timestamp with time zone,
  time_started timestamp with time zone,
  time_finished timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_work_request_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_work_request_t (
    operation_type varchar2,
    status varchar2,
    id varchar2,
    compartment_id varchar2,
    resources dbms_cloud_oci_optimizer_work_request_resource_tbl,
    percent_complete number,
    time_accepted timestamp with time zone,
    time_started timestamp with time zone,
    time_finished timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_optimizer_work_request_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_work_request_tbl FORCE IS TABLE OF (dbms_cloud_oci_optimizer_work_request_t) NOT PERSISTABLE;

A list of work requests that match filter criteria, if any. Results contain `WorkRequest` objects.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_work_request_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_optimizer_work_request_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_work_request_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_work_request_collection_t (
    items dbms_cloud_oci_optimizer_work_request_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details about errors encountered while executing a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_work_request_error_t FORCE AUTHID CURRENT_USER IS OBJECT (
  code varchar2(32767),
  message varchar2(32767),
  l_timestamp timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_work_request_error_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_work_request_error_t (
    code varchar2,
    message varchar2,
    l_timestamp timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_optimizer_work_request_error_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_work_request_error_tbl FORCE IS TABLE OF (dbms_cloud_oci_optimizer_work_request_error_t) NOT PERSISTABLE;

A list of work request errors that match filter criteria, if any. Results contain `WorkRequestError` objects.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_work_request_error_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_optimizer_work_request_error_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_work_request_error_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_work_request_error_collection_t (
    items dbms_cloud_oci_optimizer_work_request_error_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details about the log entity.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_work_request_log_entry_t FORCE AUTHID CURRENT_USER IS OBJECT (
  message varchar2(32767),
  l_timestamp timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_work_request_log_entry_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_work_request_log_entry_t (
    message varchar2,
    l_timestamp timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_optimizer_work_request_log_entry_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_work_request_log_entry_tbl FORCE IS TABLE OF (dbms_cloud_oci_optimizer_work_request_log_entry_t) NOT PERSISTABLE;

A list of work request logs that match filter criteria, if any. Results contain `WorkRequestLogEntry` objects.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_optimizer_work_request_log_entry_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_optimizer_work_request_log_entry_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_work_request_log_entry_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_optimizer_work_request_log_entry_collection_t (
    items dbms_cloud_oci_optimizer_work_request_log_entry_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields