Nested table type of varchar2(32767).

Syntax

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

The metric dimension details.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_database_management_metric_dimension_definition_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_metric_dimension_definition_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_metric_dimension_definition_t) NOT PERSISTABLE;

The metric values with dimension details.

Syntax

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

Fields

The response object representing activityMetric details for a specific Managed Database at a particular time.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_activity_time_series_metrics_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_timestamp timestamp with time zone,
  cpu_time dbms_cloud_oci_database_management_metric_data_point_t,
  wait_time dbms_cloud_oci_database_management_metric_data_point_t,
  user_io_time dbms_cloud_oci_database_management_metric_data_point_t,
  cpu_count dbms_cloud_oci_database_management_metric_data_point_t,
  l_cluster dbms_cloud_oci_database_management_metric_data_point_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_activity_time_series_metrics_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_activity_time_series_metrics_t (
    l_timestamp timestamp with time zone,
    cpu_time dbms_cloud_oci_database_management_metric_data_point_t,
    wait_time dbms_cloud_oci_database_management_metric_data_point_t,
    user_io_time dbms_cloud_oci_database_management_metric_data_point_t,
    cpu_count dbms_cloud_oci_database_management_metric_data_point_t,
    l_cluster dbms_cloud_oci_database_management_metric_data_point_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The credential to connect to the database to perform tablespace administration tasks.

Syntax

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

Fields

Storage size.

Syntax

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

Fields

The details required to add data files or temp files to the tablespace.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_add_data_files_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  credential_details dbms_cloud_oci_database_management_tablespace_admin_credential_details_t,
  file_type varchar2(32767),
  data_files dbms_cloud_oci_database_management_varchar2_tbl,
  file_count number,
  file_size dbms_cloud_oci_database_management_tablespace_storage_size_t,
  is_reusable number,
  is_auto_extensible number,
  auto_extend_next_size dbms_cloud_oci_database_management_tablespace_storage_size_t,
  auto_extend_max_size dbms_cloud_oci_database_management_tablespace_storage_size_t,
  is_max_size_unlimited number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_add_data_files_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_add_data_files_details_t (
    credential_details dbms_cloud_oci_database_management_tablespace_admin_credential_details_t,
    file_type varchar2,
    data_files dbms_cloud_oci_database_management_varchar2_tbl,
    file_count number,
    file_size dbms_cloud_oci_database_management_tablespace_storage_size_t,
    is_reusable number,
    is_auto_extensible number,
    auto_extend_next_size dbms_cloud_oci_database_management_tablespace_storage_size_t,
    auto_extend_max_size dbms_cloud_oci_database_management_tablespace_storage_size_t,
    is_max_size_unlimited number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The Managed Database details required to add it to a Managed Database Group.

Syntax

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

Fields

The object containing the ADDM task metadata.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_addm_task_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  task_name varchar2(32767),
  task_id number,
  description varchar2(32767),
  db_user varchar2(32767),
  status varchar2(32767),
  time_created timestamp with time zone,
  how_created varchar2(32767),
  start_snapshot_time timestamp with time zone,
  end_snapshot_time timestamp with time zone,
  begin_snapshot_id number,
  end_snapshot_id number,
  findings number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_addm_task_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_addm_task_summary_t (
    task_name varchar2,
    task_id number,
    description varchar2,
    db_user varchar2,
    status varchar2,
    time_created timestamp with time zone,
    how_created varchar2,
    start_snapshot_time timestamp with time zone,
    end_snapshot_time timestamp with time zone,
    begin_snapshot_id number,
    end_snapshot_id number,
    findings number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_addm_task_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_addm_task_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_addm_task_summary_t) NOT PERSISTABLE;

The list of ADDM task metadata.

Syntax

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

Fields

The schema object details.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_database_management_schema_definition_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_schema_definition_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_schema_definition_t) NOT PERSISTABLE;

The findings of the Optimizer Statistics Advisor.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_finding_schema_or_operation_t FORCE AUTHID CURRENT_USER IS OBJECT (
  operations dbms_cloud_oci_database_management_varchar2_tbl,
  schemas dbms_cloud_oci_database_management_schema_definition_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_finding_schema_or_operation_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_finding_schema_or_operation_t (
    operations dbms_cloud_oci_database_management_varchar2_tbl,
    schemas dbms_cloud_oci_database_management_schema_definition_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

An example line of the recommendation

Syntax

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

Fields

Nested table type of dbms_cloud_oci_database_management_recommendation_example_line_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_recommendation_example_line_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_recommendation_example_line_t) NOT PERSISTABLE;

An example of the recommendation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_recommendation_example_t FORCE AUTHID CURRENT_USER IS OBJECT (
  lines dbms_cloud_oci_database_management_recommendation_example_line_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_recommendation_example_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_recommendation_example_t (
    lines dbms_cloud_oci_database_management_recommendation_example_line_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details of the rationale for the recommendation.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_database_management_recommendation_rationale_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_recommendation_rationale_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_recommendation_rationale_t) NOT PERSISTABLE;

The details of the Optimizer Statistics Advisor findings and recommendations.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_recommendation_t FORCE AUTHID CURRENT_USER IS OBJECT (
  message varchar2(32767),
  example dbms_cloud_oci_database_management_recommendation_example_t,
  rationales dbms_cloud_oci_database_management_recommendation_rationale_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_recommendation_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_recommendation_t (
    message varchar2,
    example dbms_cloud_oci_database_management_recommendation_example_t,
    rationales dbms_cloud_oci_database_management_recommendation_rationale_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_finding_schema_or_operation_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_finding_schema_or_operation_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_finding_schema_or_operation_t) NOT PERSISTABLE;

Nested table type of dbms_cloud_oci_database_management_recommendation_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_recommendation_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_recommendation_t) NOT PERSISTABLE;

The summary of the Optimizer Statistics Advisor findings and recommendations.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_rule_finding_t FORCE AUTHID CURRENT_USER IS OBJECT (
  message varchar2(32767),
  details dbms_cloud_oci_database_management_finding_schema_or_operation_tbl,
  recommendations dbms_cloud_oci_database_management_recommendation_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_rule_finding_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_rule_finding_t (
    message varchar2,
    details dbms_cloud_oci_database_management_finding_schema_or_operation_tbl,
    recommendations dbms_cloud_oci_database_management_recommendation_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_rule_finding_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_rule_finding_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_rule_finding_t) NOT PERSISTABLE;

The details of the Optimizer Statistics Advisor rule.

Syntax

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

Fields

The detail for one alert log entry.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_alert_log_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  message_level varchar2(32767),
  message_type varchar2(32767),
  message_content varchar2(32767),
  l_timestamp timestamp with time zone,
  supplemental_detail varchar2(32767),
  file_location varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_alert_log_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_alert_log_summary_t (
    message_level varchar2,
    message_type varchar2,
    message_content varchar2,
    l_timestamp timestamp with time zone,
    supplemental_detail varchar2,
    file_location varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_alert_log_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_alert_log_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_alert_log_summary_t) NOT PERSISTABLE;

The list of alert logs.

Syntax

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

Fields

The details for one alert log count entry.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_database_management_alert_log_count_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_alert_log_count_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_alert_log_count_summary_t) NOT PERSISTABLE;

The collection of the counts of different level or type of alert logs.

Syntax

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

Fields

A valid value for a database parameter.

Syntax

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

Fields

The credentials used to connect to the ASM instance. Currently only the `DETAILS` type is supported for creating MACS connector credentials.

Syntax

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

Fields

The existing named credential used to connect to the ASM instance.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_asm_connection_credentails_by_name_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_management_asm_connection_credentials_t (
  l_credential_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_asm_connection_credentails_by_name_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_asm_connection_credentails_by_name_t (
    credential_type varchar2,
    l_credential_name varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_management_asm_connection_credentails_by_name_t is a subtype of the dbms_cloud_oci_database_management_asm_connection_credentials_t type.

Fields

The credentials used to connect to the ASM instance.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_asm_connection_credentials_by_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_management_asm_connection_credentials_t (
  l_credential_name varchar2(32767),
  user_name varchar2(32767),
  password_secret_id varchar2(32767),
  role varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_asm_connection_credentials_by_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_asm_connection_credentials_by_details_t (
    credential_type varchar2,
    l_credential_name varchar2,
    user_name varchar2,
    password_secret_id varchar2,
    role varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_management_asm_connection_credentials_by_details_t is a subtype of the dbms_cloud_oci_database_management_asm_connection_credentials_t type.

Fields

The ASM instance connection string.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_asm_connection_string_t FORCE AUTHID CURRENT_USER IS OBJECT (
  hosts dbms_cloud_oci_database_management_varchar2_tbl,
  port number,
  service varchar2(32767),
  protocol varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_asm_connection_string_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_asm_connection_string_t (
    hosts dbms_cloud_oci_database_management_varchar2_tbl,
    port number,
    service varchar2,
    protocol varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details of ASM properties.

Syntax

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

Fields

The summary of ASM properties.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_database_management_asm_property_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_asm_property_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_asm_property_summary_t) NOT PERSISTABLE;

A collection of ASM properties for a specific Managed Database.

Syntax

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

Fields

The details of the associated component.

Syntax

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

Fields

The summary of a database currently using a Database Management private endpoint.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_associated_database_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  name varchar2(32767),
  compartment_id varchar2(32767),
  time_registered timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_associated_database_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_associated_database_summary_t (
    id varchar2,
    name varchar2,
    compartment_id varchar2,
    time_registered timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_associated_database_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_associated_database_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_associated_database_summary_t) NOT PERSISTABLE;

A collection of databases using a Database Management private endpoint.

Syntax

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

Fields

The details of the associated service that will be enabled or disabled for an external DB System.

Syntax

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

Fields

The details for one attention log entry.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_attention_log_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  message_urgency varchar2(32767),
  message_type varchar2(32767),
  message_content varchar2(32767),
  l_timestamp timestamp with time zone,
  scope varchar2(32767),
  target_user varchar2(32767),
  cause varchar2(32767),
  action varchar2(32767),
  supplemental_detail varchar2(32767),
  file_location varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_attention_log_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_attention_log_summary_t (
    message_urgency varchar2,
    message_type varchar2,
    message_content varchar2,
    l_timestamp timestamp with time zone,
    scope varchar2,
    target_user varchar2,
    cause varchar2,
    action varchar2,
    supplemental_detail varchar2,
    file_location varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_attention_log_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_attention_log_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_attention_log_summary_t) NOT PERSISTABLE;

The list of attention logs.

Syntax

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

Fields

The details for one attention log count entry.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_database_management_attention_log_count_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_attention_log_count_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_attention_log_count_summary_t) NOT PERSISTABLE;

The collection of the counts of different urgency or type of attention logs.

Syntax

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

Fields

An automatic capture filter that enables you to capture only those SQL statements that you want, and exclude noncritical statements.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_automatic_capture_filter_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  values_to_include dbms_cloud_oci_database_management_varchar2_tbl,
  values_to_exclude dbms_cloud_oci_database_management_varchar2_tbl,
  time_last_modified timestamp with time zone,
  modified_by varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_automatic_capture_filter_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_automatic_capture_filter_t (
    name varchar2,
    values_to_include dbms_cloud_oci_database_management_varchar2_tbl,
    values_to_exclude dbms_cloud_oci_database_management_varchar2_tbl,
    time_last_modified timestamp with time zone,
    modified_by varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details of a capture filter used to include or exclude SQL statements in the initial automatic plan capture.

Syntax

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

Fields

Nested table type of number.

Syntax

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

The AWR summary for a database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  awr_db_id varchar2(32767),
  db_name varchar2(32767),
  instance_list dbms_cloud_oci_database_management_number_tbl,
  time_db_startup timestamp with time zone,
  time_first_snapshot_begin timestamp with time zone,
  time_latest_snapshot_end timestamp with time zone,
  first_snapshot_id number,
  latest_snapshot_id number,
  snapshot_count number,
  snapshot_interval_in_min number,
  container_id number,
  db_version varchar2(32767),
  snapshot_timezone varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_summary_t (
    awr_db_id varchar2,
    db_name varchar2,
    instance_list dbms_cloud_oci_database_management_number_tbl,
    time_db_startup timestamp with time zone,
    time_first_snapshot_begin timestamp with time zone,
    time_latest_snapshot_end timestamp with time zone,
    first_snapshot_id number,
    latest_snapshot_id number,
    snapshot_count number,
    snapshot_interval_in_min number,
    container_id number,
    db_version varchar2,
    snapshot_timezone varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The AWR query result.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_query_result_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  version varchar2(32767),
  query_key varchar2(32767),
  db_query_time_in_secs number,
  awr_result_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_query_result_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_query_result_t (
    name varchar2,
    version varchar2,
    query_key varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Nested table type of dbms_cloud_oci_database_management_awr_db_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_awr_db_summary_t) NOT PERSISTABLE;

The result of AWR query.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_collection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_management_awr_query_result_t (
  items dbms_cloud_oci_database_management_awr_db_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_collection_t (
    name varchar2,
    version varchar2,
    query_key varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2,
    items dbms_cloud_oci_database_management_awr_db_summary_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_management_awr_db_collection_t is a subtype of the dbms_cloud_oci_database_management_awr_query_result_t type.

Fields

A summary of the AWR CPU resource limits and metrics.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_cpu_usage_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_timestamp timestamp with time zone,
  avg_value number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_cpu_usage_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_cpu_usage_summary_t (
    l_timestamp timestamp with time zone,
    avg_value number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_awr_db_cpu_usage_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_cpu_usage_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_awr_db_cpu_usage_summary_t) NOT PERSISTABLE;

The AWR CPU usage data.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_cpu_usage_collection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_management_awr_query_result_t (
  num_cpu_cores number,
  cpu_count number,
  num_cpus number,
  items dbms_cloud_oci_database_management_awr_db_cpu_usage_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_cpu_usage_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_cpu_usage_collection_t (
    name varchar2,
    version varchar2,
    query_key varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2,
    num_cpu_cores number,
    cpu_count number,
    num_cpus number,
    items dbms_cloud_oci_database_management_awr_db_cpu_usage_summary_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_management_awr_db_cpu_usage_collection_t is a subtype of the dbms_cloud_oci_database_management_awr_query_result_t type.

Fields

The summary of the AWR metric data for a particular metric at a specific time.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_metric_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  l_timestamp timestamp with time zone,
  avg_value number,
  min_value number,
  max_value number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_metric_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_metric_summary_t (
    name varchar2,
    l_timestamp timestamp with time zone,
    avg_value number,
    min_value number,
    max_value number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_awr_db_metric_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_metric_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_awr_db_metric_summary_t) NOT PERSISTABLE;

The AWR metrics time series summary data.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_metric_collection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_management_awr_query_result_t (
  items dbms_cloud_oci_database_management_awr_db_metric_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_metric_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_metric_collection_t (
    name varchar2,
    version varchar2,
    query_key varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2,
    items dbms_cloud_oci_database_management_awr_db_metric_summary_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_management_awr_db_metric_collection_t is a subtype of the dbms_cloud_oci_database_management_awr_query_result_t type.

Fields

A summary of the changes made to a single AWR database parameter.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_parameter_change_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  time_begin timestamp with time zone,
  time_end timestamp with time zone,
  instance_number number,
  previous_value varchar2(32767),
  value varchar2(32767),
  snapshot_id number,
  value_modified varchar2(32767),
  is_default number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_parameter_change_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_parameter_change_summary_t (
    time_begin timestamp with time zone,
    time_end timestamp with time zone,
    instance_number number,
    previous_value varchar2,
    value varchar2,
    snapshot_id number,
    value_modified varchar2,
    is_default number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_awr_db_parameter_change_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_parameter_change_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_awr_db_parameter_change_summary_t) NOT PERSISTABLE;

The AWR database parameter change history.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_parameter_change_collection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_management_awr_query_result_t (
  items dbms_cloud_oci_database_management_awr_db_parameter_change_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_parameter_change_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_parameter_change_collection_t (
    name varchar2,
    version varchar2,
    query_key varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2,
    items dbms_cloud_oci_database_management_awr_db_parameter_change_summary_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_management_awr_db_parameter_change_collection_t is a subtype of the dbms_cloud_oci_database_management_awr_query_result_t type.

Fields

The summary of the AWR change history data for a single database parameter.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_parameter_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  instance_number number,
  begin_value varchar2(32767),
  end_value varchar2(32767),
  is_changed number,
  value_modified varchar2(32767),
  is_default number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_parameter_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_parameter_summary_t (
    name varchar2,
    instance_number number,
    begin_value varchar2,
    end_value varchar2,
    is_changed number,
    value_modified varchar2,
    is_default number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_awr_db_parameter_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_parameter_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_awr_db_parameter_summary_t) NOT PERSISTABLE;

The AWR database parameter data.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_parameter_collection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_management_awr_query_result_t (
  items dbms_cloud_oci_database_management_awr_db_parameter_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_parameter_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_parameter_collection_t (
    name varchar2,
    version varchar2,
    query_key varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2,
    items dbms_cloud_oci_database_management_awr_db_parameter_summary_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_management_awr_db_parameter_collection_t is a subtype of the dbms_cloud_oci_database_management_awr_query_result_t type.

Fields

The result of the AWR report.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_report_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_management_awr_query_result_t (
  content varchar2(32767),
  format varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_report_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_report_t (
    name varchar2,
    version varchar2,
    query_key varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2,
    content varchar2,
    format varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_management_awr_db_report_t is a subtype of the dbms_cloud_oci_database_management_awr_query_result_t type.

Fields

The AWR snapshot summary of one snapshot.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_snapshot_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  awr_db_id varchar2(32767),
  instance_number number,
  time_db_startup timestamp with time zone,
  time_begin timestamp with time zone,
  time_end timestamp with time zone,
  snapshot_id number,
  error_count number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_snapshot_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_snapshot_summary_t (
    awr_db_id varchar2,
    instance_number number,
    time_db_startup timestamp with time zone,
    time_begin timestamp with time zone,
    time_end timestamp with time zone,
    snapshot_id number,
    error_count number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_awr_db_snapshot_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_snapshot_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_awr_db_snapshot_summary_t) NOT PERSISTABLE;

The list of AWR snapshots for one database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_snapshot_collection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_management_awr_query_result_t (
  items dbms_cloud_oci_database_management_awr_db_snapshot_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_snapshot_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_snapshot_collection_t (
    name varchar2,
    version varchar2,
    query_key varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2,
    items dbms_cloud_oci_database_management_awr_db_snapshot_summary_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_management_awr_db_snapshot_collection_t is a subtype of the dbms_cloud_oci_database_management_awr_query_result_t type.

Fields

The summary data for a range of AWR snapshots.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_snapshot_range_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  awr_db_id varchar2(32767),
  db_name varchar2(32767),
  instance_list dbms_cloud_oci_database_management_number_tbl,
  time_db_startup timestamp with time zone,
  time_first_snapshot_begin timestamp with time zone,
  time_latest_snapshot_end timestamp with time zone,
  first_snapshot_id number,
  latest_snapshot_id number,
  snapshot_count number,
  snapshot_interval_in_min number,
  container_id number,
  db_version varchar2(32767),
  snapshot_timezone varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_snapshot_range_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_snapshot_range_summary_t (
    awr_db_id varchar2,
    db_name varchar2,
    instance_list dbms_cloud_oci_database_management_number_tbl,
    time_db_startup timestamp with time zone,
    time_first_snapshot_begin timestamp with time zone,
    time_latest_snapshot_end timestamp with time zone,
    first_snapshot_id number,
    latest_snapshot_id number,
    snapshot_count number,
    snapshot_interval_in_min number,
    container_id number,
    db_version varchar2,
    snapshot_timezone varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_awr_db_snapshot_range_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_snapshot_range_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_awr_db_snapshot_range_summary_t) NOT PERSISTABLE;

The AWR snapshot range list.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_snapshot_range_collection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_management_awr_query_result_t (
  items dbms_cloud_oci_database_management_awr_db_snapshot_range_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_snapshot_range_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_snapshot_range_collection_t (
    name varchar2,
    version varchar2,
    query_key varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2,
    items dbms_cloud_oci_database_management_awr_db_snapshot_range_summary_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_management_awr_db_snapshot_range_collection_t is a subtype of the dbms_cloud_oci_database_management_awr_query_result_t type.

Fields

The result of the AWR SQL report.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_sql_report_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_management_awr_query_result_t (
  content varchar2(32767),
  format varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_sql_report_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_sql_report_t (
    name varchar2,
    version varchar2,
    query_key varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2,
    content varchar2,
    format varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_management_awr_db_sql_report_t is a subtype of the dbms_cloud_oci_database_management_awr_query_result_t type.

Fields

The summary of the AWR SYSSTAT data.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_sysstat_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  category varchar2(32767),
  time_begin timestamp with time zone,
  time_end timestamp with time zone,
  avg_value number,
  current_value number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_sysstat_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_sysstat_summary_t (
    name varchar2,
    category varchar2,
    time_begin timestamp with time zone,
    time_end timestamp with time zone,
    avg_value number,
    current_value number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_awr_db_sysstat_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_sysstat_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_awr_db_sysstat_summary_t) NOT PERSISTABLE;

The AWR SYSSTAT time series summary data.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_sysstat_collection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_management_awr_query_result_t (
  items dbms_cloud_oci_database_management_awr_db_sysstat_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_sysstat_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_sysstat_collection_t (
    name varchar2,
    version varchar2,
    query_key varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2,
    items dbms_cloud_oci_database_management_awr_db_sysstat_summary_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_management_awr_db_sysstat_collection_t is a subtype of the dbms_cloud_oci_database_management_awr_query_result_t type.

Fields

A summary of the AWR top wait event data for one event.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_database_management_awr_db_top_wait_event_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_top_wait_event_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_awr_db_top_wait_event_summary_t) NOT PERSISTABLE;

The AWR top wait event data.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_top_wait_event_collection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_management_awr_query_result_t (
  items dbms_cloud_oci_database_management_awr_db_top_wait_event_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_top_wait_event_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_top_wait_event_collection_t (
    name varchar2,
    version varchar2,
    query_key varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2,
    items dbms_cloud_oci_database_management_awr_db_top_wait_event_summary_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_management_awr_db_top_wait_event_collection_t is a subtype of the dbms_cloud_oci_database_management_awr_query_result_t type.

Fields

A summary of the AWR wait event bucket and waits percentage.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_database_management_awr_db_wait_event_bucket_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_wait_event_bucket_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_awr_db_wait_event_bucket_summary_t) NOT PERSISTABLE;

The percentage distribution of waits in the AWR wait event buckets.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_wait_event_bucket_collection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_management_awr_query_result_t (
  total_waits number,
  items dbms_cloud_oci_database_management_awr_db_wait_event_bucket_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_wait_event_bucket_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_wait_event_bucket_collection_t (
    name varchar2,
    version varchar2,
    query_key varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2,
    total_waits number,
    items dbms_cloud_oci_database_management_awr_db_wait_event_bucket_summary_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_management_awr_db_wait_event_bucket_collection_t is a subtype of the dbms_cloud_oci_database_management_awr_query_result_t type.

Fields

The summary of the AWR wait event time series data for one event.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_wait_event_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  time_begin timestamp with time zone,
  time_end timestamp with time zone,
  waits_per_sec number,
  avg_wait_time_per_sec number,
  avg_wait_time_per_wait number,
  snapshot_id number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_wait_event_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_wait_event_summary_t (
    name varchar2,
    time_begin timestamp with time zone,
    time_end timestamp with time zone,
    waits_per_sec number,
    avg_wait_time_per_sec number,
    avg_wait_time_per_wait number,
    snapshot_id number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_awr_db_wait_event_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_wait_event_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_awr_db_wait_event_summary_t) NOT PERSISTABLE;

The AWR wait event data.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_awr_db_wait_event_collection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_management_awr_query_result_t (
  items dbms_cloud_oci_database_management_awr_db_wait_event_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_wait_event_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_awr_db_wait_event_collection_t (
    name varchar2,
    version varchar2,
    query_key varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2,
    items dbms_cloud_oci_database_management_awr_db_wait_event_summary_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_management_awr_db_wait_event_collection_t is a subtype of the dbms_cloud_oci_database_management_awr_query_result_t type.

Fields

The details of the preferred credential.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_preferred_credential_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_type varchar2(32767),
  l_credential_name varchar2(32767),
  status varchar2(32767),
  is_accessible number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_preferred_credential_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_preferred_credential_t (
    l_type varchar2,
    l_credential_name varchar2,
    status varchar2,
    is_accessible number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

The details of the 'BASIC' preferred credential.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_basic_preferred_credential_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_management_preferred_credential_t (
  user_name varchar2(32767),
  role varchar2(32767),
  password_secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_basic_preferred_credential_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_basic_preferred_credential_t (
    l_type varchar2,
    l_credential_name varchar2,
    status varchar2,
    is_accessible number,
    user_name varchar2,
    role varchar2,
    password_secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_management_basic_preferred_credential_t is a subtype of the dbms_cloud_oci_database_management_preferred_credential_t type.

Fields

The value of a database parameter to change.

Syntax

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

Fields

The database credentials used to perform management activity.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_database_credentials_t FORCE AUTHID CURRENT_USER IS OBJECT (
  user_name varchar2(32767),
  password varchar2(32767),
  secret_id varchar2(32767),
  role varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_credentials_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_credentials_t (
    user_name varchar2,
    password varchar2,
    secret_id varchar2,
    role varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_change_database_parameter_details_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_change_database_parameter_details_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_change_database_parameter_details_t) NOT PERSISTABLE;

The details required to change database parameter values.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_change_database_parameters_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  credentials dbms_cloud_oci_database_management_database_credentials_t,
  scope varchar2(32767),
  parameters dbms_cloud_oci_database_management_change_database_parameter_details_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_change_database_parameters_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_change_database_parameters_details_t (
    credentials dbms_cloud_oci_database_management_database_credentials_t,
    scope varchar2,
    parameters dbms_cloud_oci_database_management_change_database_parameter_details_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details used to move the Database Management private endpoint to another compartment.

Syntax

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

Fields

The details required to change the compartment of an external DB system.

Syntax

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

Fields

The details required to change the compartment of the Exadata infrastructure.

Syntax

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

Fields

The details required to change the compartment of a job.

Syntax

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

Fields

The details required to change the compartment of a Managed Database Group.

Syntax

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

Fields

The credential used to connect to the Managed Database and obtain the details of the optimizer statistics tasks.

Syntax

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

Fields

The details required to change the plan retention period.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_change_plan_retention_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  retention_weeks number,
  credentials dbms_cloud_oci_database_management_managed_database_credential_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_change_plan_retention_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_change_plan_retention_details_t (
    retention_weeks number,
    credentials dbms_cloud_oci_database_management_managed_database_credential_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details required to change the disk space limit for the SQL Management Base.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_change_space_budget_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  space_budget_percent number,
  credentials dbms_cloud_oci_database_management_managed_database_credential_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_change_space_budget_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_change_space_budget_details_t (
    space_budget_percent number,
    credentials dbms_cloud_oci_database_management_managed_database_credential_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details required to change SQL plan baseline attributes.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_change_sql_plan_baselines_attributes_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  sql_handle varchar2(32767),
  plan_name varchar2(32767),
  is_enabled number,
  is_fixed number,
  is_auto_purged number,
  credentials dbms_cloud_oci_database_management_managed_database_credential_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_change_sql_plan_baselines_attributes_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_change_sql_plan_baselines_attributes_details_t (
    sql_handle varchar2,
    plan_name varchar2,
    is_enabled number,
    is_fixed number,
    is_auto_purged number,
    credentials dbms_cloud_oci_database_management_managed_database_credential_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The child Managed Database of a Managed Database Group.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_child_database_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  name varchar2(32767),
  compartment_id varchar2(32767),
  deployment_type varchar2(32767),
  workload_type varchar2(32767),
  database_type varchar2(32767),
  database_sub_type varchar2(32767),
  time_added timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_child_database_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_child_database_t (
    id varchar2,
    name varchar2,
    compartment_id varchar2,
    deployment_type varchar2,
    workload_type varchar2,
    database_type varchar2,
    database_sub_type varchar2,
    time_added timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The credential used to connect to the database.

Syntax

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

Fields

The request to clone and run a SQL tuning task. The new task uses the same inputs as the one being cloned.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_clone_sql_tuning_task_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  task_name varchar2(32767),
  original_task_id number,
  task_description varchar2(32767),
  credential_details dbms_cloud_oci_database_management_sql_tuning_task_credential_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_clone_sql_tuning_task_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_clone_sql_tuning_task_details_t (
    task_name varchar2,
    original_task_id number,
    task_description varchar2,
    credential_details dbms_cloud_oci_database_management_sql_tuning_task_credential_details_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The metric values with dimension details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_time_series_metric_data_point_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_timestamp timestamp with time zone,
  value number,
  unit varchar2(32767),
  dimensions dbms_cloud_oci_database_management_metric_dimension_definition_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_time_series_metric_data_point_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_time_series_metric_data_point_t (
    l_timestamp timestamp with time zone,
    value number,
    unit varchar2,
    dimensions dbms_cloud_oci_database_management_metric_dimension_definition_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_time_series_metric_data_point_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_time_series_metric_data_point_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_time_series_metric_data_point_t) NOT PERSISTABLE;

The response object representing time series metric details for a specific Managed Database at a particular time.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_database_management_time_series_metric_definition_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_time_series_metric_definition_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_time_series_metric_definition_t) NOT PERSISTABLE;

The response containing the cluster cache metrics for the Oracle Real Application Clusters (Oracle RAC) database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_cluster_cache_metric_t FORCE AUTHID CURRENT_USER IS OBJECT (
  cluster_cache_metrics dbms_cloud_oci_database_management_time_series_metric_definition_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_cluster_cache_metric_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_cluster_cache_metric_t (
    cluster_cache_metrics dbms_cloud_oci_database_management_time_series_metric_definition_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_automatic_capture_filter_details_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_automatic_capture_filter_details_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_automatic_capture_filter_details_t) NOT PERSISTABLE;

The details required to configure automatic capture filters.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_configure_automatic_capture_filters_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  auto_capture_filters dbms_cloud_oci_database_management_automatic_capture_filter_details_tbl,
  credentials dbms_cloud_oci_database_management_managed_database_credential_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_configure_automatic_capture_filters_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_configure_automatic_capture_filters_details_t (
    auto_capture_filters dbms_cloud_oci_database_management_automatic_capture_filter_details_tbl,
    credentials dbms_cloud_oci_database_management_managed_database_credential_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The set of parameters used in an SPM evolve task.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_spm_evolve_task_parameters_t FORCE AUTHID CURRENT_USER IS OBJECT (
  alternate_plan_sources dbms_cloud_oci_database_management_varchar2_tbl,
  alternate_plan_baselines dbms_cloud_oci_database_management_varchar2_tbl,
  alternate_plan_limit number,
  are_plans_auto_accepted number,
  allowed_time_limit number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_spm_evolve_task_parameters_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_spm_evolve_task_parameters_t (
    alternate_plan_sources dbms_cloud_oci_database_management_varchar2_tbl,
    alternate_plan_baselines dbms_cloud_oci_database_management_varchar2_tbl,
    alternate_plan_limit number,
    are_plans_auto_accepted number,
    allowed_time_limit number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The configuration details of the Automatic SPM Evolve Advisor task.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_configure_automatic_spm_evolve_advisor_task_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  task_parameters dbms_cloud_oci_database_management_spm_evolve_task_parameters_t,
  credentials dbms_cloud_oci_database_management_managed_database_credential_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_configure_automatic_spm_evolve_advisor_task_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_configure_automatic_spm_evolve_advisor_task_details_t (
    task_parameters dbms_cloud_oci_database_management_spm_evolve_task_parameters_t,
    credentials dbms_cloud_oci_database_management_managed_database_credential_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A summary of consumer group privileges.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_database_management_consumer_group_privilege_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_consumer_group_privilege_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_consumer_group_privilege_summary_t) NOT PERSISTABLE;

A collection of consumer group privileges granted to the current user.

Syntax

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

Fields

The metric statistics values with dimension details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_metric_statistics_definition_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_min number,
  l_max number,
  median number,
  lower_quartile number,
  upper_quartile number,
  unit varchar2(32767),
  dimensions dbms_cloud_oci_database_management_metric_dimension_definition_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_metric_statistics_definition_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_metric_statistics_definition_t (
    l_min number,
    l_max number,
    median number,
    lower_quartile number,
    upper_quartile number,
    unit varchar2,
    dimensions dbms_cloud_oci_database_management_metric_dimension_definition_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The CPU utilization metrics for Autonomous Databases.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_cpu_utilization_aggregate_metrics_t FORCE AUTHID CURRENT_USER IS OBJECT (
  cpu_utilization dbms_cloud_oci_database_management_metric_data_point_t,
  cpu_statistics dbms_cloud_oci_database_management_metric_statistics_definition_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_cpu_utilization_aggregate_metrics_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_cpu_utilization_aggregate_metrics_t (
    cpu_utilization dbms_cloud_oci_database_management_metric_data_point_t,
    cpu_statistics dbms_cloud_oci_database_management_metric_statistics_definition_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details used to create a new Database Management private endpoint.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_create_db_management_private_endpoint_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  compartment_id varchar2(32767),
  is_cluster number,
  subnet_id varchar2(32767),
  description varchar2(32767),
  nsg_ids dbms_cloud_oci_database_management_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_create_db_management_private_endpoint_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_create_db_management_private_endpoint_details_t (
    name varchar2,
    compartment_id varchar2,
    is_cluster number,
    subnet_id varchar2,
    description varchar2,
    nsg_ids dbms_cloud_oci_database_management_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details required to create an external DB system connector.

Syntax

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

Fields

The details required to enable Database Management for an external DB system.

Syntax

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

Fields

The details required to create an external DB system.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_create_external_db_system_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  db_system_discovery_id varchar2(32767),
  database_management_config dbms_cloud_oci_database_management_external_db_system_database_management_config_details_t,
  stack_monitoring_config dbms_cloud_oci_database_management_associated_service_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_create_external_db_system_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_create_external_db_system_details_t (
    display_name varchar2,
    compartment_id varchar2,
    db_system_discovery_id varchar2,
    database_management_config dbms_cloud_oci_database_management_external_db_system_database_management_config_details_t,
    stack_monitoring_config dbms_cloud_oci_database_management_associated_service_details_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details required to create an external DB system discovery resource.

Syntax

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

Fields

The connection details required to connect to an external DB system component.

Syntax

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

Fields

The details for creating an external connector that is used to connect to an external DB system component using the Management Agent Cloud Service (MACS).

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_create_external_db_system_macs_connector_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_management_create_external_db_system_connector_details_t (
  agent_id varchar2(32767),
  connection_info dbms_cloud_oci_database_management_external_db_system_connection_info_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_create_external_db_system_macs_connector_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_create_external_db_system_macs_connector_details_t (
    connector_type varchar2,
    display_name varchar2,
    external_db_system_id varchar2,
    agent_id varchar2,
    connection_info dbms_cloud_oci_database_management_external_db_system_connection_info_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_management_create_external_db_system_macs_connector_details_t is a subtype of the dbms_cloud_oci_database_management_create_external_db_system_connector_details_t type.

Fields

The details required to create the external Exadata infrastructure.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_create_external_exadata_infrastructure_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  discovery_key varchar2(32767),
  license_model varchar2(32767),
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  db_system_ids dbms_cloud_oci_database_management_varchar2_tbl,
  storage_server_names dbms_cloud_oci_database_management_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_create_external_exadata_infrastructure_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_create_external_exadata_infrastructure_details_t (
    discovery_key varchar2,
    license_model varchar2,
    compartment_id varchar2,
    display_name varchar2,
    db_system_ids dbms_cloud_oci_database_management_varchar2_tbl,
    storage_server_names dbms_cloud_oci_database_management_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The user credential information.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_rest_credential_t FORCE AUTHID CURRENT_USER IS OBJECT (
  username varchar2(32767),
  password varchar2(32767),
  ssl_trust_store_type varchar2(32767),
  ssl_trust_store_location varchar2(32767),
  ssl_trust_store_password varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_rest_credential_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_rest_credential_t (
    username varchar2,
    password varchar2,
    ssl_trust_store_type varchar2,
    ssl_trust_store_location varchar2,
    ssl_trust_store_password varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details required to create the connector to the Exadata storage server.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_create_external_exadata_storage_connector_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  storage_server_id varchar2(32767),
  agent_id varchar2(32767),
  connector_name varchar2(32767),
  connection_uri varchar2(32767),
  credential_info dbms_cloud_oci_database_management_rest_credential_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_create_external_exadata_storage_connector_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_create_external_exadata_storage_connector_details_t (
    storage_server_id varchar2,
    agent_id varchar2,
    connector_name varchar2,
    connection_uri varchar2,
    credential_info dbms_cloud_oci_database_management_rest_credential_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The location of the job execution result.

Syntax

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

Fields

The details of the job schedule.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_job_schedule_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  start_time varchar2(32767),
  end_time varchar2(32767),
  interval_type varchar2(32767),
  interval_value varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_job_schedule_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_job_schedule_details_t (
    start_time varchar2,
    end_time varchar2,
    interval_type varchar2,
    interval_value varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details required to create a job.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_create_job_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  description varchar2(32767),
  compartment_id varchar2(32767),
  managed_database_group_id varchar2(32767),
  managed_database_id varchar2(32767),
  database_sub_type varchar2(32767),
  schedule_type varchar2(32767),
  job_type varchar2(32767),
  timeout varchar2(32767),
  result_location dbms_cloud_oci_database_management_job_execution_result_location_t,
  schedule_details dbms_cloud_oci_database_management_job_schedule_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_create_job_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_create_job_details_t (
    name varchar2,
    description varchar2,
    compartment_id varchar2,
    managed_database_group_id varchar2,
    managed_database_id varchar2,
    database_sub_type varchar2,
    schedule_type varchar2,
    job_type varchar2,
    timeout varchar2,
    result_location dbms_cloud_oci_database_management_job_execution_result_location_t,
    schedule_details dbms_cloud_oci_database_management_job_schedule_details_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

The details required to create a Managed Database Group.

Syntax

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

Fields

The details of the job in-bind variable.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_job_in_bind_t FORCE AUTHID CURRENT_USER IS OBJECT (
  position number,
  data_type varchar2(32767),
  l_values dbms_cloud_oci_database_management_varchar2_tbl,
  array_type_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_job_in_bind_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_job_in_bind_t (
    position number,
    data_type varchar2,
    l_values dbms_cloud_oci_database_management_varchar2_tbl,
    array_type_name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_job_in_bind_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_job_in_bind_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_job_in_bind_t) NOT PERSISTABLE;

A collection of job in-bind variables.

Syntax

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

Fields

The details of the job out-bind variable.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_database_management_job_out_bind_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_job_out_bind_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_job_out_bind_t) NOT PERSISTABLE;

A collection of job out-bind variables.

Syntax

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

Fields

The details specific to the SQL job request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_create_sql_job_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_management_create_job_details_t (
  sql_text varchar2(32767),
  in_binds dbms_cloud_oci_database_management_job_in_binds_details_t,
  out_binds dbms_cloud_oci_database_management_job_out_binds_details_t,
  sql_type varchar2(32767),
  operation_type varchar2(32767),
  user_name varchar2(32767),
  password varchar2(32767),
  secret_id varchar2(32767),
  role varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_create_sql_job_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_create_sql_job_details_t (
    name varchar2,
    description varchar2,
    compartment_id varchar2,
    managed_database_group_id varchar2,
    managed_database_id varchar2,
    database_sub_type varchar2,
    schedule_type varchar2,
    job_type varchar2,
    timeout varchar2,
    result_location dbms_cloud_oci_database_management_job_execution_result_location_t,
    schedule_details dbms_cloud_oci_database_management_job_schedule_details_t,
    sql_text varchar2,
    in_binds dbms_cloud_oci_database_management_job_in_binds_details_t,
    out_binds dbms_cloud_oci_database_management_job_out_binds_details_t,
    sql_type varchar2,
    operation_type varchar2,
    user_name varchar2,
    password varchar2,
    secret_id varchar2,
    role varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_management_create_sql_job_details_t is a subtype of the dbms_cloud_oci_database_management_create_job_details_t type.

Fields

The credential to connect to the database to perform Sql tuning set administration tasks.

Syntax

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

Fields

Create an empty Sql tuning sets.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_create_sql_tuning_set_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  credential_details dbms_cloud_oci_database_management_sql_tuning_set_admin_credential_details_t,
  name varchar2(32767),
  owner varchar2(32767),
  description varchar2(32767),
  show_sql_only number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_create_sql_tuning_set_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_create_sql_tuning_set_details_t (
    credential_details dbms_cloud_oci_database_management_sql_tuning_set_admin_credential_details_t,
    name varchar2,
    owner varchar2,
    description varchar2,
    show_sql_only number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details required to create a tablespace.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_create_tablespace_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  credential_details dbms_cloud_oci_database_management_tablespace_admin_credential_details_t,
  name varchar2(32767),
  l_type varchar2(32767),
  is_bigfile number,
  data_files dbms_cloud_oci_database_management_varchar2_tbl,
  file_count number,
  file_size dbms_cloud_oci_database_management_tablespace_storage_size_t,
  is_reusable number,
  is_auto_extensible number,
  auto_extend_next_size dbms_cloud_oci_database_management_tablespace_storage_size_t,
  auto_extend_max_size dbms_cloud_oci_database_management_tablespace_storage_size_t,
  is_max_size_unlimited number,
  block_size_in_kilobytes number,
  is_encrypted number,
  encryption_algorithm varchar2(32767),
  default_compress varchar2(32767),
  status varchar2(32767),
  extent_management varchar2(32767),
  extent_uniform_size dbms_cloud_oci_database_management_tablespace_storage_size_t,
  segment_management varchar2(32767),
  is_default number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_create_tablespace_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_create_tablespace_details_t (
    credential_details dbms_cloud_oci_database_management_tablespace_admin_credential_details_t,
    name varchar2,
    l_type varchar2,
    is_bigfile number,
    data_files dbms_cloud_oci_database_management_varchar2_tbl,
    file_count number,
    file_size dbms_cloud_oci_database_management_tablespace_storage_size_t,
    is_reusable number,
    is_auto_extensible number,
    auto_extend_next_size dbms_cloud_oci_database_management_tablespace_storage_size_t,
    auto_extend_max_size dbms_cloud_oci_database_management_tablespace_storage_size_t,
    is_max_size_unlimited number,
    block_size_in_kilobytes number,
    is_encrypted number,
    encryption_algorithm varchar2,
    default_compress varchar2,
    status varchar2,
    extent_management varchar2,
    extent_uniform_size dbms_cloud_oci_database_management_tablespace_storage_size_t,
    segment_management varchar2,
    is_default number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The summary of a SQL statement in the cursor cache.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_database_management_cursor_cache_statement_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_cursor_cache_statement_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_cursor_cache_statement_summary_t) NOT PERSISTABLE;

The list of SQL statements in the cursor cache.

Syntax

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

Fields

A summary of the ContainerDataAccess user.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_database_management_data_access_container_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_data_access_container_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_data_access_container_summary_t) NOT PERSISTABLE;

A collection of specific containers for the current user. This is only applicable if ALL_CONTAINERS !='Y'.

Syntax

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

Fields

The credentials used to connect to the database. Currently only the `DETAILS` type is supported for creating MACS connector credentials.

Syntax

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

Fields

The existing named credential used to connect to the database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_database_connection_credentails_by_name_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_management_database_connection_credentials_t (
  l_credential_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_connection_credentails_by_name_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_connection_credentails_by_name_t (
    credential_type varchar2,
    l_credential_name varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_management_database_connection_credentails_by_name_t is a subtype of the dbms_cloud_oci_database_management_database_connection_credentials_t type.

Fields

The credentials used to connect to the database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_database_connection_credentials_by_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_management_database_connection_credentials_t (
  l_credential_name varchar2(32767),
  user_name varchar2(32767),
  password_secret_id varchar2(32767),
  role varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_connection_credentials_by_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_connection_credentials_by_details_t (
    credential_type varchar2,
    l_credential_name varchar2,
    user_name varchar2,
    password_secret_id varchar2,
    role varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_management_database_connection_credentials_by_details_t is a subtype of the dbms_cloud_oci_database_management_database_connection_credentials_t type.

Fields

The Oracle Database connection string.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_database_connection_string_t FORCE AUTHID CURRENT_USER IS OBJECT (
  host_name varchar2(32767),
  port number,
  service varchar2(32767),
  protocol varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_connection_string_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_connection_string_t (
    host_name varchar2,
    port number,
    service varchar2,
    protocol varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A summary of the fleet metrics, which provides the metric aggregated value of the databases in the fleet.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_fleet_metric_summary_definition_t FORCE AUTHID CURRENT_USER IS OBJECT (
  metric_name varchar2(32767),
  baseline_value number,
  target_value number,
  unit varchar2(32767),
  percentage_change number,
  dimensions dbms_cloud_oci_database_management_metric_dimension_definition_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_fleet_metric_summary_definition_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_fleet_metric_summary_definition_t (
    metric_name varchar2,
    baseline_value number,
    target_value number,
    unit varchar2,
    percentage_change number,
    dimensions dbms_cloud_oci_database_management_metric_dimension_definition_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The number of databases in the fleet, grouped by database type and sub type.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_fleet_status_by_category_t FORCE AUTHID CURRENT_USER IS OBJECT (
  database_type varchar2(32767),
  database_sub_type varchar2(32767),
  deployment_type varchar2(32767),
  inventory_count number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_fleet_status_by_category_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_fleet_status_by_category_t (
    database_type varchar2,
    database_sub_type varchar2,
    deployment_type varchar2,
    inventory_count number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_fleet_metric_summary_definition_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_fleet_metric_summary_definition_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_fleet_metric_summary_definition_t) NOT PERSISTABLE;

Nested table type of dbms_cloud_oci_database_management_fleet_status_by_category_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_fleet_status_by_category_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_fleet_status_by_category_t) NOT PERSISTABLE;

A summary of the inventory count grouped by database type and subtype, and the metrics that describe the aggregated usage of CPU, storage, and so on of all the databases in the fleet.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_fleet_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  aggregated_metrics dbms_cloud_oci_database_management_fleet_metric_summary_definition_tbl,
  inventory dbms_cloud_oci_database_management_fleet_status_by_category_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_fleet_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_fleet_summary_t (
    aggregated_metrics dbms_cloud_oci_database_management_fleet_metric_summary_definition_tbl,
    inventory dbms_cloud_oci_database_management_fleet_status_by_category_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The database metric details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_fleet_metric_definition_t FORCE AUTHID CURRENT_USER IS OBJECT (
  metric_name varchar2(32767),
  baseline_value number,
  target_value number,
  unit varchar2(32767),
  l_timestamp timestamp with time zone,
  percentage_change number,
  dimensions dbms_cloud_oci_database_management_metric_dimension_definition_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_fleet_metric_definition_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_fleet_metric_definition_t (
    metric_name varchar2,
    baseline_value number,
    target_value number,
    unit varchar2,
    l_timestamp timestamp with time zone,
    percentage_change number,
    dimensions dbms_cloud_oci_database_management_metric_dimension_definition_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_fleet_metric_definition_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_fleet_metric_definition_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_fleet_metric_definition_t) NOT PERSISTABLE;

The list of aggregated metrics for Managed Databases in the fleet.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_database_usage_metrics_t FORCE AUTHID CURRENT_USER IS OBJECT (
  db_id varchar2(32767),
  compartment_id varchar2(32767),
  database_type varchar2(32767),
  database_sub_type varchar2(32767),
  deployment_type varchar2(32767),
  database_version varchar2(32767),
  workload_type varchar2(32767),
  database_name varchar2(32767),
  database_container_id varchar2(32767),
  metrics dbms_cloud_oci_database_management_fleet_metric_definition_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_usage_metrics_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_usage_metrics_t (
    db_id varchar2,
    compartment_id varchar2,
    database_type varchar2,
    database_sub_type varchar2,
    deployment_type varchar2,
    database_version varchar2,
    workload_type varchar2,
    database_name varchar2,
    database_container_id varchar2,
    metrics dbms_cloud_oci_database_management_fleet_metric_definition_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_database_usage_metrics_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_database_usage_metrics_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_database_usage_metrics_t) NOT PERSISTABLE;

The details of the fleet health metrics.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_database_fleet_health_metrics_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compare_baseline_time varchar2(32767),
  compare_target_time varchar2(32767),
  compare_type varchar2(32767),
  fleet_summary dbms_cloud_oci_database_management_fleet_summary_t,
  fleet_databases dbms_cloud_oci_database_management_database_usage_metrics_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_fleet_health_metrics_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_fleet_health_metrics_t (
    compare_baseline_time varchar2,
    compare_target_time varchar2,
    compare_type varchar2,
    fleet_summary dbms_cloud_oci_database_management_fleet_summary_t,
    fleet_databases dbms_cloud_oci_database_management_database_usage_metrics_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The database time metric details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_database_time_aggregate_metrics_t FORCE AUTHID CURRENT_USER IS OBJECT (
  cpu_count dbms_cloud_oci_database_management_metric_data_point_t,
  cpu_time dbms_cloud_oci_database_management_metric_data_point_t,
  wait_time dbms_cloud_oci_database_management_metric_data_point_t,
  user_io_time dbms_cloud_oci_database_management_metric_data_point_t,
  l_cluster dbms_cloud_oci_database_management_metric_data_point_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_time_aggregate_metrics_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_time_aggregate_metrics_t (
    cpu_count dbms_cloud_oci_database_management_metric_data_point_t,
    cpu_time dbms_cloud_oci_database_management_metric_data_point_t,
    wait_time dbms_cloud_oci_database_management_metric_data_point_t,
    user_io_time dbms_cloud_oci_database_management_metric_data_point_t,
    l_cluster dbms_cloud_oci_database_management_metric_data_point_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_metric_data_point_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_metric_data_point_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_metric_data_point_t) NOT PERSISTABLE;

Nested table type of dbms_cloud_oci_database_management_metric_statistics_definition_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_metric_statistics_definition_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_metric_statistics_definition_t) NOT PERSISTABLE;

The database Input/Output metric details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_database_io_aggregate_metrics_t FORCE AUTHID CURRENT_USER IS OBJECT (
  iops dbms_cloud_oci_database_management_metric_data_point_tbl,
  io_throughput dbms_cloud_oci_database_management_metric_data_point_tbl,
  iops_statistics dbms_cloud_oci_database_management_metric_statistics_definition_tbl,
  io_throughput_statistics dbms_cloud_oci_database_management_metric_statistics_definition_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_io_aggregate_metrics_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_io_aggregate_metrics_t (
    iops dbms_cloud_oci_database_management_metric_data_point_tbl,
    io_throughput dbms_cloud_oci_database_management_metric_data_point_tbl,
    iops_statistics dbms_cloud_oci_database_management_metric_statistics_definition_tbl,
    io_throughput_statistics dbms_cloud_oci_database_management_metric_statistics_definition_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The memory aggregate metric details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_memory_aggregate_metrics_t FORCE AUTHID CURRENT_USER IS OBJECT (
  memory_usage dbms_cloud_oci_database_management_metric_data_point_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_memory_aggregate_metrics_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_memory_aggregate_metrics_t (
    memory_usage dbms_cloud_oci_database_management_metric_data_point_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The database storage metric values.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_database_storage_aggregate_metrics_t FORCE AUTHID CURRENT_USER IS OBJECT (
  storage_allocated dbms_cloud_oci_database_management_metric_data_point_t,
  storage_used dbms_cloud_oci_database_management_metric_data_point_t,
  storage_used_by_table_space dbms_cloud_oci_database_management_metric_data_point_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_storage_aggregate_metrics_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_storage_aggregate_metrics_t (
    storage_allocated dbms_cloud_oci_database_management_metric_data_point_t,
    storage_used dbms_cloud_oci_database_management_metric_data_point_t,
    storage_used_by_table_space dbms_cloud_oci_database_management_metric_data_point_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The queued and running statement metrics for Autonomous Databases.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_statements_aggregate_metrics_t FORCE AUTHID CURRENT_USER IS OBJECT (
  queued_statements dbms_cloud_oci_database_management_metric_data_point_t,
  running_statements dbms_cloud_oci_database_management_metric_data_point_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_statements_aggregate_metrics_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_statements_aggregate_metrics_t (
    queued_statements dbms_cloud_oci_database_management_metric_data_point_t,
    running_statements dbms_cloud_oci_database_management_metric_data_point_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The failed connection metrics for Autonomous Databases on Shared Exadata Infrastructure.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_failed_connections_aggregate_metrics_t FORCE AUTHID CURRENT_USER IS OBJECT (
  failed_connections dbms_cloud_oci_database_management_metric_data_point_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_failed_connections_aggregate_metrics_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_failed_connections_aggregate_metrics_t (
    failed_connections dbms_cloud_oci_database_management_metric_data_point_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_activity_time_series_metrics_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_activity_time_series_metrics_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_activity_time_series_metrics_t) NOT PERSISTABLE;

The response containing the CPU, Storage, Wait, DB Time, and Memory metrics for a specific Managed Database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_database_home_metric_definition_t FORCE AUTHID CURRENT_USER IS OBJECT (
  activity_time_series_metrics dbms_cloud_oci_database_management_activity_time_series_metrics_tbl,
  db_time_aggregate_metrics dbms_cloud_oci_database_management_database_time_aggregate_metrics_t,
  io_aggregate_metrics dbms_cloud_oci_database_management_database_io_aggregate_metrics_t,
  memory_aggregate_metrics dbms_cloud_oci_database_management_memory_aggregate_metrics_t,
  db_storage_aggregate_metrics dbms_cloud_oci_database_management_database_storage_aggregate_metrics_t,
  cpu_utilization_aggregate_metrics dbms_cloud_oci_database_management_cpu_utilization_aggregate_metrics_t,
  statements_aggregate_metrics dbms_cloud_oci_database_management_statements_aggregate_metrics_t,
  failed_connections_aggregate_metrics dbms_cloud_oci_database_management_failed_connections_aggregate_metrics_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_home_metric_definition_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_home_metric_definition_t (
    activity_time_series_metrics dbms_cloud_oci_database_management_activity_time_series_metrics_tbl,
    db_time_aggregate_metrics dbms_cloud_oci_database_management_database_time_aggregate_metrics_t,
    io_aggregate_metrics dbms_cloud_oci_database_management_database_io_aggregate_metrics_t,
    memory_aggregate_metrics dbms_cloud_oci_database_management_memory_aggregate_metrics_t,
    db_storage_aggregate_metrics dbms_cloud_oci_database_management_database_storage_aggregate_metrics_t,
    cpu_utilization_aggregate_metrics dbms_cloud_oci_database_management_cpu_utilization_aggregate_metrics_t,
    statements_aggregate_metrics dbms_cloud_oci_database_management_statements_aggregate_metrics_t,
    failed_connections_aggregate_metrics dbms_cloud_oci_database_management_failed_connections_aggregate_metrics_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The response containing the CPU, Wait, DB Time, and Memory metrics for a specific Oracle Real Application Clusters (Oracle RAC) database instance.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_database_instance_home_metrics_definition_t FORCE AUTHID CURRENT_USER IS OBJECT (
  instance_name varchar2(32767),
  instance_number number,
  activity_time_series_metrics dbms_cloud_oci_database_management_activity_time_series_metrics_tbl,
  db_time_aggregate_metrics dbms_cloud_oci_database_management_database_time_aggregate_metrics_t,
  io_aggregate_metrics dbms_cloud_oci_database_management_database_io_aggregate_metrics_t,
  memory_aggregate_metrics dbms_cloud_oci_database_management_memory_aggregate_metrics_t,
  cpu_utilization_aggregate_metrics dbms_cloud_oci_database_management_cpu_utilization_aggregate_metrics_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_instance_home_metrics_definition_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_instance_home_metrics_definition_t (
    instance_name varchar2,
    instance_number number,
    activity_time_series_metrics dbms_cloud_oci_database_management_activity_time_series_metrics_tbl,
    db_time_aggregate_metrics dbms_cloud_oci_database_management_database_time_aggregate_metrics_t,
    io_aggregate_metrics dbms_cloud_oci_database_management_database_io_aggregate_metrics_t,
    memory_aggregate_metrics dbms_cloud_oci_database_management_memory_aggregate_metrics_t,
    cpu_utilization_aggregate_metrics dbms_cloud_oci_database_management_cpu_utilization_aggregate_metrics_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_database_instance_home_metrics_definition_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_database_instance_home_metrics_definition_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_database_instance_home_metrics_definition_t) NOT PERSISTABLE;

The response containing the metric collection for a specific Managed Database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_database_home_metrics_t FORCE AUTHID CURRENT_USER IS OBJECT (
  database_home_metrics dbms_cloud_oci_database_management_database_home_metric_definition_t,
  database_instance_home_metrics dbms_cloud_oci_database_management_database_instance_home_metrics_definition_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_home_metrics_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_home_metrics_t (
    database_home_metrics dbms_cloud_oci_database_management_database_home_metric_definition_t,
    database_instance_home_metrics dbms_cloud_oci_database_management_database_instance_home_metrics_definition_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The configuration of the Database Management service.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_database_management_allowed_parameter_value_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_allowed_parameter_value_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_allowed_parameter_value_t) NOT PERSISTABLE;

A summary of the database parameter.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_database_parameter_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  l_type varchar2(32767),
  value varchar2(32767),
  display_value varchar2(32767),
  l_number number,
  is_default number,
  is_session_modifiable number,
  is_system_modifiable varchar2(32767),
  is_pdb_modifiable number,
  is_instance_modifiable number,
  is_modified varchar2(32767),
  is_adjusted number,
  is_deprecated number,
  is_basic number,
  description varchar2(32767),
  ordinal number,
  update_comment varchar2(32767),
  container_id number,
  category varchar2(32767),
  constraint varchar2(32767),
  sid varchar2(32767),
  is_specified number,
  allowed_values dbms_cloud_oci_database_management_allowed_parameter_value_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_parameter_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_parameter_summary_t (
    name varchar2,
    l_type varchar2,
    value varchar2,
    display_value varchar2,
    l_number number,
    is_default number,
    is_session_modifiable number,
    is_system_modifiable varchar2,
    is_pdb_modifiable number,
    is_instance_modifiable number,
    is_modified varchar2,
    is_adjusted number,
    is_deprecated number,
    is_basic number,
    description varchar2,
    ordinal number,
    update_comment varchar2,
    container_id number,
    category varchar2,
    constraint varchar2,
    sid varchar2,
    is_specified number,
    allowed_values dbms_cloud_oci_database_management_allowed_parameter_value_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The result of database parameter update.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_database_management_database_parameter_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_database_parameter_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_database_parameter_summary_t) NOT PERSISTABLE;

A collection of database parameters.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_database_parameters_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  database_name varchar2(32767),
  database_type varchar2(32767),
  database_sub_type varchar2(32767),
  database_version varchar2(32767),
  items dbms_cloud_oci_database_management_database_parameter_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_parameters_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_parameters_collection_t (
    database_name varchar2,
    database_type varchar2,
    database_sub_type varchar2,
    database_version varchar2,
    items dbms_cloud_oci_database_management_database_parameter_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Manages resource allocation among databases. Besides the name, at least one other property must be available.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_database_plan_directive_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  l_share number,
  l_level number,
  allocation number,
  limit number,
  is_flash_cache_on number,
  is_pmem_cache_on number,
  is_flash_log_on number,
  is_pmem_log_on number,
  flash_cache_limit varchar2(32767),
  flash_cache_min varchar2(32767),
  flash_cache_size varchar2(32767),
  pmem_cache_limit varchar2(32767),
  pmem_cache_min varchar2(32767),
  pmem_cache_size varchar2(32767),
  asm_cluster varchar2(32767),
  l_type varchar2(32767),
  role varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_plan_directive_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_plan_directive_t (
    name varchar2,
    l_share number,
    l_level number,
    allocation number,
    limit number,
    is_flash_cache_on number,
    is_pmem_cache_on number,
    is_flash_log_on number,
    is_pmem_log_on number,
    flash_cache_limit varchar2,
    flash_cache_min varchar2,
    flash_cache_size varchar2,
    pmem_cache_limit varchar2,
    pmem_cache_min varchar2,
    pmem_cache_size varchar2,
    asm_cluster varchar2,
    l_type varchar2,
    role varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_database_plan_directive_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_database_plan_directive_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_database_plan_directive_t) NOT PERSISTABLE;

The resource allocation directives must all use the share attribute, or they must all use the level and allocation attributes. If you use the share attribute to allocate I/O resources, then the database plan can have a maximum of 1024 directives. If you use the level and allocation attributes to allocate I/O resources, then the database plan can have a maximum of 32 directives. Only one directive is allowed for each database name and each profile name.

Syntax

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

Fields

The SSL connection credential details used to connect to the database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_database_ssl_connection_credentials_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_management_database_connection_credentials_t (
  l_credential_name varchar2(32767),
  user_name varchar2(32767),
  password_secret_id varchar2(32767),
  role varchar2(32767),
  ssl_secret_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_ssl_connection_credentials_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_database_ssl_connection_credentials_t (
    credential_type varchar2,
    l_credential_name varchar2,
    user_name varchar2,
    password_secret_id varchar2,
    role varchar2,
    ssl_secret_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_management_database_ssl_connection_credentials_t is a subtype of the dbms_cloud_oci_database_management_database_connection_credentials_t type.

Fields

The details of a data file.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_datafile_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  status varchar2(32767),
  online_status varchar2(32767),
  is_auto_extensible number,
  lost_write_protect varchar2(32767),
  shared varchar2(32767),
  instance_id number,
  max_size_kb number,
  allocated_size_kb number,
  user_size_kb number,
  increment_by number,
  free_space_kb number,
  used_space_kb number,
  used_percent_available number,
  used_percent_allocated number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_datafile_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_datafile_t (
    name varchar2,
    status varchar2,
    online_status varchar2,
    is_auto_extensible number,
    lost_write_protect varchar2,
    shared varchar2,
    instance_id number,
    max_size_kb number,
    allocated_size_kb number,
    user_size_kb number,
    increment_by number,
    free_space_kb number,
    used_space_kb number,
    used_percent_available number,
    used_percent_allocated number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The metric details of a Database Management resource.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_db_management_analytics_metric_t FORCE AUTHID CURRENT_USER IS OBJECT (
  metric_name varchar2(32767),
  duration_in_seconds number,
  metadata json_element_t,
  dimensions json_element_t,
  start_timestamp_in_epoch_seconds number,
  mean number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_db_management_analytics_metric_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_db_management_analytics_metric_t (
    metric_name varchar2,
    duration_in_seconds number,
    metadata json_element_t,
    dimensions json_element_t,
    start_timestamp_in_epoch_seconds number,
    mean number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A Database Management private endpoint allows Database Management to connect to databases in a Virtual Cloud Network (VCN).

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_db_management_private_endpoint_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  name varchar2(32767),
  compartment_id varchar2(32767),
  is_cluster number,
  vcn_id varchar2(32767),
  subnet_id varchar2(32767),
  private_ip varchar2(32767),
  description varchar2(32767),
  time_created timestamp with time zone,
  lifecycle_state varchar2(32767),
  nsg_ids dbms_cloud_oci_database_management_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_db_management_private_endpoint_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_db_management_private_endpoint_t (
    id varchar2,
    name varchar2,
    compartment_id varchar2,
    is_cluster number,
    vcn_id varchar2,
    subnet_id varchar2,
    private_ip varchar2,
    description varchar2,
    time_created timestamp with time zone,
    lifecycle_state varchar2,
    nsg_ids dbms_cloud_oci_database_management_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The summary of a Database Management private endpoint.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_db_management_private_endpoint_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  name varchar2(32767),
  compartment_id varchar2(32767),
  vcn_id varchar2(32767),
  subnet_id varchar2(32767),
  description varchar2(32767),
  time_created timestamp with time zone,
  lifecycle_state varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_db_management_private_endpoint_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_db_management_private_endpoint_summary_t (
    id varchar2,
    name varchar2,
    compartment_id varchar2,
    vcn_id varchar2,
    subnet_id varchar2,
    description varchar2,
    time_created timestamp with time zone,
    lifecycle_state varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_database_management_db_management_private_endpoint_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_db_management_private_endpoint_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_db_management_private_endpoint_summary_t) NOT PERSISTABLE;

A collection of Database Management private endpoint objects.

Syntax

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

Fields

The base Exadata resource.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_dbm_resource_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  version varchar2(32767),
  internal_id varchar2(32767),
  status varchar2(32767),
  lifecycle_state varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_details varchar2(32767),
  additional_details json_element_t,
  resource_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_dbm_resource_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_dbm_resource_t (
    id varchar2,
    display_name varchar2,
    version varchar2,
    internal_id varchar2,
    status varchar2,
    lifecycle_state varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_details varchar2,
    additional_details json_element_t,
    resource_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

The details required to disable automatic initial plan capture.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_disable_automatic_initial_plan_capture_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  credentials dbms_cloud_oci_database_management_managed_database_credential_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_disable_automatic_initial_plan_capture_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_disable_automatic_initial_plan_capture_details_t (
    credentials dbms_cloud_oci_database_management_managed_database_credential_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details required to disable Automatic SPM Evolve Advisor task.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_disable_automatic_spm_evolve_advisor_task_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  credentials dbms_cloud_oci_database_management_managed_database_credential_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_disable_automatic_spm_evolve_advisor_task_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_disable_automatic_spm_evolve_advisor_task_details_t (
    credentials dbms_cloud_oci_database_management_managed_database_credential_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details required to disable high frequency Automatic SPM Evolve Advisor task.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_disable_high_frequency_automatic_spm_evolve_advisor_task_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  credentials dbms_cloud_oci_database_management_managed_database_credential_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_disable_high_frequency_automatic_spm_evolve_advisor_task_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_disable_high_frequency_automatic_spm_evolve_advisor_task_details_t (
    credentials dbms_cloud_oci_database_management_managed_database_credential_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details required to disable SQL plan baseline usage.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_disable_sql_plan_baselines_usage_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  credentials dbms_cloud_oci_database_management_managed_database_credential_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_disable_sql_plan_baselines_usage_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_disable_sql_plan_baselines_usage_details_t (
    credentials dbms_cloud_oci_database_management_managed_database_credential_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The connection details and the discovery options for the Exadata discovery.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_database_management_associated_component_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_associated_component_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_associated_component_t) NOT PERSISTABLE;

The details of an external DB system component.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_discovered_external_db_system_component_t FORCE AUTHID CURRENT_USER IS OBJECT (
  component_id varchar2(32767),
  display_name varchar2(32767),
  component_name varchar2(32767),
  component_type varchar2(32767),
  resource_id varchar2(32767),
  is_selected_for_monitoring number,
  status varchar2(32767),
  associated_components dbms_cloud_oci_database_management_associated_component_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_discovered_external_db_system_component_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_discovered_external_db_system_component_t (
    component_id varchar2,
    display_name varchar2,
    component_name varchar2,
    component_type varchar2,
    resource_id varchar2,
    is_selected_for_monitoring number,
    status varchar2,
    associated_components dbms_cloud_oci_database_management_associated_component_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

The details of an ASM instance discovered in an external DB system discovery run.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_discovered_external_asm_instance_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_management_discovered_external_db_system_component_t (
  host_name varchar2(32767),
  instance_name varchar2(32767),
  adr_home_directory varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_discovered_external_asm_instance_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_discovered_external_asm_instance_t (
    component_id varchar2,
    display_name varchar2,
    component_name varchar2,
    component_type varchar2,
    resource_id varchar2,
    is_selected_for_monitoring number,
    status varchar2,
    associated_components dbms_cloud_oci_database_management_associated_component_tbl,
    host_name varchar2,
    instance_name varchar2,
    adr_home_directory varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_management_discovered_external_asm_instance_t is a subtype of the dbms_cloud_oci_database_management_discovered_external_db_system_component_t type.

Fields

The connector details used to connect to the external DB system component.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_external_db_system_discovery_connector_t FORCE AUTHID CURRENT_USER IS OBJECT (
  connector_type varchar2(32767),
  display_name varchar2(32767),
  connection_status varchar2(32767),
  connection_failure_message varchar2(32767),
  time_connection_status_last_updated timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_external_db_system_discovery_connector_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_external_db_system_discovery_connector_t (
    connector_type varchar2,
    display_name varchar2,
    connection_status varchar2,
    connection_failure_message varchar2,
    time_connection_status_last_updated timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Nested table type of dbms_cloud_oci_database_management_discovered_external_asm_instance_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_discovered_external_asm_instance_tbl FORCE IS TABLE OF (dbms_cloud_oci_database_management_discovered_external_asm_instance_t) NOT PERSISTABLE;

The details of an ASM discovered in an external DB system discovery run.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_database_management_discovered_external_asm_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_database_management_discovered_external_db_system_component_t (
  grid_home varchar2(32767),
  is_flex_enabled number,
  version varchar2(32767),
  asm_instances dbms_cloud_oci_database_management_discovered_external_asm_instance_tbl,
  connector dbms_cloud_oci_database_management_external_db_system_discovery_connector_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_discovered_external_asm_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_database_management_discovered_external_asm_t (
    component_id varchar2,
    display_name varchar2,
    component_name varchar2,
    component_type varchar2,
    resource_id varchar2,
    is_selected_for_monitoring number,
    status varchar2,
    associated_components dbms_cloud_oci_database_management_associated_component_tbl,
    grid_home varchar2,
    is_flex_enabled number,
    version varchar2,
    asm_instances dbms_cloud_oci_database_management_discovered_external_asm_instance_tbl,
    connector dbms_cloud_oci_database_management_external_db_system_discovery_connector_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_database_management_discovered_external_asm_t is a subtype of the dbms_cloud_oci_database_management_discovered_external_db_system_component_t type.

Fields