Nested table type of varchar2(32767).

Syntax

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

Compartment OCID of the Enterprise Manager member entity (e.g. databases and hosts) associated with an Exadata system.

Syntax

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

Fields

The information about the members of Exadata system to be added.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_opsi_create_em_managed_external_exadata_member_entity_details_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_create_em_managed_external_exadata_member_entity_details_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_create_em_managed_external_exadata_member_entity_details_t) NOT PERSISTABLE;

The information about the members of Exadata system to be added. If memberEntityDetails is not specified, the the Enterprise Manager entity (e.g. databases and hosts) associated with an Exadata system will be placed in the same compartment as the Exadata system.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_add_em_managed_external_exadata_insight_members_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_add_exadata_insight_members_details_t (
  member_entity_details dbms_cloud_oci_opsi_create_em_managed_external_exadata_member_entity_details_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_add_em_managed_external_exadata_insight_members_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_add_em_managed_external_exadata_insight_members_details_t (
    entity_source varchar2,
    member_entity_details dbms_cloud_oci_opsi_create_em_managed_external_exadata_member_entity_details_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_add_em_managed_external_exadata_insight_members_details_t is a subtype of the dbms_cloud_oci_opsi_add_exadata_insight_members_details_t type.

Fields

User credential details to connect to the database. This is supplied via the External Database Service.

Syntax

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

Fields

Input Host Details used for connection requests for private endpoint accessed db resource.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_opsi_pe_comanaged_database_host_details_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_pe_comanaged_database_host_details_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_pe_comanaged_database_host_details_t) NOT PERSISTABLE;

Connection details of the private endpoints.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_pe_comanaged_database_connection_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  hosts dbms_cloud_oci_opsi_pe_comanaged_database_host_details_tbl,
  protocol varchar2(32767),
  service_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_pe_comanaged_database_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_pe_comanaged_database_connection_details_t (
    hosts dbms_cloud_oci_opsi_pe_comanaged_database_host_details_tbl,
    protocol varchar2,
    service_name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The information about database to be analyzed.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_create_database_insight_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  entity_source varchar2(32767),
  compartment_id varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_database_insight_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_database_insight_details_t (
    entity_source varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

The information about database to be analyzed. Either an opsiPrivateEndpointId or dbmPrivateEndpointId must be specified. If the dbmPrivateEndpointId is specified, a new Operations Insights private endpoint will be created.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_create_pe_comanaged_database_insight_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_create_database_insight_details_t (
  database_id varchar2(32767),
  database_resource_type varchar2(32767),
  opsi_private_endpoint_id varchar2(32767),
  dbm_private_endpoint_id varchar2(32767),
  service_name varchar2(32767),
  credential_details dbms_cloud_oci_opsi_credential_details_t,
  connection_details dbms_cloud_oci_opsi_pe_comanaged_database_connection_details_t,
  deployment_type varchar2(32767),
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_pe_comanaged_database_insight_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_pe_comanaged_database_insight_details_t (
    entity_source varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    database_id varchar2,
    database_resource_type varchar2,
    opsi_private_endpoint_id varchar2,
    dbm_private_endpoint_id varchar2,
    service_name varchar2,
    credential_details dbms_cloud_oci_opsi_credential_details_t,
    connection_details dbms_cloud_oci_opsi_pe_comanaged_database_connection_details_t,
    deployment_type varchar2,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_create_pe_comanaged_database_insight_details_t is a subtype of the dbms_cloud_oci_opsi_create_database_insight_details_t type.

Fields

Nested table type of dbms_cloud_oci_opsi_create_pe_comanaged_database_insight_details_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_create_pe_comanaged_database_insight_details_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_create_pe_comanaged_database_insight_details_t) NOT PERSISTABLE;

The information of the VM Cluster which contains databases. Either an opsiPrivateEndpointId or dbmPrivateEndpointId must be specified. If the dbmPrivateEndpointId is specified, a new Operations Insights private endpoint will be created.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_create_pe_comanaged_exadata_vmcluster_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  vmcluster_id varchar2(32767),
  opsi_private_endpoint_id varchar2(32767),
  dbm_private_endpoint_id varchar2(32767),
  member_database_details dbms_cloud_oci_opsi_create_pe_comanaged_database_insight_details_tbl,
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_pe_comanaged_exadata_vmcluster_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_pe_comanaged_exadata_vmcluster_details_t (
    vmcluster_id varchar2,
    opsi_private_endpoint_id varchar2,
    dbm_private_endpoint_id varchar2,
    member_database_details dbms_cloud_oci_opsi_create_pe_comanaged_database_insight_details_tbl,
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_opsi_create_pe_comanaged_exadata_vmcluster_details_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_create_pe_comanaged_exadata_vmcluster_details_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_create_pe_comanaged_exadata_vmcluster_details_t) NOT PERSISTABLE;

The information about the members of Exadata system to be added.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_add_pe_comanaged_exadata_insight_members_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_add_exadata_insight_members_details_t (
  member_entity_details dbms_cloud_oci_opsi_create_pe_comanaged_exadata_vmcluster_details_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_add_pe_comanaged_exadata_insight_members_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_add_pe_comanaged_exadata_insight_members_details_t (
    entity_source varchar2,
    member_entity_details dbms_cloud_oci_opsi_create_pe_comanaged_exadata_vmcluster_details_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_add_pe_comanaged_exadata_insight_members_details_t is a subtype of the dbms_cloud_oci_opsi_add_exadata_insight_members_details_t type.

Fields

Object containing hostname and instance name mapping.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_opsi_host_instance_map_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_host_instance_map_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_host_instance_map_t) NOT PERSISTABLE;

Partial information about the database which includes id, name, type.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_database_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  database_id varchar2(32767),
  compartment_id varchar2(32767),
  database_name varchar2(32767),
  database_display_name varchar2(32767),
  database_type varchar2(32767),
  database_version varchar2(32767),
  instances dbms_cloud_oci_opsi_host_instance_map_tbl,
  cdb_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_database_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_database_details_t (
    id varchar2,
    database_id varchar2,
    compartment_id varchar2,
    database_name varchar2,
    database_display_name varchar2,
    database_type varchar2,
    database_version varchar2,
    instances dbms_cloud_oci_opsi_host_instance_map_tbl,
    cdb_name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

ADDM summary for a database

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  database_details dbms_cloud_oci_opsi_database_details_t,
  number_of_findings number,
  number_of_addm_tasks number,
  time_first_snapshot_begin timestamp with time zone,
  time_latest_snapshot_end timestamp with time zone,
  snapshot_interval_start varchar2(32767),
  snapshot_interval_end varchar2(32767),
  max_overall_impact number,
  most_frequent_category_name varchar2(32767),
  most_frequent_category_display_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_summary_t (
    database_details dbms_cloud_oci_opsi_database_details_t,
    number_of_findings number,
    number_of_addm_tasks number,
    time_first_snapshot_begin timestamp with time zone,
    time_latest_snapshot_end timestamp with time zone,
    snapshot_interval_start varchar2,
    snapshot_interval_end varchar2,
    max_overall_impact number,
    most_frequent_category_name varchar2,
    most_frequent_category_display_name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_opsi_addm_db_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_addm_db_summary_t) NOT PERSISTABLE;

The result of ADDM databases

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  time_interval_start timestamp with time zone,
  time_interval_end timestamp with time zone,
  items dbms_cloud_oci_opsi_addm_db_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_collection_t (
    time_interval_start timestamp with time zone,
    time_interval_end timestamp with time zone,
    items dbms_cloud_oci_opsi_addm_db_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summarizes a specific ADDM finding

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_finding_aggregation_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  finding_id varchar2(32767),
  category_name varchar2(32767),
  category_display_name varchar2(32767),
  name varchar2(32767),
  message varchar2(32767),
  impact_overall_percent number,
  impact_max_percent number,
  impact_avg_active_sessions number,
  frequency_count number,
  recommendation_count number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_finding_aggregation_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_finding_aggregation_t (
    id varchar2,
    finding_id varchar2,
    category_name varchar2,
    category_display_name varchar2,
    name varchar2,
    message varchar2,
    impact_overall_percent number,
    impact_max_percent number,
    impact_avg_active_sessions number,
    frequency_count number,
    recommendation_count number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_opsi_database_details_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_database_details_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_database_details_t) NOT PERSISTABLE;

Nested table type of dbms_cloud_oci_opsi_addm_db_finding_aggregation_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_finding_aggregation_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_addm_db_finding_aggregation_t) NOT PERSISTABLE;

Summarizes ADDM findings over specified time period

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_finding_aggregation_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  time_interval_start timestamp with time zone,
  time_interval_end timestamp with time zone,
  database_details_items dbms_cloud_oci_opsi_database_details_tbl,
  items dbms_cloud_oci_opsi_addm_db_finding_aggregation_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_finding_aggregation_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_finding_aggregation_collection_t (
    time_interval_start timestamp with time zone,
    time_interval_end timestamp with time zone,
    database_details_items dbms_cloud_oci_opsi_database_details_tbl,
    items dbms_cloud_oci_opsi_addm_db_finding_aggregation_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Finding category summary

Syntax

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

Fields

Nested table type of dbms_cloud_oci_opsi_addm_db_finding_category_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_finding_category_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_addm_db_finding_category_summary_t) NOT PERSISTABLE;

List of finding categories

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_finding_category_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  database_details_items dbms_cloud_oci_opsi_database_details_tbl,
  items dbms_cloud_oci_opsi_addm_db_finding_category_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_finding_category_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_finding_category_collection_t (
    database_details_items dbms_cloud_oci_opsi_database_details_tbl,
    items dbms_cloud_oci_opsi_addm_db_finding_category_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

ADDM findings time series data

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_findings_time_series_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  task_id number,
  task_name varchar2(32767),
  finding_id varchar2(32767),
  l_timestamp timestamp with time zone,
  time_analysis_started timestamp with time zone,
  time_analysis_ended timestamp with time zone,
  category_name varchar2(32767),
  category_display_name varchar2(32767),
  name varchar2(32767),
  message varchar2(32767),
  analysis_db_time_in_secs number,
  analysis_avg_active_sessions number,
  impact_db_time_in_secs number,
  impact_percent number,
  impact_avg_active_sessions number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_findings_time_series_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_findings_time_series_summary_t (
    id varchar2,
    task_id number,
    task_name varchar2,
    finding_id varchar2,
    l_timestamp timestamp with time zone,
    time_analysis_started timestamp with time zone,
    time_analysis_ended timestamp with time zone,
    category_name varchar2,
    category_display_name varchar2,
    name varchar2,
    message varchar2,
    analysis_db_time_in_secs number,
    analysis_avg_active_sessions number,
    impact_db_time_in_secs number,
    impact_percent number,
    impact_avg_active_sessions number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_opsi_addm_db_findings_time_series_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_findings_time_series_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_addm_db_findings_time_series_summary_t) NOT PERSISTABLE;

ADDM findings time series response.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_findings_time_series_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  time_interval_start timestamp with time zone,
  time_interval_end timestamp with time zone,
  database_details_items dbms_cloud_oci_opsi_database_details_tbl,
  items dbms_cloud_oci_opsi_addm_db_findings_time_series_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_findings_time_series_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_findings_time_series_collection_t (
    time_interval_start timestamp with time zone,
    time_interval_end timestamp with time zone,
    database_details_items dbms_cloud_oci_opsi_database_details_tbl,
    items dbms_cloud_oci_opsi_addm_db_findings_time_series_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summarizes change history for specific database parameter

Syntax

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

Fields

Nested table type of dbms_cloud_oci_opsi_addm_db_parameter_aggregation_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_parameter_aggregation_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_addm_db_parameter_aggregation_t) NOT PERSISTABLE;

Summarizes AWR parameter change history over specified time period

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_parameter_aggregation_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  time_interval_start timestamp with time zone,
  time_interval_end timestamp with time zone,
  database_details_items dbms_cloud_oci_opsi_database_details_tbl,
  items dbms_cloud_oci_opsi_addm_db_parameter_aggregation_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_parameter_aggregation_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_parameter_aggregation_collection_t (
    time_interval_start timestamp with time zone,
    time_interval_end timestamp with time zone,
    database_details_items dbms_cloud_oci_opsi_database_details_tbl,
    items dbms_cloud_oci_opsi_addm_db_parameter_aggregation_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Database parameter category summary

Syntax

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

Fields

Nested table type of dbms_cloud_oci_opsi_addm_db_parameter_category_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_parameter_category_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_addm_db_parameter_category_summary_t) NOT PERSISTABLE;

List of database parameter categories

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_parameter_category_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  database_details_items dbms_cloud_oci_opsi_database_details_tbl,
  items dbms_cloud_oci_opsi_addm_db_parameter_category_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_parameter_category_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_parameter_category_collection_t (
    database_details_items dbms_cloud_oci_opsi_database_details_tbl,
    items dbms_cloud_oci_opsi_addm_db_parameter_category_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Change record for AWR database parameter

Syntax

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

Fields

Nested table type of dbms_cloud_oci_opsi_addm_db_parameter_change_aggregation_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_parameter_change_aggregation_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_addm_db_parameter_change_aggregation_t) NOT PERSISTABLE;

Summarizes AWR parameter change history over specified time period for specified parameter

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_parameter_change_aggregation_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  time_interval_start timestamp with time zone,
  time_interval_end timestamp with time zone,
  database_details_items dbms_cloud_oci_opsi_database_details_tbl,
  items dbms_cloud_oci_opsi_addm_db_parameter_change_aggregation_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_parameter_change_aggregation_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_parameter_change_aggregation_collection_t (
    time_interval_start timestamp with time zone,
    time_interval_end timestamp with time zone,
    database_details_items dbms_cloud_oci_opsi_database_details_tbl,
    items dbms_cloud_oci_opsi_addm_db_parameter_change_aggregation_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Related object details

Syntax

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

Fields

Summarizes a specific ADDM recommendation

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_recommendation_aggregation_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  l_type varchar2(32767),
  message varchar2(32767),
  requires_db_restart varchar2(32767),
  implement_actions dbms_cloud_oci_opsi_varchar2_tbl,
  rationale varchar2(32767),
  max_benefit_percent number,
  overall_benefit_percent number,
  max_benefit_avg_active_sessions number,
  frequency_count number,
  related_object dbms_cloud_oci_opsi_related_object_type_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_recommendation_aggregation_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_recommendation_aggregation_t (
    id varchar2,
    l_type varchar2,
    message varchar2,
    requires_db_restart varchar2,
    implement_actions dbms_cloud_oci_opsi_varchar2_tbl,
    rationale varchar2,
    max_benefit_percent number,
    overall_benefit_percent number,
    max_benefit_avg_active_sessions number,
    frequency_count number,
    related_object dbms_cloud_oci_opsi_related_object_type_details_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_opsi_addm_db_recommendation_aggregation_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_recommendation_aggregation_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_addm_db_recommendation_aggregation_t) NOT PERSISTABLE;

Summarizes ADDM recommendations over specified time period

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_recommendation_aggregation_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  time_interval_start timestamp with time zone,
  time_interval_end timestamp with time zone,
  database_details_items dbms_cloud_oci_opsi_database_details_tbl,
  items dbms_cloud_oci_opsi_addm_db_recommendation_aggregation_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_recommendation_aggregation_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_recommendation_aggregation_collection_t (
    time_interval_start timestamp with time zone,
    time_interval_end timestamp with time zone,
    database_details_items dbms_cloud_oci_opsi_database_details_tbl,
    items dbms_cloud_oci_opsi_addm_db_recommendation_aggregation_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Recommendation category summary

Syntax

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

Fields

Nested table type of dbms_cloud_oci_opsi_addm_db_recommendation_category_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_recommendation_category_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_addm_db_recommendation_category_summary_t) NOT PERSISTABLE;

List of recommendation categories

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_recommendation_category_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  database_details_items dbms_cloud_oci_opsi_database_details_tbl,
  items dbms_cloud_oci_opsi_addm_db_recommendation_category_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_recommendation_category_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_recommendation_category_collection_t (
    database_details_items dbms_cloud_oci_opsi_database_details_tbl,
    items dbms_cloud_oci_opsi_addm_db_recommendation_category_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

ADDM recommendation

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_recommendations_time_series_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  task_id number,
  task_name varchar2(32767),
  l_timestamp timestamp with time zone,
  time_analysis_started timestamp with time zone,
  time_analysis_ended timestamp with time zone,
  l_type varchar2(32767),
  analysis_db_time_in_secs number,
  analysis_avg_active_sessions number,
  max_benefit_percent number,
  max_benefit_db_time_in_secs number,
  max_benefit_avg_active_sessions number,
  related_object dbms_cloud_oci_opsi_related_object_type_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_recommendations_time_series_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_recommendations_time_series_summary_t (
    id varchar2,
    task_id number,
    task_name varchar2,
    l_timestamp timestamp with time zone,
    time_analysis_started timestamp with time zone,
    time_analysis_ended timestamp with time zone,
    l_type varchar2,
    analysis_db_time_in_secs number,
    analysis_avg_active_sessions number,
    max_benefit_percent number,
    max_benefit_db_time_in_secs number,
    max_benefit_avg_active_sessions number,
    related_object dbms_cloud_oci_opsi_related_object_type_details_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_opsi_addm_db_recommendations_time_series_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_recommendations_time_series_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_addm_db_recommendations_time_series_summary_t) NOT PERSISTABLE;

ADDM recommendations time series

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_recommendations_time_series_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  time_interval_start timestamp with time zone,
  time_interval_end timestamp with time zone,
  database_details_items dbms_cloud_oci_opsi_database_details_tbl,
  items dbms_cloud_oci_opsi_addm_db_recommendations_time_series_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_recommendations_time_series_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_recommendations_time_series_collection_t (
    time_interval_start timestamp with time zone,
    time_interval_end timestamp with time zone,
    database_details_items dbms_cloud_oci_opsi_database_details_tbl,
    items dbms_cloud_oci_opsi_addm_db_recommendations_time_series_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details for a given object id

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_schema_object_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  object_identifier number,
  owner varchar2(32767),
  object_name varchar2(32767),
  sub_object_name varchar2(32767),
  object_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_schema_object_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_schema_object_summary_t (
    id varchar2,
    object_identifier number,
    owner varchar2,
    object_name varchar2,
    sub_object_name varchar2,
    object_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_opsi_addm_db_schema_object_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_schema_object_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_addm_db_schema_object_summary_t) NOT PERSISTABLE;

Summarizes Schema Objects over specified time period

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_schema_object_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  time_interval_start timestamp with time zone,
  time_interval_end timestamp with time zone,
  database_details_items dbms_cloud_oci_opsi_database_details_tbl,
  items dbms_cloud_oci_opsi_addm_db_schema_object_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_schema_object_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_schema_object_collection_t (
    time_interval_start timestamp with time zone,
    time_interval_end timestamp with time zone,
    database_details_items dbms_cloud_oci_opsi_database_details_tbl,
    items dbms_cloud_oci_opsi_addm_db_schema_object_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details for a given SQL ID

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_sql_statement_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  sql_identifier varchar2(32767),
  sql_text varchar2(32767),
  is_sql_text_truncated number,
  sql_command varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_sql_statement_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_sql_statement_summary_t (
    id varchar2,
    sql_identifier varchar2,
    sql_text varchar2,
    is_sql_text_truncated number,
    sql_command varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_opsi_addm_db_sql_statement_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_sql_statement_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_addm_db_sql_statement_summary_t) NOT PERSISTABLE;

Summarizes SQL statements over specified time period

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_db_sql_statement_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  time_interval_start timestamp with time zone,
  time_interval_end timestamp with time zone,
  database_details_items dbms_cloud_oci_opsi_database_details_tbl,
  items dbms_cloud_oci_opsi_addm_db_sql_statement_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_sql_statement_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_db_sql_statement_collection_t (
    time_interval_start timestamp with time zone,
    time_interval_end timestamp with time zone,
    database_details_items dbms_cloud_oci_opsi_database_details_tbl,
    items dbms_cloud_oci_opsi_addm_db_sql_statement_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

ADDM Tasks.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_addm_report_t FORCE AUTHID CURRENT_USER IS OBJECT (
  time_interval_start timestamp with time zone,
  time_interval_end timestamp with time zone,
  task_identifier varchar2(32767),
  database_identifier varchar2(32767),
  snapshot_interval_start varchar2(32767),
  snapshot_interval_end varchar2(32767),
  addm_report varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_report_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_addm_report_t (
    time_interval_start timestamp with time zone,
    time_interval_end timestamp with time zone,
    task_identifier varchar2,
    database_identifier varchar2,
    snapshot_interval_start varchar2,
    snapshot_interval_end varchar2,
    addm_report varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of a database configuration for a resource.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_database_configuration_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  database_insight_id varchar2(32767),
  entity_source varchar2(32767),
  compartment_id varchar2(32767),
  database_name varchar2(32767),
  database_display_name varchar2(32767),
  database_type varchar2(32767),
  database_version varchar2(32767),
  cdb_name varchar2(32767),
  defined_tags json_element_t,
  freeform_tags json_element_t,
  processor_count number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_database_configuration_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_database_configuration_summary_t (
    database_insight_id varchar2,
    entity_source varchar2,
    compartment_id varchar2,
    database_name varchar2,
    database_display_name varchar2,
    database_type varchar2,
    database_version varchar2,
    cdb_name varchar2,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    processor_count number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Configuration Summary of autonomous database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_autonomous_database_configuration_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_database_configuration_summary_t (
  database_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_autonomous_database_configuration_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_autonomous_database_configuration_summary_t (
    database_insight_id varchar2,
    entity_source varchar2,
    compartment_id varchar2,
    database_name varchar2,
    database_display_name varchar2,
    database_type varchar2,
    database_version varchar2,
    cdb_name varchar2,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    processor_count number,
    database_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_autonomous_database_configuration_summary_t is a subtype of the dbms_cloud_oci_opsi_database_configuration_summary_t type.

Fields

Connection details to connect to the database. HostName, protocol, and port should be specified.

Syntax

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

Fields

Database insight resource.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_database_insight_t FORCE AUTHID CURRENT_USER IS OBJECT (
  entity_source varchar2(32767),
  id varchar2(32767),
  compartment_id varchar2(32767),
  status varchar2(32767),
  database_type varchar2(32767),
  database_version varchar2(32767),
  processor_count number,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  database_connection_status_details varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_database_insight_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_database_insight_t (
    entity_source varchar2,
    id varchar2,
    compartment_id varchar2,
    status varchar2,
    database_type varchar2,
    database_version varchar2,
    processor_count number,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    database_connection_status_details varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Database insight resource.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_autonomous_database_insight_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_database_insight_t (
  database_id varchar2(32767),
  database_name varchar2(32767),
  database_display_name varchar2(32767),
  database_resource_type varchar2(32767),
  db_additional_details json_element_t,
  opsi_private_endpoint_id varchar2(32767),
  is_advanced_features_enabled number,
  connection_details dbms_cloud_oci_opsi_connection_details_t,
  credential_details dbms_cloud_oci_opsi_credential_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_autonomous_database_insight_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_autonomous_database_insight_t (
    entity_source varchar2,
    id varchar2,
    compartment_id varchar2,
    status varchar2,
    database_type varchar2,
    database_version varchar2,
    processor_count number,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    database_connection_status_details varchar2,
    database_id varchar2,
    database_name varchar2,
    database_display_name varchar2,
    database_resource_type varchar2,
    db_additional_details json_element_t,
    opsi_private_endpoint_id varchar2,
    is_advanced_features_enabled number,
    connection_details dbms_cloud_oci_opsi_connection_details_t,
    credential_details dbms_cloud_oci_opsi_credential_details_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_autonomous_database_insight_t is a subtype of the dbms_cloud_oci_opsi_database_insight_t type.

Fields

Summary of a database insight resource.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_database_insight_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  database_id varchar2(32767),
  compartment_id varchar2(32767),
  database_name varchar2(32767),
  database_display_name varchar2(32767),
  database_type varchar2(32767),
  database_version varchar2(32767),
  database_host_names dbms_cloud_oci_opsi_varchar2_tbl,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  entity_source varchar2(32767),
  processor_count number,
  status varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  database_connection_status_details varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_database_insight_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_database_insight_summary_t (
    id varchar2,
    database_id varchar2,
    compartment_id varchar2,
    database_name varchar2,
    database_display_name varchar2,
    database_type varchar2,
    database_version varchar2,
    database_host_names dbms_cloud_oci_opsi_varchar2_tbl,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    entity_source varchar2,
    processor_count number,
    status varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    database_connection_status_details varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Summary of a database insight resource.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_autonomous_database_insight_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_database_insight_summary_t (
  database_resource_type varchar2(32767),
  is_advanced_features_enabled number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_autonomous_database_insight_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_autonomous_database_insight_summary_t (
    id varchar2,
    database_id varchar2,
    compartment_id varchar2,
    database_name varchar2,
    database_display_name varchar2,
    database_type varchar2,
    database_version varchar2,
    database_host_names dbms_cloud_oci_opsi_varchar2_tbl,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    entity_source varchar2,
    processor_count number,
    status varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    database_connection_status_details varchar2,
    database_resource_type varchar2,
    is_advanced_features_enabled number
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_autonomous_database_insight_summary_t is a subtype of the dbms_cloud_oci_opsi_database_insight_summary_t type.

Fields

Nested table type of number.

Syntax

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

The AWR summary for a database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  awr_source_database_identifier varchar2(32767),
  db_name varchar2(32767),
  instance_list dbms_cloud_oci_opsi_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_identifier number,
  latest_snapshot_identifier number,
  snapshot_count number,
  snapshot_interval_in_min number,
  db_version varchar2(32767),
  snapshot_timezone varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_summary_t (
    awr_source_database_identifier varchar2,
    db_name varchar2,
    instance_list dbms_cloud_oci_opsi_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_identifier number,
    latest_snapshot_identifier number,
    snapshot_count number,
    snapshot_interval_in_min 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_opsi_awr_query_result_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  version varchar2(32767),
  db_query_time_in_secs number,
  awr_result_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_query_result_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_query_result_t (
    name varchar2,
    version 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_opsi_awr_database_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_awr_database_summary_t) NOT PERSISTABLE;

The result of AWR query.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_collection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_awr_query_result_t (
  items dbms_cloud_oci_opsi_awr_database_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_collection_t (
    name varchar2,
    version varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2,
    items dbms_cloud_oci_opsi_awr_database_summary_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_awr_database_collection_t is a subtype of the dbms_cloud_oci_opsi_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_opsi_awr_database_cpu_usage_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_timestamp timestamp with time zone,
  avg_usage_in_secs number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_cpu_usage_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_cpu_usage_summary_t (
    l_timestamp timestamp with time zone,
    avg_usage_in_secs number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_opsi_awr_database_cpu_usage_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_cpu_usage_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_awr_database_cpu_usage_summary_t) NOT PERSISTABLE;

The AWR CPU usage data.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_cpu_usage_collection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_awr_query_result_t (
  num_cpu_cores number,
  database_cpu_count number,
  host_cpu_count number,
  items dbms_cloud_oci_opsi_awr_database_cpu_usage_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_cpu_usage_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_cpu_usage_collection_t (
    name varchar2,
    version varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2,
    num_cpu_cores number,
    database_cpu_count number,
    host_cpu_count number,
    items dbms_cloud_oci_opsi_awr_database_cpu_usage_summary_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_awr_database_cpu_usage_collection_t is a subtype of the dbms_cloud_oci_opsi_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_opsi_awr_database_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_opsi_awr_database_metric_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_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_opsi_awr_database_metric_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_metric_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_awr_database_metric_summary_t) NOT PERSISTABLE;

The AWR metrics time series summary data.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_metric_collection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_awr_query_result_t (
  items dbms_cloud_oci_opsi_awr_database_metric_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_metric_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_metric_collection_t (
    name varchar2,
    version varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2,
    items dbms_cloud_oci_opsi_awr_database_metric_summary_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_awr_database_metric_collection_t is a subtype of the dbms_cloud_oci_opsi_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_opsi_awr_database_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_identifier number,
  value_modified varchar2(32767),
  is_default number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_parameter_change_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_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_identifier number,
    value_modified varchar2,
    is_default number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_opsi_awr_database_parameter_change_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_parameter_change_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_awr_database_parameter_change_summary_t) NOT PERSISTABLE;

The AWR database parameter change history.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_parameter_change_collection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_awr_query_result_t (
  items dbms_cloud_oci_opsi_awr_database_parameter_change_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_parameter_change_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_parameter_change_collection_t (
    name varchar2,
    version varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2,
    items dbms_cloud_oci_opsi_awr_database_parameter_change_summary_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_awr_database_parameter_change_collection_t is a subtype of the dbms_cloud_oci_opsi_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_opsi_awr_database_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_opsi_awr_database_parameter_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_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_opsi_awr_database_parameter_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_parameter_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_awr_database_parameter_summary_t) NOT PERSISTABLE;

The AWR database parameter data.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_parameter_collection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_awr_query_result_t (
  items dbms_cloud_oci_opsi_awr_database_parameter_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_parameter_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_parameter_collection_t (
    name varchar2,
    version varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2,
    items dbms_cloud_oci_opsi_awr_database_parameter_summary_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_awr_database_parameter_collection_t is a subtype of the dbms_cloud_oci_opsi_awr_query_result_t type.

Fields

The result of the AWR report.

Syntax

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

dbms_cloud_oci_opsi_awr_database_report_t is a subtype of the dbms_cloud_oci_opsi_awr_query_result_t type.

Fields

The AWR snapshot summary of one snapshot.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_snapshot_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  awr_source_database_identifier 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_identifier number,
  error_count number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_snapshot_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_snapshot_summary_t (
    awr_source_database_identifier varchar2,
    instance_number number,
    time_db_startup timestamp with time zone,
    time_begin timestamp with time zone,
    time_end timestamp with time zone,
    snapshot_identifier number,
    error_count number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_opsi_awr_database_snapshot_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_snapshot_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_awr_database_snapshot_summary_t) NOT PERSISTABLE;

The list of AWR snapshots for one database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_snapshot_collection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_awr_query_result_t (
  items dbms_cloud_oci_opsi_awr_database_snapshot_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_snapshot_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_snapshot_collection_t (
    name varchar2,
    version varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2,
    items dbms_cloud_oci_opsi_awr_database_snapshot_summary_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_awr_database_snapshot_collection_t is a subtype of the dbms_cloud_oci_opsi_awr_query_result_t type.

Fields

The summary data for a range of AWR snapshots.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_snapshot_range_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  awr_source_database_identifier varchar2(32767),
  db_name varchar2(32767),
  instance_list dbms_cloud_oci_opsi_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_identifier number,
  latest_snapshot_identifier number,
  snapshot_count number,
  snapshot_interval_in_min number,
  db_version varchar2(32767),
  snapshot_timezone varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_snapshot_range_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_snapshot_range_summary_t (
    awr_source_database_identifier varchar2,
    db_name varchar2,
    instance_list dbms_cloud_oci_opsi_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_identifier number,
    latest_snapshot_identifier number,
    snapshot_count number,
    snapshot_interval_in_min number,
    db_version varchar2,
    snapshot_timezone varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_opsi_awr_database_snapshot_range_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_snapshot_range_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_awr_database_snapshot_range_summary_t) NOT PERSISTABLE;

The AWR snapshot range list.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_snapshot_range_collection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_awr_query_result_t (
  items dbms_cloud_oci_opsi_awr_database_snapshot_range_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_snapshot_range_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_snapshot_range_collection_t (
    name varchar2,
    version varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2,
    items dbms_cloud_oci_opsi_awr_database_snapshot_range_summary_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_awr_database_snapshot_range_collection_t is a subtype of the dbms_cloud_oci_opsi_awr_query_result_t type.

Fields

The result of the AWR SQL report.

Syntax

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

dbms_cloud_oci_opsi_awr_database_sql_report_t is a subtype of the dbms_cloud_oci_opsi_awr_query_result_t type.

Fields

The summary of the AWR SYSSTAT data.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_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_opsi_awr_database_sysstat_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_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_opsi_awr_database_sysstat_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_sysstat_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_awr_database_sysstat_summary_t) NOT PERSISTABLE;

The AWR SYSSTAT time series summary data.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_sysstat_collection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_awr_query_result_t (
  items dbms_cloud_oci_opsi_awr_database_sysstat_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_sysstat_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_sysstat_collection_t (
    name varchar2,
    version varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2,
    items dbms_cloud_oci_opsi_awr_database_sysstat_summary_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_awr_database_sysstat_collection_t is a subtype of the dbms_cloud_oci_opsi_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_opsi_awr_database_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_opsi_awr_database_top_wait_event_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_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_opsi_awr_database_top_wait_event_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_top_wait_event_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_awr_database_top_wait_event_summary_t) NOT PERSISTABLE;

The AWR top wait event data.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_top_wait_event_collection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_awr_query_result_t (
  items dbms_cloud_oci_opsi_awr_database_top_wait_event_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_top_wait_event_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_top_wait_event_collection_t (
    name varchar2,
    version varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2,
    items dbms_cloud_oci_opsi_awr_database_top_wait_event_summary_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_awr_database_top_wait_event_collection_t is a subtype of the dbms_cloud_oci_opsi_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_opsi_awr_database_wait_event_bucket_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  category varchar2(32767),
  percentage number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_wait_event_bucket_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_wait_event_bucket_summary_t (
    category varchar2,
    percentage number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_opsi_awr_database_wait_event_bucket_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_wait_event_bucket_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_awr_database_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_opsi_awr_database_wait_event_bucket_collection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_awr_query_result_t (
  total_waits number,
  items dbms_cloud_oci_opsi_awr_database_wait_event_bucket_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_wait_event_bucket_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_wait_event_bucket_collection_t (
    name varchar2,
    version varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2,
    total_waits number,
    items dbms_cloud_oci_opsi_awr_database_wait_event_bucket_summary_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_awr_database_wait_event_bucket_collection_t is a subtype of the dbms_cloud_oci_opsi_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_opsi_awr_database_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,
  snapshot_identifier number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_wait_event_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_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,
    snapshot_identifier number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_opsi_awr_database_wait_event_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_wait_event_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_awr_database_wait_event_summary_t) NOT PERSISTABLE;

The AWR wait event data.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_database_wait_event_collection_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_awr_query_result_t (
  items dbms_cloud_oci_opsi_awr_database_wait_event_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_wait_event_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_database_wait_event_collection_t (
    name varchar2,
    version varchar2,
    db_query_time_in_secs number,
    awr_result_type varchar2,
    items dbms_cloud_oci_opsi_awr_database_wait_event_summary_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_awr_database_wait_event_collection_t is a subtype of the dbms_cloud_oci_opsi_awr_query_result_t type.

Fields

Awr Hub resource.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_hub_t FORCE AUTHID CURRENT_USER IS OBJECT (
  operations_insights_warehouse_id varchar2(32767),
  id varchar2(32767),
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  object_storage_bucket_name varchar2(32767),
  awr_mailbox_url varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  hub_dst_timezone_version varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_hub_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_hub_t (
    operations_insights_warehouse_id varchar2,
    id varchar2,
    compartment_id varchar2,
    display_name varchar2,
    object_storage_bucket_name varchar2,
    awr_mailbox_url varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    hub_dst_timezone_version varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Logical grouping used for Awr Hub Object operations.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_hub_objects_t FORCE AUTHID CURRENT_USER IS OBJECT (
  awr_snapshots json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_hub_objects_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_hub_objects_t (
    awr_snapshots json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Awr hub source object

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_hub_source_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  awr_hub_id varchar2(32767),
  compartment_id varchar2(32767),
  l_type varchar2(32767),
  id varchar2(32767),
  awr_hub_opsi_source_id varchar2(32767),
  source_mail_box_url varchar2(32767),
  associated_resource_id varchar2(32767),
  associated_opsi_id varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  is_registered_with_awr_hub number,
  awr_source_database_id varchar2(32767),
  min_snapshot_identifier number,
  max_snapshot_identifier number,
  time_first_snapshot_generated timestamp with time zone,
  time_last_snapshot_generated timestamp with time zone,
  hours_since_last_import number,
  lifecycle_state varchar2(32767),
  status varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_hub_source_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_hub_source_t (
    name varchar2,
    awr_hub_id varchar2,
    compartment_id varchar2,
    l_type varchar2,
    id varchar2,
    awr_hub_opsi_source_id varchar2,
    source_mail_box_url varchar2,
    associated_resource_id varchar2,
    associated_opsi_id varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    is_registered_with_awr_hub number,
    awr_source_database_id varchar2,
    min_snapshot_identifier number,
    max_snapshot_identifier number,
    time_first_snapshot_generated timestamp with time zone,
    time_last_snapshot_generated timestamp with time zone,
    hours_since_last_import number,
    lifecycle_state varchar2,
    status varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Awr hub source object

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_hub_source_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  awr_hub_id varchar2(32767),
  compartment_id varchar2(32767),
  l_type varchar2(32767),
  id varchar2(32767),
  awr_hub_opsi_source_id varchar2(32767),
  source_mail_box_url varchar2(32767),
  associated_resource_id varchar2(32767),
  associated_opsi_id varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  is_registered_with_awr_hub number,
  awr_source_database_id varchar2(32767),
  min_snapshot_identifier number,
  max_snapshot_identifier number,
  time_first_snapshot_generated timestamp with time zone,
  time_last_snapshot_generated timestamp with time zone,
  hours_since_last_import number,
  lifecycle_state varchar2(32767),
  status varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_hub_source_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_hub_source_summary_t (
    name varchar2,
    awr_hub_id varchar2,
    compartment_id varchar2,
    l_type varchar2,
    id varchar2,
    awr_hub_opsi_source_id varchar2,
    source_mail_box_url varchar2,
    associated_resource_id varchar2,
    associated_opsi_id varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    is_registered_with_awr_hub number,
    awr_source_database_id varchar2,
    min_snapshot_identifier number,
    max_snapshot_identifier number,
    time_first_snapshot_generated timestamp with time zone,
    time_last_snapshot_generated timestamp with time zone,
    hours_since_last_import number,
    lifecycle_state varchar2,
    status varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_opsi_awr_hub_source_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_hub_source_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_awr_hub_source_summary_t) NOT PERSISTABLE;

Collection of Awr Hub sources.

Syntax

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

Fields

Logical grouping used for Awr Hub Source operations.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_hub_sources_t FORCE AUTHID CURRENT_USER IS OBJECT (
  awr_hub_sources json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_hub_sources_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_hub_sources_t (
    awr_hub_sources json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary Hub resource.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_hub_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  operations_insights_warehouse_id varchar2(32767),
  id varchar2(32767),
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  object_storage_bucket_name varchar2(32767),
  awr_mailbox_url varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_hub_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_hub_summary_t (
    operations_insights_warehouse_id varchar2,
    id varchar2,
    compartment_id varchar2,
    display_name varchar2,
    object_storage_bucket_name varchar2,
    awr_mailbox_url varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_opsi_awr_hub_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_hub_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_awr_hub_summary_t) NOT PERSISTABLE;

Collection of Hub resources.

Syntax

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

Fields

Logical grouping used for Awr Hub operations.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_hubs_t FORCE AUTHID CURRENT_USER IS OBJECT (
  awr_hubs json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_hubs_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_hubs_t (
    awr_hubs json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The result of the AWR report.

Syntax

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

Fields

The AWR snapshot summary of one snapshot.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_snapshot_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  awr_source_database_id varchar2(32767),
  instance_number number,
  time_db_startup timestamp with time zone,
  time_snapshot_begin timestamp with time zone,
  time_snapshot_end timestamp with time zone,
  snapshot_identifier number,
  error_count number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_snapshot_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_snapshot_summary_t (
    awr_source_database_id varchar2,
    instance_number number,
    time_db_startup timestamp with time zone,
    time_snapshot_begin timestamp with time zone,
    time_snapshot_end timestamp with time zone,
    snapshot_identifier number,
    error_count number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_opsi_awr_snapshot_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_snapshot_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_awr_snapshot_summary_t) NOT PERSISTABLE;

The list of AWR snapshots for one database.

Syntax

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

Fields

Summary of an AwrSource.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_awr_source_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  awr_hub_id varchar2(32767),
  name varchar2(32767),
  awr_source_database_id varchar2(32767),
  snapshots_uploaded number,
  min_snapshot_identifier number,
  max_snapshot_identifier number,
  time_first_snapshot_generated timestamp with time zone,
  time_last_snapshot_generated timestamp with time zone,
  hours_since_last_import number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_source_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_awr_source_summary_t (
    awr_hub_id varchar2,
    name varchar2,
    awr_source_database_id varchar2,
    snapshots_uploaded number,
    min_snapshot_identifier number,
    max_snapshot_identifier number,
    time_first_snapshot_generated timestamp with time zone,
    time_last_snapshot_generated timestamp with time zone,
    hours_since_last_import number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Unit details of configuration item.

Syntax

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

Fields

Allowed value details of configuration item, to validate what value can be assigned to a configuration item.

Syntax

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

Fields

Configuration item metadata.

Syntax

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

Fields

Basic configuration item metadata.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_basic_configuration_item_metadata_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_configuration_item_metadata_t (
  display_name varchar2(32767),
  description varchar2(32767),
  data_type varchar2(32767),
  unit_details dbms_cloud_oci_opsi_configuration_item_unit_details_t,
  value_input_details dbms_cloud_oci_opsi_configuration_item_allowed_value_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_basic_configuration_item_metadata_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_basic_configuration_item_metadata_t (
    config_item_type varchar2,
    display_name varchar2,
    description varchar2,
    data_type varchar2,
    unit_details dbms_cloud_oci_opsi_configuration_item_unit_details_t,
    value_input_details dbms_cloud_oci_opsi_configuration_item_allowed_value_details_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_basic_configuration_item_metadata_t is a subtype of the dbms_cloud_oci_opsi_configuration_item_metadata_t type.

Fields

Configuration item summary.

Syntax

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

Fields

Basic configuration item summary. Value field contain the most preferred value for the specified scope (compartmentId), which could be from any of the ConfigurationItemValueSourceConfigurationType. Default value field contains the default value from Operations Insights.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_basic_configuration_item_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_configuration_item_summary_t (
  name varchar2(32767),
  value varchar2(32767),
  value_source_config varchar2(32767),
  default_value varchar2(32767),
  applicable_contexts dbms_cloud_oci_opsi_varchar2_tbl,
  metadata dbms_cloud_oci_opsi_configuration_item_metadata_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_basic_configuration_item_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_basic_configuration_item_summary_t (
    config_item_type varchar2,
    name varchar2,
    value varchar2,
    value_source_config varchar2,
    default_value varchar2,
    applicable_contexts dbms_cloud_oci_opsi_varchar2_tbl,
    metadata dbms_cloud_oci_opsi_configuration_item_metadata_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_basic_configuration_item_summary_t is a subtype of the dbms_cloud_oci_opsi_configuration_item_summary_t type.

Fields

Advanced feature details of autonomous database insight.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_change_autonomous_database_insight_advanced_features_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  connection_details dbms_cloud_oci_opsi_connection_details_t,
  credential_details dbms_cloud_oci_opsi_credential_details_t,
  opsi_private_endpoint_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_change_autonomous_database_insight_advanced_features_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_change_autonomous_database_insight_advanced_features_details_t (
    connection_details dbms_cloud_oci_opsi_connection_details_t,
    credential_details dbms_cloud_oci_opsi_credential_details_t,
    opsi_private_endpoint_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The information to be updated.

Syntax

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

Fields

The information to be updated.

Syntax

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

Fields

The information to be updated.

Syntax

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

Fields

The information to be updated.

Syntax

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

Fields

The information to be updated.

Syntax

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

Fields

The information to be updated.

Syntax

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

Fields

The details used to change the compartment of a Operation Insights private endpoint.

Syntax

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

Fields

The information to be updated.

Syntax

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

Fields

The information used to change the compartment of an OPSI configuration resource.

Syntax

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

Fields

Details of a Private Endpoint co-managed database insight.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_change_pe_comanaged_database_insight_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  service_name varchar2(32767),
  credential_details dbms_cloud_oci_opsi_credential_details_t,
  connection_details dbms_cloud_oci_opsi_pe_comanaged_database_connection_details_t,
  opsi_private_endpoint_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_change_pe_comanaged_database_insight_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_change_pe_comanaged_database_insight_details_t (
    service_name varchar2,
    credential_details dbms_cloud_oci_opsi_credential_details_t,
    connection_details dbms_cloud_oci_opsi_pe_comanaged_database_connection_details_t,
    opsi_private_endpoint_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A compute entity that can be imported into Operations Insights.

Syntax

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

Fields

A compute host entity that can be imported into Operations Insights.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_cloud_importable_compute_entity_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_importable_compute_entity_summary_t (
  host_name varchar2(32767),
  platform_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_cloud_importable_compute_entity_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_cloud_importable_compute_entity_summary_t (
    entity_source varchar2,
    compute_id varchar2,
    compute_display_name varchar2,
    compartment_id varchar2,
    host_name varchar2,
    platform_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_cloud_importable_compute_entity_summary_t is a subtype of the dbms_cloud_oci_opsi_importable_compute_entity_summary_t type.

Fields

Allowed value details of configuration item for FREE_TEXT type.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_configuration_item_free_text_allowed_value_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_configuration_item_allowed_value_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_configuration_item_free_text_allowed_value_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_configuration_item_free_text_allowed_value_details_t (
    allowed_value_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_configuration_item_free_text_allowed_value_details_t is a subtype of the dbms_cloud_oci_opsi_configuration_item_allowed_value_details_t type.

Allowed value details of configuration item for LIMIT type. Value has to be between minValue and maxValue.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_configuration_item_limit_allowed_value_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_configuration_item_allowed_value_details_t (
  min_value varchar2(32767),
  max_value varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_configuration_item_limit_allowed_value_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_configuration_item_limit_allowed_value_details_t (
    allowed_value_type varchar2,
    min_value varchar2,
    max_value varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_configuration_item_limit_allowed_value_details_t is a subtype of the dbms_cloud_oci_opsi_configuration_item_allowed_value_details_t type.

Fields

Allowed value details of configuration item for PICK type. Value has to be from one of the possibleValues.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_configuration_item_pick_allowed_value_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_configuration_item_allowed_value_details_t (
  possible_values dbms_cloud_oci_opsi_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_configuration_item_pick_allowed_value_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_configuration_item_pick_allowed_value_details_t (
    allowed_value_type varchar2,
    possible_values dbms_cloud_oci_opsi_varchar2_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_configuration_item_pick_allowed_value_details_t is a subtype of the dbms_cloud_oci_opsi_configuration_item_allowed_value_details_t type.

Fields

Nested table type of dbms_cloud_oci_opsi_configuration_item_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_configuration_item_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_configuration_item_summary_t) NOT PERSISTABLE;

Collection of configuration item summary objects.

Syntax

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

Fields

The information about Hub to be analyzed. Input compartmentId MUST be the root compartment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_create_awr_hub_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  operations_insights_warehouse_id varchar2(32767),
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  object_storage_bucket_name varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_awr_hub_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_awr_hub_details_t (
    operations_insights_warehouse_id varchar2,
    compartment_id varchar2,
    display_name varchar2,
    object_storage_bucket_name varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

payload to register Awr Hub source

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_create_awr_hub_source_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  awr_hub_id varchar2(32767),
  compartment_id varchar2(32767),
  associated_resource_id varchar2(32767),
  associated_opsi_id varchar2(32767),
  l_type varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_awr_hub_source_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_awr_hub_source_details_t (
    name varchar2,
    awr_hub_id varchar2,
    compartment_id varchar2,
    associated_resource_id varchar2,
    associated_opsi_id varchar2,
    l_type varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Configuration item details for OPSI configuration creation.

Syntax

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

Fields

Basic configuration item details for OPSI configuration creation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_create_basic_configuration_item_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_create_configuration_item_details_t (
  name varchar2(32767),
  value varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_basic_configuration_item_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_basic_configuration_item_details_t (
    config_item_type varchar2,
    name varchar2,
    value varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_create_basic_configuration_item_details_t is a subtype of the dbms_cloud_oci_opsi_create_configuration_item_details_t type.

Fields

The information about database to be analyzed.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_create_em_managed_external_database_insight_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_create_database_insight_details_t (
  enterprise_manager_identifier varchar2(32767),
  enterprise_manager_bridge_id varchar2(32767),
  enterprise_manager_entity_identifier varchar2(32767),
  exadata_insight_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_em_managed_external_database_insight_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_em_managed_external_database_insight_details_t (
    entity_source varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    enterprise_manager_identifier varchar2,
    enterprise_manager_bridge_id varchar2,
    enterprise_manager_entity_identifier varchar2,
    exadata_insight_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_create_em_managed_external_database_insight_details_t is a subtype of the dbms_cloud_oci_opsi_create_database_insight_details_t type.

Fields

The information about the Exadata system to be analyzed.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_create_exadata_insight_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  entity_source varchar2(32767),
  compartment_id varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_exadata_insight_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_exadata_insight_details_t (
    entity_source varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

The information about the Exadata system to be analyzed. If memberEntityDetails is not specified, the the Enterprise Manager entity (e.g. databases and hosts) associated with an Exadata system will be placed in the same compartment as the Exadata system.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_create_em_managed_external_exadata_insight_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_create_exadata_insight_details_t (
  enterprise_manager_identifier varchar2(32767),
  enterprise_manager_bridge_id varchar2(32767),
  enterprise_manager_entity_identifier varchar2(32767),
  member_entity_details dbms_cloud_oci_opsi_create_em_managed_external_exadata_member_entity_details_tbl,
  is_auto_sync_enabled number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_em_managed_external_exadata_insight_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_em_managed_external_exadata_insight_details_t (
    entity_source varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    enterprise_manager_identifier varchar2,
    enterprise_manager_bridge_id varchar2,
    enterprise_manager_entity_identifier varchar2,
    member_entity_details dbms_cloud_oci_opsi_create_em_managed_external_exadata_member_entity_details_tbl,
    is_auto_sync_enabled number
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_create_em_managed_external_exadata_insight_details_t is a subtype of the dbms_cloud_oci_opsi_create_exadata_insight_details_t type.

Fields

The information about the host to be analyzed.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_create_host_insight_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  entity_source varchar2(32767),
  compartment_id varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_host_insight_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_host_insight_details_t (
    entity_source varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

The information about the EM-managed external host to be analyzed.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_create_em_managed_external_host_insight_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_create_host_insight_details_t (
  enterprise_manager_identifier varchar2(32767),
  enterprise_manager_bridge_id varchar2(32767),
  enterprise_manager_entity_identifier varchar2(32767),
  exadata_insight_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_em_managed_external_host_insight_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_em_managed_external_host_insight_details_t (
    entity_source varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    enterprise_manager_identifier varchar2,
    enterprise_manager_bridge_id varchar2,
    enterprise_manager_entity_identifier varchar2,
    exadata_insight_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_create_em_managed_external_host_insight_details_t is a subtype of the dbms_cloud_oci_opsi_create_host_insight_details_t type.

Fields

The information about a Enterprise Manager bridge resource to be created

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_create_enterprise_manager_bridge_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  object_storage_bucket_name varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_enterprise_manager_bridge_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_enterprise_manager_bridge_details_t (
    compartment_id varchar2,
    display_name varchar2,
    description varchar2,
    object_storage_bucket_name varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The information about the Compute Instance host to be analyzed.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_create_macs_managed_cloud_host_insight_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_create_host_insight_details_t (
  compute_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_macs_managed_cloud_host_insight_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_macs_managed_cloud_host_insight_details_t (
    entity_source varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    compute_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_create_macs_managed_cloud_host_insight_details_t is a subtype of the dbms_cloud_oci_opsi_create_host_insight_details_t type.

Fields

The information about the MACS-managed external host to be analyzed.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_create_macs_managed_external_host_insight_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_create_host_insight_details_t (
  management_agent_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_macs_managed_external_host_insight_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_macs_managed_external_host_insight_details_t (
    entity_source varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    management_agent_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_create_macs_managed_external_host_insight_details_t is a subtype of the dbms_cloud_oci_opsi_create_host_insight_details_t type.

Fields

Content types that the news report can handle.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_news_content_types_t FORCE AUTHID CURRENT_USER IS OBJECT (
  capacity_planning_resources dbms_cloud_oci_opsi_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_news_content_types_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_news_content_types_t (
    capacity_planning_resources dbms_cloud_oci_opsi_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The information about the news report to be created.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_create_news_report_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  news_frequency varchar2(32767),
  description varchar2(32767),
  ons_topic_id varchar2(32767),
  compartment_id varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  content_types dbms_cloud_oci_opsi_news_content_types_t,
  locale varchar2(32767),
  status varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_news_report_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_news_report_details_t (
    name varchar2,
    news_frequency varchar2,
    description varchar2,
    ons_topic_id varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    content_types dbms_cloud_oci_opsi_news_content_types_t,
    locale varchar2,
    status varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details used to create a new Operation Insights private endpoint.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_create_operations_insights_private_endpoint_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  vcn_id varchar2(32767),
  subnet_id varchar2(32767),
  is_used_for_rac_dbs number,
  description varchar2(32767),
  nsg_ids dbms_cloud_oci_opsi_varchar2_tbl,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_operations_insights_private_endpoint_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_operations_insights_private_endpoint_details_t (
    display_name varchar2,
    compartment_id varchar2,
    vcn_id varchar2,
    subnet_id varchar2,
    is_used_for_rac_dbs number,
    description varchar2,
    nsg_ids dbms_cloud_oci_opsi_varchar2_tbl,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The information about a Operations Insights Warehouse resource to be created. Input compartmentId MUST be the root compartment.

Syntax

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

Fields

The information about a Operations Insights Warehouse User to be created. Input compartmentId MUST be the root compartment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_create_operations_insights_warehouse_user_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  operations_insights_warehouse_id varchar2(32767),
  compartment_id varchar2(32767),
  name varchar2(32767),
  connection_password varchar2(32767),
  is_awr_data_access number,
  is_em_data_access number,
  is_opsi_data_access number,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_operations_insights_warehouse_user_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_operations_insights_warehouse_user_details_t (
    operations_insights_warehouse_id varchar2,
    compartment_id varchar2,
    name varchar2,
    connection_password varchar2,
    is_awr_data_access number,
    is_em_data_access number,
    is_opsi_data_access number,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_opsi_create_configuration_item_details_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_create_configuration_item_details_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_create_configuration_item_details_t) NOT PERSISTABLE;

Information about OPSI configuration to be created.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_create_opsi_configuration_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  opsi_config_type varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  config_items dbms_cloud_oci_opsi_create_configuration_item_details_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_opsi_configuration_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_opsi_configuration_details_t (
    compartment_id varchar2,
    opsi_config_type varchar2,
    display_name varchar2,
    description varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    config_items dbms_cloud_oci_opsi_create_configuration_item_details_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Information about OPSI UX configuration to be created.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_create_opsi_ux_configuration_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_create_opsi_configuration_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_opsi_ux_configuration_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_opsi_ux_configuration_details_t (
    compartment_id varchar2,
    opsi_config_type varchar2,
    display_name varchar2,
    description varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    config_items dbms_cloud_oci_opsi_create_configuration_item_details_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_create_opsi_ux_configuration_details_t is a subtype of the dbms_cloud_oci_opsi_create_opsi_configuration_details_t type.

The information about the Exadata system to be analyzed.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_create_pe_comanaged_exadata_insight_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_create_exadata_insight_details_t (
  exadata_infra_id varchar2(32767),
  member_vm_cluster_details dbms_cloud_oci_opsi_create_pe_comanaged_exadata_vmcluster_details_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_pe_comanaged_exadata_insight_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_create_pe_comanaged_exadata_insight_details_t (
    entity_source varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    exadata_infra_id varchar2,
    member_vm_cluster_details dbms_cloud_oci_opsi_create_pe_comanaged_exadata_vmcluster_details_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_create_pe_comanaged_exadata_insight_details_t is a subtype of the dbms_cloud_oci_opsi_create_exadata_insight_details_t type.

Fields

Vault Credential Details to connect to the database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_credential_by_vault_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_credential_details_t (
  user_name varchar2(32767),
  password_secret_id varchar2(32767),
  wallet_secret_id varchar2(32767),
  role varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_credential_by_vault_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_credential_by_vault_t (
    credential_source_name varchar2,
    credential_type varchar2,
    user_name varchar2,
    password_secret_id varchar2,
    wallet_secret_id varchar2,
    role varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_credential_by_vault_t is a subtype of the dbms_cloud_oci_opsi_credential_details_t type.

Fields

Credential Source to connect to the database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_credentials_by_source_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_credential_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_credentials_by_source_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_credentials_by_source_t (
    credential_source_name varchar2,
    credential_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_credentials_by_source_t is a subtype of the dbms_cloud_oci_opsi_credential_details_t type.

Supported configuration metric groups for database capacity planning service.

Syntax

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

Fields

Configuration parameters defined for external databases instance level.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_db_external_instance_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_database_configuration_metric_group_t (
  instance_name varchar2(32767),
  host_name varchar2(32767),
  cpu_count number,
  host_memory_capacity number,
  version varchar2(32767),
  parallel varchar2(32767),
  instance_role varchar2(32767),
  logins varchar2(32767),
  database_status varchar2(32767),
  status varchar2(32767),
  edition varchar2(32767),
  startup_time timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_db_external_instance_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_db_external_instance_t (
    metric_name varchar2,
    time_collected timestamp with time zone,
    instance_name varchar2,
    host_name varchar2,
    cpu_count number,
    host_memory_capacity number,
    version varchar2,
    parallel varchar2,
    instance_role varchar2,
    logins varchar2,
    database_status varchar2,
    status varchar2,
    edition varchar2,
    startup_time timestamp with time zone
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_db_external_instance_t is a subtype of the dbms_cloud_oci_opsi_database_configuration_metric_group_t type.

Fields

Configuration parameters defined for external databases.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_db_external_properties_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_database_configuration_metric_group_t (
  name varchar2(32767),
  log_mode varchar2(32767),
  cdb varchar2(32767),
  open_mode varchar2(32767),
  database_role varchar2(32767),
  guard_status varchar2(32767),
  platform_name varchar2(32767),
  control_file_type varchar2(32767),
  switchover_status varchar2(32767),
  created timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_db_external_properties_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_db_external_properties_t (
    metric_name varchar2,
    time_collected timestamp with time zone,
    name varchar2,
    log_mode varchar2,
    cdb varchar2,
    open_mode varchar2,
    database_role varchar2,
    guard_status varchar2,
    platform_name varchar2,
    control_file_type varchar2,
    switchover_status varchar2,
    created timestamp with time zone
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_db_external_properties_t is a subtype of the dbms_cloud_oci_opsi_database_configuration_metric_group_t type.

Fields

Configuration parameters defined for external databases instance level.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_dbos_config_instance_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_database_configuration_metric_group_t (
  instance_name varchar2(32767),
  host_name varchar2(32767),
  num_cp_us number,
  num_cpu_cores number,
  num_cpu_sockets number,
  physical_memory_bytes number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_dbos_config_instance_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_dbos_config_instance_t (
    metric_name varchar2,
    time_collected timestamp with time zone,
    instance_name varchar2,
    host_name varchar2,
    num_cp_us number,
    num_cpu_cores number,
    num_cpu_sockets number,
    physical_memory_bytes number
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_dbos_config_instance_t is a subtype of the dbms_cloud_oci_opsi_database_configuration_metric_group_t type.

Fields

Initialization parameters for a database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_db_parameters_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_database_configuration_metric_group_t (
  instance_number number,
  parameter_name varchar2(32767),
  parameter_value varchar2(32767),
  snapshot_id number,
  is_changed varchar2(32767),
  is_default varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_db_parameters_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_db_parameters_t (
    metric_name varchar2,
    time_collected timestamp with time zone,
    instance_number number,
    parameter_name varchar2,
    parameter_value varchar2,
    snapshot_id number,
    is_changed varchar2,
    is_default varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_db_parameters_t is a subtype of the dbms_cloud_oci_opsi_database_configuration_metric_group_t type.

Fields

Details for a bind parameter used in data object query.

Syntax

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

Fields

Unit details of a data object column.

Syntax

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

Fields

Metadata of a column in a data object resultset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_data_object_column_metadata_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  category varchar2(32767),
  data_type varchar2(32767),
  data_type_name varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  group_name varchar2(32767),
  unit_details dbms_cloud_oci_opsi_data_object_column_unit_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_column_metadata_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_column_metadata_t (
    name varchar2,
    category varchar2,
    data_type varchar2,
    data_type_name varchar2,
    display_name varchar2,
    description varchar2,
    group_name varchar2,
    unit_details dbms_cloud_oci_opsi_data_object_column_unit_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Unit details of a data object column of CORE unit category.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_data_object_core_column_unit_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_data_object_column_unit_t (
  unit varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_core_column_unit_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_core_column_unit_t (
    unit_category varchar2,
    display_name varchar2,
    unit varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_data_object_core_column_unit_t is a subtype of the dbms_cloud_oci_opsi_data_object_column_unit_t type.

Fields

Unit details of a data object column of CUSTOM unit category.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_data_object_custom_column_unit_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_data_object_column_unit_t (
  unit varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_custom_column_unit_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_custom_column_unit_t (
    unit_category varchar2,
    display_name varchar2,
    unit varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_data_object_custom_column_unit_t is a subtype of the dbms_cloud_oci_opsi_data_object_column_unit_t type.

Fields

Unit details of a data object column of DATA_SIZE unit category.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_data_object_data_size_column_unit_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_data_object_column_unit_t (
  unit varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_data_size_column_unit_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_data_size_column_unit_t (
    unit_category varchar2,
    display_name varchar2,
    unit varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_data_object_data_size_column_unit_t is a subtype of the dbms_cloud_oci_opsi_data_object_column_unit_t type.

Fields

Unit details of a data object column of FREQEUENCY unit category.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_data_object_frequency_column_unit_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_data_object_column_unit_t (
  unit varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_frequency_column_unit_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_frequency_column_unit_t (
    unit_category varchar2,
    display_name varchar2,
    unit varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_data_object_frequency_column_unit_t is a subtype of the dbms_cloud_oci_opsi_data_object_column_unit_t type.

Fields

Unit details of a data object column of OTHER_STANDARD unit category.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_data_object_other_standard_column_unit_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_data_object_column_unit_t (
  unit varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_other_standard_column_unit_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_other_standard_column_unit_t (
    unit_category varchar2,
    display_name varchar2,
    unit varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_data_object_other_standard_column_unit_t is a subtype of the dbms_cloud_oci_opsi_data_object_column_unit_t type.

Fields

Unit details of a data object column of POWER unit category.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_data_object_power_column_unit_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_data_object_column_unit_t (
  unit varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_power_column_unit_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_power_column_unit_t (
    unit_category varchar2,
    display_name varchar2,
    unit varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_data_object_power_column_unit_t is a subtype of the dbms_cloud_oci_opsi_data_object_column_unit_t type.

Fields

Nested table type of dbms_cloud_oci_opsi_data_object_bind_parameter_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_data_object_bind_parameter_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_data_object_bind_parameter_t) NOT PERSISTABLE;

Information required to form and execute query on a data object.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_data_object_query_t FORCE AUTHID CURRENT_USER IS OBJECT (
  query_type varchar2(32767),
  bind_params dbms_cloud_oci_opsi_data_object_bind_parameter_tbl,
  query_execution_timeout_in_seconds number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_query_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_query_t (
    query_type varchar2,
    bind_params dbms_cloud_oci_opsi_data_object_bind_parameter_tbl,
    query_execution_timeout_in_seconds number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Time filters to be applied in the data object query.

Syntax

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

Fields

Unit details of a data object column of RATE unit category.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_data_object_rate_column_unit_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_data_object_column_unit_t (
  numerator dbms_cloud_oci_opsi_data_object_column_unit_t,
  denominator dbms_cloud_oci_opsi_data_object_column_unit_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_rate_column_unit_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_rate_column_unit_t (
    unit_category varchar2,
    display_name varchar2,
    numerator dbms_cloud_oci_opsi_data_object_column_unit_t,
    denominator dbms_cloud_oci_opsi_data_object_column_unit_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_data_object_rate_column_unit_t is a subtype of the dbms_cloud_oci_opsi_data_object_column_unit_t type.

Fields

Information required to execute query on data objects. Query is given in standard SQL syntax providing flexibility to form complex queries such as queries with joins and nested queries.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_data_object_standard_query_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_data_object_query_t (
  statement varchar2(32767),
  time_filters dbms_cloud_oci_opsi_data_object_query_time_filters_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_standard_query_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_standard_query_t (
    query_type varchar2,
    bind_params dbms_cloud_oci_opsi_data_object_bind_parameter_tbl,
    query_execution_timeout_in_seconds number,
    statement varchar2,
    time_filters dbms_cloud_oci_opsi_data_object_query_time_filters_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_data_object_standard_query_t is a subtype of the dbms_cloud_oci_opsi_data_object_query_t type.

Fields

Unit details of a data object column of TEMPERATURE unit category.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_data_object_temperature_column_unit_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_data_object_column_unit_t (
  unit varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_temperature_column_unit_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_temperature_column_unit_t (
    unit_category varchar2,
    display_name varchar2,
    unit varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_data_object_temperature_column_unit_t is a subtype of the dbms_cloud_oci_opsi_data_object_column_unit_t type.

Fields

Information required in a structured template to form and execute query on a data object.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_data_object_templatized_query_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_data_object_query_t (
  select_list dbms_cloud_oci_opsi_varchar2_tbl,
  from_clause varchar2(32767),
  where_conditions_list dbms_cloud_oci_opsi_varchar2_tbl,
  group_by_list dbms_cloud_oci_opsi_varchar2_tbl,
  having_conditions_list dbms_cloud_oci_opsi_varchar2_tbl,
  order_by_list dbms_cloud_oci_opsi_varchar2_tbl,
  time_filters dbms_cloud_oci_opsi_data_object_query_time_filters_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_templatized_query_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_templatized_query_t (
    query_type varchar2,
    bind_params dbms_cloud_oci_opsi_data_object_bind_parameter_tbl,
    query_execution_timeout_in_seconds number,
    select_list dbms_cloud_oci_opsi_varchar2_tbl,
    from_clause varchar2,
    where_conditions_list dbms_cloud_oci_opsi_varchar2_tbl,
    group_by_list dbms_cloud_oci_opsi_varchar2_tbl,
    having_conditions_list dbms_cloud_oci_opsi_varchar2_tbl,
    order_by_list dbms_cloud_oci_opsi_varchar2_tbl,
    time_filters dbms_cloud_oci_opsi_data_object_query_time_filters_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_data_object_templatized_query_t is a subtype of the dbms_cloud_oci_opsi_data_object_query_t type.

Fields

Unit details of a data object column of TIME unit category.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_data_object_time_column_unit_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_data_object_column_unit_t (
  unit varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_time_column_unit_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_data_object_time_column_unit_t (
    unit_category varchar2,
    display_name varchar2,
    unit varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_data_object_time_column_unit_t is a subtype of the dbms_cloud_oci_opsi_data_object_column_unit_t type.

Fields

Nested table type of dbms_cloud_oci_opsi_database_configuration_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_database_configuration_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_database_configuration_summary_t) NOT PERSISTABLE;

Collection of database insight configuration summary objects.

Syntax

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

Fields

Logical grouping used for Operations Insights database-targeted operations.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_database_insights_t FORCE AUTHID CURRENT_USER IS OBJECT (
  database_insights json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_database_insights_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_database_insights_t (
    database_insights json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_opsi_database_insight_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_database_insight_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_database_insight_summary_t) NOT PERSISTABLE;

Collection of database insight summary objects.

Syntax

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

Fields

Details of query parameter supported by an OPSI data object.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_opsi_data_object_column_metadata_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_data_object_column_metadata_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_data_object_column_metadata_t) NOT PERSISTABLE;

Nested table type of dbms_cloud_oci_opsi_opsi_data_object_supported_query_param_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_opsi_data_object_supported_query_param_tbl FORCE IS TABLE OF (dbms_cloud_oci_opsi_opsi_data_object_supported_query_param_t) NOT PERSISTABLE;

OPSI data object.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_opsi_data_object_t FORCE AUTHID CURRENT_USER IS OBJECT (
  identifier varchar2(32767),
  data_object_type varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  name varchar2(32767),
  group_names dbms_cloud_oci_opsi_varchar2_tbl,
  supported_query_time_period varchar2(32767),
  columns_metadata dbms_cloud_oci_opsi_data_object_column_metadata_tbl,
  supported_query_params dbms_cloud_oci_opsi_opsi_data_object_supported_query_param_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_opsi_data_object_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_opsi_data_object_t (
    identifier varchar2,
    data_object_type varchar2,
    display_name varchar2,
    description varchar2,
    name varchar2,
    group_names dbms_cloud_oci_opsi_varchar2_tbl,
    supported_query_time_period varchar2,
    columns_metadata dbms_cloud_oci_opsi_data_object_column_metadata_tbl,
    supported_query_params dbms_cloud_oci_opsi_opsi_data_object_supported_query_param_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Database insights data object.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_database_insights_data_object_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_opsi_data_object_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_database_insights_data_object_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_database_insights_data_object_t (
    identifier varchar2,
    data_object_type varchar2,
    display_name varchar2,
    description varchar2,
    name varchar2,
    group_names dbms_cloud_oci_opsi_varchar2_tbl,
    supported_query_time_period varchar2,
    columns_metadata dbms_cloud_oci_opsi_data_object_column_metadata_tbl,
    supported_query_params dbms_cloud_oci_opsi_opsi_data_object_supported_query_param_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_database_insights_data_object_t is a subtype of the dbms_cloud_oci_opsi_opsi_data_object_t type.

Summary of an OPSI data object.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_opsi_data_object_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  identifier varchar2(32767),
  data_object_type varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  name varchar2(32767),
  group_names dbms_cloud_oci_opsi_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_opsi_data_object_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_opsi_data_object_summary_t (
    identifier varchar2,
    data_object_type varchar2,
    display_name varchar2,
    description varchar2,
    name varchar2,
    group_names dbms_cloud_oci_opsi_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Summary of a database insights data object.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_database_insights_data_object_summary_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_opsi_data_object_summary_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_database_insights_data_object_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_database_insights_data_object_summary_t (
    identifier varchar2,
    data_object_type varchar2,
    display_name varchar2,
    description varchar2,
    name varchar2,
    group_names dbms_cloud_oci_opsi_varchar2_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_database_insights_data_object_summary_t is a subtype of the dbms_cloud_oci_opsi_opsi_data_object_summary_t type.

Database parameter details

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_database_parameter_type_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_opsi_related_object_type_details_t (
  name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_database_parameter_type_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_database_parameter_type_details_t (
    l_type varchar2,
    name varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_opsi_database_parameter_type_details_t is a subtype of the dbms_cloud_oci_opsi_related_object_type_details_t type.

Fields

Information about a diskgroup which includes diskgroup name and ASM name.

Syntax

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

Fields

Aggregated data per disk.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_opsi_disk_statistics_t FORCE AUTHID CURRENT_USER IS OBJECT (
  disk_name varchar2(32767),
  disk_unallocated_in_g_bs number,
  disk_usage_in_g_bs number,
  disk_size_in_g_bs number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_disk_statistics_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_opsi_disk_statistics_t (
    disk_name varchar2,
    disk_unallocated_in_g_bs number,
    disk_usage_in_g_bs number,
    disk_size_in_g_bs number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Download Wallet details.

Syntax

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

Fields

Partial information about the exadata which includes id, name and vmclusterNames.

Syntax

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

Fields