Nested table type of varchar2(32767).

Syntax

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

The properties of a new Java installation site.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_new_installation_site_t FORCE AUTHID CURRENT_USER IS OBJECT (
  managed_instance_id varchar2(32767),
  release_version varchar2(32767),
  artifact_content_type varchar2(32767),
  installation_path varchar2(32767),
  headless_mode number,
  force_install number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_new_installation_site_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_new_installation_site_t (
    managed_instance_id varchar2,
    release_version varchar2,
    artifact_content_type varchar2,
    installation_path varchar2,
    headless_mode number,
    force_install number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_new_installation_site_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_new_installation_site_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_new_installation_site_t) NOT PERSISTABLE;

The list of Java installation sites to add.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_add_fleet_installation_sites_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  installation_sites dbms_cloud_oci_jms_new_installation_site_tbl,
  post_installation_actions dbms_cloud_oci_jms_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_add_fleet_installation_sites_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_add_fleet_installation_sites_details_t (
    installation_sites dbms_cloud_oci_jms_new_installation_site_tbl,
    post_installation_actions dbms_cloud_oci_jms_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

AdvancedUsageTracking configuration

Syntax

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

Fields

Information about the plugin.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_jms_plugin_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_plugin_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_plugin_t) NOT PERSISTABLE;

Information about the agent.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_agent_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  l_type varchar2(32767),
  java_version varchar2(32767),
  java_security_status varchar2(32767),
  plugins dbms_cloud_oci_jms_plugin_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_agent_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_agent_t (
    display_name varchar2,
    l_type varchar2,
    java_version varchar2,
    java_security_status varchar2,
    plugins dbms_cloud_oci_jms_plugin_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

An summary of a announcement on Console Overview page

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_announcement_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key number,
  summary varchar2(32767),
  url varchar2(32767),
  time_released timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_announcement_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_announcement_summary_t (
    key number,
    summary varchar2,
    url varchar2,
    time_released timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_announcement_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_announcement_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_announcement_summary_t) NOT PERSISTABLE;

Results of list announcements call. Contains AnnouncementSummary items

Syntax

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

Fields

Operating System of the platform on which the Java Runtime was reported.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_operating_system_t FORCE AUTHID CURRENT_USER IS OBJECT (
  family varchar2(32767),
  name varchar2(32767),
  version varchar2(32767),
  architecture varchar2(32767),
  managed_instance_count number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_operating_system_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_operating_system_t (
    family varchar2,
    name varchar2,
    version varchar2,
    architecture varchar2,
    managed_instance_count number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_operating_system_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_operating_system_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_operating_system_t) NOT PERSISTABLE;

Summarizes application installation usage information during a specified time period. The main difference between ApplicationUsage and ApplicationInstallationUsageSummary is the presence of installation information. ApplicationUsage provides only aggregated information for an application regardless of the installation paths. Therefore, two different applications with the same application name installed in two different paths will be aggregated to a single application. This aggregation makes it difficult to focus actions to single application installed on a known path. An application installation is independent of the Java Runtime on which it's running or the Managed Instance where it's installed.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_application_installation_usage_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  application_installation_key varchar2(32767),
  application_key varchar2(32767),
  display_name varchar2(32767),
  application_type varchar2(32767),
  installation_path varchar2(32767),
  full_class_path dbms_cloud_oci_jms_varchar2_tbl,
  operating_systems dbms_cloud_oci_jms_operating_system_tbl,
  approximate_installation_count number,
  approximate_jre_count number,
  approximate_managed_instance_count number,
  time_start timestamp with time zone,
  time_end timestamp with time zone,
  time_first_seen timestamp with time zone,
  time_last_seen timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_application_installation_usage_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_application_installation_usage_summary_t (
    application_installation_key varchar2,
    application_key varchar2,
    display_name varchar2,
    application_type varchar2,
    installation_path varchar2,
    full_class_path dbms_cloud_oci_jms_varchar2_tbl,
    operating_systems dbms_cloud_oci_jms_operating_system_tbl,
    approximate_installation_count number,
    approximate_jre_count number,
    approximate_managed_instance_count number,
    time_start timestamp with time zone,
    time_end timestamp with time zone,
    time_first_seen timestamp with time zone,
    time_last_seen timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_application_installation_usage_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_application_installation_usage_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_application_installation_usage_summary_t) NOT PERSISTABLE;

Results of an application installation search. Contains ApplicationInstallationUsageSummary items.

Syntax

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

Fields

Application usage during a specified time period. An application is a Java application that can be executed by a Java Runtime installation. An application is independent of the Java Runtime or its installation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_application_usage_t FORCE AUTHID CURRENT_USER IS OBJECT (
  application_id varchar2(32767),
  display_name varchar2(32767),
  application_type varchar2(32767),
  operating_systems dbms_cloud_oci_jms_operating_system_tbl,
  approximate_installation_count number,
  approximate_jre_count number,
  approximate_managed_instance_count number,
  time_start timestamp with time zone,
  time_end timestamp with time zone,
  time_first_seen timestamp with time zone,
  time_last_seen timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_application_usage_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_application_usage_t (
    application_id varchar2,
    display_name varchar2,
    application_type varchar2,
    operating_systems dbms_cloud_oci_jms_operating_system_tbl,
    approximate_installation_count number,
    approximate_jre_count number,
    approximate_managed_instance_count number,
    time_start timestamp with time zone,
    time_end timestamp with time zone,
    time_first_seen timestamp with time zone,
    time_last_seen timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_application_usage_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_application_usage_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_application_usage_t) NOT PERSISTABLE;

Results of an application search. Contains ApplicationUsage items.

Syntax

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

Fields

The minimum details of a work item.

Syntax

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

Fields

The work item details with JFR related information.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_application_work_item_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_jms_work_item_details_t (
  application_key varchar2(32767),
  application_installation_key varchar2(32767),
  application_name varchar2(32767),
  application_installation_path varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_application_work_item_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_application_work_item_details_t (
    kind varchar2,
    work_item_type varchar2,
    application_key varchar2,
    application_installation_key varchar2,
    application_name varchar2,
    application_installation_path varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_jms_application_work_item_details_t is a subtype of the dbms_cloud_oci_jms_work_item_details_t type.

Fields

The common work item details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_basic_work_item_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_jms_work_item_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_basic_work_item_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_basic_work_item_details_t (
    kind varchar2,
    work_item_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_jms_basic_work_item_details_t is a subtype of the dbms_cloud_oci_jms_work_item_details_t type.

A resource to blocklist for certain operation.

Syntax

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

Fields

The blocklist record to prevent a target resource from certain operation with reason.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_blocklist_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  target dbms_cloud_oci_jms_blocklist_target_t,
  operation varchar2(32767),
  reason varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_blocklist_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_blocklist_t (
    key varchar2,
    target dbms_cloud_oci_jms_blocklist_target_t,
    operation varchar2,
    reason varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_blocklist_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_blocklist_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_blocklist_t) NOT PERSISTABLE;

Results of a blocklist search that contain Blocklist records.

Syntax

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

Fields

An entry for blocklist to describe blocked operation and reason.

Syntax

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

Fields

Attributes to change the compartment of a Fleet.

Syntax

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

Fields

The blocklist record details.

Syntax

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

Fields

Details of the request to create DRS file in a Fleet.

Syntax

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

Fields

Custom Log for inventory or operation log.

Syntax

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

Fields

Attributes to create a Fleet.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_create_fleet_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  description varchar2(32767),
  inventory_log dbms_cloud_oci_jms_custom_log_t,
  operation_log dbms_cloud_oci_jms_custom_log_t,
  is_advanced_features_enabled number,
  defined_tags json_element_t,
  freeform_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_create_fleet_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_create_fleet_details_t (
    display_name varchar2,
    compartment_id varchar2,
    description varchar2,
    inventory_log dbms_cloud_oci_jms_custom_log_t,
    operation_log dbms_cloud_oci_jms_custom_log_t,
    is_advanced_features_enabled number,
    defined_tags json_element_t,
    freeform_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Metadata for the result of a crypto event analysis. The analysis result is stored in an Object Storage bucket.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_crypto_analysis_result_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  work_request_id varchar2(32767),
  aggregation_mode varchar2(32767),
  fleet_id varchar2(32767),
  managed_instance_id varchar2(32767),
  host_name varchar2(32767),
  time_first_event timestamp with time zone,
  time_last_event timestamp with time zone,
  total_event_count number,
  summarized_event_count number,
  finding_count number,
  non_compliant_finding_count number,
  time_created timestamp with time zone,
  crypto_roadmap_version varchar2(32767),
  namespace varchar2(32767),
  bucket_name varchar2(32767),
  object_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_crypto_analysis_result_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_crypto_analysis_result_t (
    id varchar2,
    work_request_id varchar2,
    aggregation_mode varchar2,
    fleet_id varchar2,
    managed_instance_id varchar2,
    host_name varchar2,
    time_first_event timestamp with time zone,
    time_last_event timestamp with time zone,
    total_event_count number,
    summarized_event_count number,
    finding_count number,
    non_compliant_finding_count number,
    time_created timestamp with time zone,
    crypto_roadmap_version varchar2,
    namespace varchar2,
    bucket_name varchar2,
    object_name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of a crypto analysis result. The actual output of the analysis is stored in the Object Storage object.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_crypto_analysis_result_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  work_request_id varchar2(32767),
  aggregation_mode varchar2(32767),
  fleet_id varchar2(32767),
  managed_instance_id varchar2(32767),
  host_name varchar2(32767),
  time_first_event timestamp with time zone,
  time_last_event timestamp with time zone,
  total_event_count number,
  summarized_event_count number,
  finding_count number,
  non_compliant_finding_count number,
  time_created timestamp with time zone,
  crypto_roadmap_version varchar2(32767),
  namespace varchar2(32767),
  bucket_name varchar2(32767),
  object_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_crypto_analysis_result_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_crypto_analysis_result_summary_t (
    id varchar2,
    work_request_id varchar2,
    aggregation_mode varchar2,
    fleet_id varchar2,
    managed_instance_id varchar2,
    host_name varchar2,
    time_first_event timestamp with time zone,
    time_last_event timestamp with time zone,
    total_event_count number,
    summarized_event_count number,
    finding_count number,
    non_compliant_finding_count number,
    time_created timestamp with time zone,
    crypto_roadmap_version varchar2,
    namespace varchar2,
    bucket_name varchar2,
    object_name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_crypto_analysis_result_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_crypto_analysis_result_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_crypto_analysis_result_summary_t) NOT PERSISTABLE;

List of Crypto event analysis results.

Syntax

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

Fields

Summarized events log for advanced feature.

Syntax

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

Fields

CryptoEventAnalysis configuration

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_crypto_event_analysis_t FORCE AUTHID CURRENT_USER IS OBJECT (
  is_enabled number,
  summarized_events_log dbms_cloud_oci_jms_summarized_events_log_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_crypto_event_analysis_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_crypto_event_analysis_t (
    is_enabled number,
    summarized_events_log dbms_cloud_oci_jms_summarized_events_log_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summarize usage information about an application deployed on Java servers including installation information during a specified time period. The main difference between DeployedApplicationInstallationUsageSummary and DeployedApplicationUsage is the presence of the applicationSourcePath. DeployedApplicationUsage provides only an aggregated view to the deployed applications without installation information. It therefore doesn’t distinguish between applications with the identical deployment information deployed to different paths. DeployedApplicationInstallationUsageSummary contains installation information, and it’s therefore possible to target actions.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_deployed_application_installation_usage_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  application_installation_key varchar2(32767),
  application_key varchar2(32767),
  fleet_id varchar2(32767),
  application_name varchar2(32767),
  application_type varchar2(32767),
  application_source_path varchar2(32767),
  is_clustered number,
  approximate_java_server_instance_count number,
  time_start timestamp with time zone,
  time_end timestamp with time zone,
  time_first_seen timestamp with time zone,
  time_last_seen timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_deployed_application_installation_usage_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_deployed_application_installation_usage_summary_t (
    application_installation_key varchar2,
    application_key varchar2,
    fleet_id varchar2,
    application_name varchar2,
    application_type varchar2,
    application_source_path varchar2,
    is_clustered number,
    approximate_java_server_instance_count number,
    time_start timestamp with time zone,
    time_end timestamp with time zone,
    time_first_seen timestamp with time zone,
    time_last_seen timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_deployed_application_installation_usage_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_deployed_application_installation_usage_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_deployed_application_installation_usage_summary_t) NOT PERSISTABLE;

Results of a deployed application installation usage search. Contains deployed application installation usage items.

Syntax

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

Fields

Deployed application usage during a specified time period.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_deployed_application_usage_t FORCE AUTHID CURRENT_USER IS OBJECT (
  application_key varchar2(32767),
  fleet_id varchar2(32767),
  application_name varchar2(32767),
  application_type varchar2(32767),
  is_clustered number,
  approximate_java_server_instance_count number,
  time_start timestamp with time zone,
  time_end timestamp with time zone,
  time_first_seen timestamp with time zone,
  time_last_seen timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_deployed_application_usage_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_deployed_application_usage_t (
    application_key varchar2,
    fleet_id varchar2,
    application_name varchar2,
    application_type varchar2,
    is_clustered number,
    approximate_java_server_instance_count number,
    time_start timestamp with time zone,
    time_end timestamp with time zone,
    time_first_seen timestamp with time zone,
    time_last_seen timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_deployed_application_usage_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_deployed_application_usage_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_deployed_application_usage_t) NOT PERSISTABLE;

Results of a deployed application usage search. Contains deployed application usage items.

Syntax

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

Fields

The target to manage DRS distribution. A target is a managed instance.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_jms_drs_target_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_drs_target_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_drs_target_t) NOT PERSISTABLE;

Details of the request to manage DRS in active managed instance(s) in a Fleet. When the targets aren't specified, then all active managed instance(s) currently in the Fleet are selected.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_manage_drs_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  targets dbms_cloud_oci_jms_drs_target_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_manage_drs_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_manage_drs_details_t (
    targets dbms_cloud_oci_jms_drs_target_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details of the request to disable DRS file from active managed instance(s) in a Fleet. When the targets aren't specified, then all active managed instance(s) currently in the Fleet are selected.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_disable_drs_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  manage_drs_details dbms_cloud_oci_jms_manage_drs_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_disable_drs_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_disable_drs_details_t (
    manage_drs_details dbms_cloud_oci_jms_manage_drs_details_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A Deployment Rule Set(DRS) is a JAR (Java ARchive) file used in Java applications to enforce security and manage compatibility between different versions of Java applets and web start applications (https://docs.oracle.com/javase/8/docs/technotes/guides/deploy/deployment_rules.html).

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_drs_file_t FORCE AUTHID CURRENT_USER IS OBJECT (
  bucket_name varchar2(32767),
  namespace varchar2(32767),
  drs_file_name varchar2(32767),
  drs_file_key varchar2(32767),
  checksum_type varchar2(32767),
  checksum_value varchar2(32767),
  is_default number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_drs_file_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_drs_file_t (
    bucket_name varchar2,
    namespace varchar2,
    drs_file_name varchar2,
    drs_file_key varchar2,
    checksum_type varchar2,
    checksum_value varchar2,
    is_default number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A Deployment Rule Set(DRS) is a JAR (Java ARchive) file used in Java applications to enforce security and manage compatibility between different versions of Java applets and web start applications (https://docs.oracle.com/javase/8/docs/technotes/guides/deploy/deployment_rules.html).

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_drs_file_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  bucket_name varchar2(32767),
  namespace varchar2(32767),
  drs_file_name varchar2(32767),
  drs_file_key varchar2(32767),
  checksum_type varchar2(32767),
  checksum_value varchar2(32767),
  is_default number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_drs_file_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_drs_file_summary_t (
    bucket_name varchar2,
    namespace varchar2,
    drs_file_name varchar2,
    drs_file_key varchar2,
    checksum_type varchar2,
    checksum_value varchar2,
    is_default number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_drs_file_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_drs_file_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_drs_file_summary_t) NOT PERSISTABLE;

List of DRS details.

Syntax

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

Fields

Details of the request to enable DRS in active managed instance(s) in a Fleet. When the targets aren't specified, then all active managed instance(s) currently in the Fleet are selected.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_enable_drs_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  manage_drs_details dbms_cloud_oci_jms_manage_drs_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_enable_drs_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_enable_drs_details_t (
    manage_drs_details dbms_cloud_oci_jms_manage_drs_details_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

An error code and message from an API request failure.

Syntax

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

Fields

The essential properties to identity a Java installation site.

Syntax

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

Fields

An export settings for JMS fleets.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_export_setting_t FORCE AUTHID CURRENT_USER IS OBJECT (
  export_setting_key varchar2(32767),
  fleet_id varchar2(32767),
  export_duration varchar2(32767),
  export_resources varchar2(32767),
  is_cross_region_acknowledged number,
  target_bucket_name varchar2(32767),
  target_bucket_namespace varchar2(32767),
  target_bucket_region varchar2(32767),
  export_frequency varchar2(32767),
  is_enabled number,
  time_created timestamp with time zone,
  time_last_modified timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_export_setting_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_export_setting_t (
    export_setting_key varchar2,
    fleet_id varchar2,
    export_duration varchar2,
    export_resources varchar2,
    is_cross_region_acknowledged number,
    target_bucket_name varchar2,
    target_bucket_namespace varchar2,
    target_bucket_region varchar2,
    export_frequency varchar2,
    is_enabled number,
    time_created timestamp with time zone,
    time_last_modified timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Attributes of fleet's export status.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_export_status_t FORCE AUTHID CURRENT_USER IS OBJECT (
  fleet_id varchar2(32767),
  time_last_run timestamp with time zone,
  time_next_run timestamp with time zone,
  latest_run_status varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_export_status_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_export_status_t (
    fleet_id varchar2,
    time_last_run timestamp with time zone,
    time_next_run timestamp with time zone,
    latest_run_status varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A Fleet is the primary collection with which users interact when using Java Management Service.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_fleet_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  compartment_id varchar2(32767),
  approximate_jre_count number,
  approximate_installation_count number,
  approximate_application_count number,
  approximate_managed_instance_count number,
  approximate_java_server_count number,
  inventory_log dbms_cloud_oci_jms_custom_log_t,
  operation_log dbms_cloud_oci_jms_custom_log_t,
  is_advanced_features_enabled number,
  is_export_setting_enabled number,
  time_created timestamp with time zone,
  lifecycle_state varchar2(32767),
  defined_tags json_element_t,
  freeform_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_fleet_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_fleet_t (
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    approximate_jre_count number,
    approximate_installation_count number,
    approximate_application_count number,
    approximate_managed_instance_count number,
    approximate_java_server_count number,
    inventory_log dbms_cloud_oci_jms_custom_log_t,
    operation_log dbms_cloud_oci_jms_custom_log_t,
    is_advanced_features_enabled number,
    is_export_setting_enabled number,
    time_created timestamp with time zone,
    lifecycle_state varchar2,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The algorithm object with name and key size properties.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_jms_key_size_algorithm_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_key_size_algorithm_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_key_size_algorithm_t) NOT PERSISTABLE;

test

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_minimum_key_size_settings_t FORCE AUTHID CURRENT_USER IS OBJECT (
  tls dbms_cloud_oci_jms_key_size_algorithm_tbl,
  jar dbms_cloud_oci_jms_key_size_algorithm_tbl,
  certpath dbms_cloud_oci_jms_key_size_algorithm_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_minimum_key_size_settings_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_minimum_key_size_settings_t (
    tls dbms_cloud_oci_jms_key_size_algorithm_tbl,
    jar dbms_cloud_oci_jms_key_size_algorithm_tbl,
    certpath dbms_cloud_oci_jms_key_size_algorithm_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

List of proxy properties to be configured in net.properties file.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_proxies_t FORCE AUTHID CURRENT_USER IS OBJECT (
  use_system_proxies number,
  http_proxy_host varchar2(32767),
  http_proxy_port number,
  https_proxy_host varchar2(32767),
  https_proxy_port number,
  ftp_proxy_host varchar2(32767),
  ftp_proxy_port number,
  socks_proxy_host varchar2(32767),
  socks_proxy_port number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_proxies_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_proxies_t (
    use_system_proxies number,
    http_proxy_host varchar2,
    http_proxy_port number,
    https_proxy_host varchar2,
    https_proxy_port number,
    ftp_proxy_host varchar2,
    ftp_proxy_port number,
    socks_proxy_host varchar2,
    socks_proxy_port number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

List of available post actions you can execute after the successful Java installation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_post_installation_action_settings_t FORCE AUTHID CURRENT_USER IS OBJECT (
  disabled_tls_versions dbms_cloud_oci_jms_varchar2_tbl,
  should_replace_certificates_operating_system number,
  minimum_key_size_settings dbms_cloud_oci_jms_minimum_key_size_settings_t,
  add_logging_handler number,
  global_logging_level varchar2(32767),
  proxies dbms_cloud_oci_jms_proxies_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_post_installation_action_settings_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_post_installation_action_settings_t (
    disabled_tls_versions dbms_cloud_oci_jms_varchar2_tbl,
    should_replace_certificates_operating_system number,
    minimum_key_size_settings dbms_cloud_oci_jms_minimum_key_size_settings_t,
    add_logging_handler number,
    global_logging_level varchar2,
    proxies dbms_cloud_oci_jms_proxies_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Enable lifecycle management and set post action configurations.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_lcm_t FORCE AUTHID CURRENT_USER IS OBJECT (
  is_enabled number,
  post_installation_actions dbms_cloud_oci_jms_post_installation_action_settings_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_lcm_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_lcm_t (
    is_enabled number,
    post_installation_actions dbms_cloud_oci_jms_post_installation_action_settings_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

JfrRecording configuration

Syntax

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

Fields

Performance tuning analysis configuration

Syntax

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

Fields

JavaMigrationAnalysis configuration

Syntax

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

Fields

Metadata for the advanced features in the Fleet.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_fleet_advanced_feature_configuration_t FORCE AUTHID CURRENT_USER IS OBJECT (
  analytic_namespace varchar2(32767),
  analytic_bucket_name varchar2(32767),
  lcm dbms_cloud_oci_jms_lcm_t,
  crypto_event_analysis dbms_cloud_oci_jms_crypto_event_analysis_t,
  advanced_usage_tracking dbms_cloud_oci_jms_advanced_usage_tracking_t,
  jfr_recording dbms_cloud_oci_jms_jfr_recording_t,
  performance_tuning_analysis dbms_cloud_oci_jms_performance_tuning_analysis_t,
  java_migration_analysis dbms_cloud_oci_jms_java_migration_analysis_t,
  time_last_modified timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_fleet_advanced_feature_configuration_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_fleet_advanced_feature_configuration_t (
    analytic_namespace varchar2,
    analytic_bucket_name varchar2,
    lcm dbms_cloud_oci_jms_lcm_t,
    crypto_event_analysis dbms_cloud_oci_jms_crypto_event_analysis_t,
    advanced_usage_tracking dbms_cloud_oci_jms_advanced_usage_tracking_t,
    jfr_recording dbms_cloud_oci_jms_jfr_recording_t,
    performance_tuning_analysis dbms_cloud_oci_jms_performance_tuning_analysis_t,
    java_migration_analysis dbms_cloud_oci_jms_java_migration_analysis_t,
    time_last_modified timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Management Agent Configuration for list of include/exclude file system paths (specific to operating system).

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_fleet_agent_os_configuration_t FORCE AUTHID CURRENT_USER IS OBJECT (
  include_paths dbms_cloud_oci_jms_varchar2_tbl,
  exclude_paths dbms_cloud_oci_jms_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_fleet_agent_os_configuration_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_fleet_agent_os_configuration_t (
    include_paths dbms_cloud_oci_jms_varchar2_tbl,
    exclude_paths dbms_cloud_oci_jms_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Management Agent Configuration for a Fleet. Includes JRE scanning frequency and a list of include/exclude file system paths.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_fleet_agent_configuration_t FORCE AUTHID CURRENT_USER IS OBJECT (
  jre_scan_frequency_in_minutes number,
  java_usage_tracker_processing_frequency_in_minutes number,
  work_request_validity_period_in_days number,
  agent_polling_interval_in_minutes number,
  linux_configuration dbms_cloud_oci_jms_fleet_agent_os_configuration_t,
  windows_configuration dbms_cloud_oci_jms_fleet_agent_os_configuration_t,
  mac_os_configuration dbms_cloud_oci_jms_fleet_agent_os_configuration_t,
  time_last_modified timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_fleet_agent_configuration_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_fleet_agent_configuration_t (
    jre_scan_frequency_in_minutes number,
    java_usage_tracker_processing_frequency_in_minutes number,
    work_request_validity_period_in_days number,
    agent_polling_interval_in_minutes number,
    linux_configuration dbms_cloud_oci_jms_fleet_agent_os_configuration_t,
    windows_configuration dbms_cloud_oci_jms_fleet_agent_os_configuration_t,
    mac_os_configuration dbms_cloud_oci_jms_fleet_agent_os_configuration_t,
    time_last_modified timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The summary of the Fleet. A Fleet is the primary collection with which users interact when using Java Management Service.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_fleet_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  compartment_id varchar2(32767),
  approximate_jre_count number,
  approximate_installation_count number,
  approximate_application_count number,
  approximate_managed_instance_count number,
  approximate_java_server_count number,
  inventory_log dbms_cloud_oci_jms_custom_log_t,
  operation_log dbms_cloud_oci_jms_custom_log_t,
  is_advanced_features_enabled number,
  is_export_setting_enabled number,
  time_created timestamp with time zone,
  lifecycle_state varchar2(32767),
  defined_tags json_element_t,
  freeform_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_fleet_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_fleet_summary_t (
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    approximate_jre_count number,
    approximate_installation_count number,
    approximate_application_count number,
    approximate_managed_instance_count number,
    approximate_java_server_count number,
    inventory_log dbms_cloud_oci_jms_custom_log_t,
    operation_log dbms_cloud_oci_jms_custom_log_t,
    is_advanced_features_enabled number,
    is_export_setting_enabled number,
    time_created timestamp with time zone,
    lifecycle_state varchar2,
    defined_tags json_element_t,
    freeform_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_fleet_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_fleet_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_fleet_summary_t) NOT PERSISTABLE;

Results of a Fleet search. Contains FleetSummary items.

Syntax

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

Fields

Diagnosis of a resource needed by the fleet.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_fleet_diagnosis_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  resource_type varchar2(32767),
  resource_id varchar2(32767),
  resource_state varchar2(32767),
  resource_diagnosis varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_fleet_diagnosis_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_fleet_diagnosis_summary_t (
    resource_type varchar2,
    resource_id varchar2,
    resource_state varchar2,
    resource_diagnosis varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_fleet_diagnosis_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_fleet_diagnosis_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_fleet_diagnosis_summary_t) NOT PERSISTABLE;

List of the fleet resource diagnosis.

Syntax

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

Fields

Attributes to generate agent deploy script for a Fleet.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_generate_agent_deploy_script_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  install_key_id varchar2(32767),
  os_family varchar2(32767),
  is_user_name_enabled number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_generate_agent_deploy_script_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_generate_agent_deploy_script_details_t (
    install_key_id varchar2,
    os_family varchar2,
    is_user_name_enabled number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The essential properties to identify a Java Runtime.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_java_runtime_id_t FORCE AUTHID CURRENT_USER IS OBJECT (
  version varchar2(32767),
  vendor varchar2(32767),
  distribution varchar2(32767),
  jre_key varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_java_runtime_id_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_java_runtime_id_t (
    version varchar2,
    vendor varchar2,
    distribution varchar2,
    jre_key varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_blocklist_entry_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_blocklist_entry_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_blocklist_entry_t) NOT PERSISTABLE;

Installation site of a Java Runtime. An installation site is a Java Runtime installed at a specific path on a managed instance.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_installation_site_t FORCE AUTHID CURRENT_USER IS OBJECT (
  installation_key varchar2(32767),
  managed_instance_id varchar2(32767),
  jre dbms_cloud_oci_jms_java_runtime_id_t,
  path varchar2(32767),
  operating_system dbms_cloud_oci_jms_operating_system_t,
  approximate_application_count number,
  time_last_seen timestamp with time zone,
  blocklist dbms_cloud_oci_jms_blocklist_entry_tbl,
  lifecycle_state varchar2(32767),
  managed_instance_type varchar2(32767),
  hostname varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_installation_site_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_installation_site_t (
    installation_key varchar2,
    managed_instance_id varchar2,
    jre dbms_cloud_oci_jms_java_runtime_id_t,
    path varchar2,
    operating_system dbms_cloud_oci_jms_operating_system_t,
    approximate_application_count number,
    time_last_seen timestamp with time zone,
    blocklist dbms_cloud_oci_jms_blocklist_entry_tbl,
    lifecycle_state varchar2,
    managed_instance_type varchar2,
    hostname varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Installation site of a Java Runtime. An installation site is a Java Runtime installed at a specific path on a managed instance.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_installation_site_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  installation_key varchar2(32767),
  managed_instance_id varchar2(32767),
  jre dbms_cloud_oci_jms_java_runtime_id_t,
  security_status varchar2(32767),
  path varchar2(32767),
  operating_system dbms_cloud_oci_jms_operating_system_t,
  approximate_application_count number,
  time_last_seen timestamp with time zone,
  blocklist dbms_cloud_oci_jms_blocklist_entry_tbl,
  lifecycle_state varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_installation_site_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_installation_site_summary_t (
    installation_key varchar2,
    managed_instance_id varchar2,
    jre dbms_cloud_oci_jms_java_runtime_id_t,
    security_status varchar2,
    path varchar2,
    operating_system dbms_cloud_oci_jms_operating_system_t,
    approximate_application_count number,
    time_last_seen timestamp with time zone,
    blocklist dbms_cloud_oci_jms_blocklist_entry_tbl,
    lifecycle_state varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_installation_site_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_installation_site_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_installation_site_summary_t) NOT PERSISTABLE;

Results of an installation site search. Contains installation sites.

Syntax

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

Fields

Installation usage during a specified time period. An installation is a collection of deployed instances of a specific Java Runtime that share the same install path.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_installation_usage_t FORCE AUTHID CURRENT_USER IS OBJECT (
  installation_key varchar2(32767),
  jre_vendor varchar2(32767),
  jre_distribution varchar2(32767),
  jre_version varchar2(32767),
  path varchar2(32767),
  os varchar2(32767),
  architecture varchar2(32767),
  operating_system dbms_cloud_oci_jms_operating_system_t,
  approximate_application_count number,
  approximate_managed_instance_count number,
  time_start timestamp with time zone,
  time_end timestamp with time zone,
  time_first_seen timestamp with time zone,
  time_last_seen timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_installation_usage_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_installation_usage_t (
    installation_key varchar2,
    jre_vendor varchar2,
    jre_distribution varchar2,
    jre_version varchar2,
    path varchar2,
    os varchar2,
    architecture varchar2,
    operating_system dbms_cloud_oci_jms_operating_system_t,
    approximate_application_count number,
    approximate_managed_instance_count number,
    time_start timestamp with time zone,
    time_end timestamp with time zone,
    time_first_seen timestamp with time zone,
    time_last_seen timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_installation_usage_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_installation_usage_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_installation_usage_t) NOT PERSISTABLE;

Results of an installation search. Contains InstallationUsage items.

Syntax

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

Fields

Information about a binary artifact of Java.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_java_artifact_t FORCE AUTHID CURRENT_USER IS OBJECT (
  artifact_id number,
  artifact_description varchar2(32767),
  artifact_content_type varchar2(32767),
  approximate_file_size_in_bytes number,
  sha256 varchar2(32767),
  artifact_file_name varchar2(32767),
  os_family varchar2(32767),
  architecture varchar2(32767),
  package_type varchar2(32767),
  package_type_detail varchar2(32767),
  download_url varchar2(32767),
  script_download_url varchar2(32767),
  script_checksum_url varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_java_artifact_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_java_artifact_t (
    artifact_id number,
    artifact_description varchar2,
    artifact_content_type varchar2,
    approximate_file_size_in_bytes number,
    sha256 varchar2,
    artifact_file_name varchar2,
    os_family varchar2,
    architecture varchar2,
    package_type varchar2,
    package_type_detail varchar2,
    download_url varchar2,
    script_download_url varchar2,
    script_checksum_url varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_java_artifact_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_java_artifact_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_java_artifact_t) NOT PERSISTABLE;

Metadata associated with a specific Java release family. A Java release family is typically a major version in the Java version identifier.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_java_family_t FORCE AUTHID CURRENT_USER IS OBJECT (
  latest_release_artifacts dbms_cloud_oci_jms_java_artifact_tbl,
  family_version varchar2(32767),
  display_name varchar2(32767),
  support_type varchar2(32767),
  end_of_support_life_date timestamp with time zone,
  doc_url varchar2(32767),
  latest_release_version varchar2(32767),
  is_supported_version number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_java_family_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_java_family_t (
    latest_release_artifacts dbms_cloud_oci_jms_java_artifact_tbl,
    family_version varchar2,
    display_name varchar2,
    support_type varchar2,
    end_of_support_life_date timestamp with time zone,
    doc_url varchar2,
    latest_release_version varchar2,
    is_supported_version number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A summary of the Java release family information. A Java release family is typically a major version in the Java version identifier.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_java_family_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  family_version varchar2(32767),
  display_name varchar2(32767),
  support_type varchar2(32767),
  end_of_support_life_date timestamp with time zone,
  doc_url varchar2(32767),
  latest_release_version varchar2(32767),
  is_supported_version number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_java_family_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_java_family_summary_t (
    family_version varchar2,
    display_name varchar2,
    support_type varchar2,
    end_of_support_life_date timestamp with time zone,
    doc_url varchar2,
    latest_release_version varchar2,
    is_supported_version number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_java_family_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_java_family_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_java_family_summary_t) NOT PERSISTABLE;

Collection of the Java release family summary. A Java release family is typically a major version in the Java version identifier.

Syntax

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

Fields

Information about a license type for Java.

Syntax

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

Fields

Result of the Java migration analysis. The analysis result is stored in an Object Storage bucket.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_java_migration_analysis_result_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  work_request_id varchar2(32767),
  fleet_id varchar2(32767),
  application_key varchar2(32767),
  application_name varchar2(32767),
  application_path varchar2(32767),
  application_execution_type varchar2(32767),
  source_jdk_version varchar2(32767),
  target_jdk_version varchar2(32767),
  managed_instance_id varchar2(32767),
  host_name varchar2(32767),
  time_created timestamp with time zone,
  namespace varchar2(32767),
  bucket_name varchar2(32767),
  object_storage_upload_dir_path varchar2(32767),
  object_list dbms_cloud_oci_jms_varchar2_tbl,
  metadata varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_java_migration_analysis_result_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_java_migration_analysis_result_t (
    id varchar2,
    work_request_id varchar2,
    fleet_id varchar2,
    application_key varchar2,
    application_name varchar2,
    application_path varchar2,
    application_execution_type varchar2,
    source_jdk_version varchar2,
    target_jdk_version varchar2,
    managed_instance_id varchar2,
    host_name varchar2,
    time_created timestamp with time zone,
    namespace varchar2,
    bucket_name varchar2,
    object_storage_upload_dir_path varchar2,
    object_list dbms_cloud_oci_jms_varchar2_tbl,
    metadata varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of a Java migration analysis result. The output of the analysis is stored in the Object Storage object.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_java_migration_analysis_result_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  work_request_id varchar2(32767),
  fleet_id varchar2(32767),
  application_key varchar2(32767),
  application_name varchar2(32767),
  application_path varchar2(32767),
  application_execution_type varchar2(32767),
  source_jdk_version varchar2(32767),
  target_jdk_version varchar2(32767),
  managed_instance_id varchar2(32767),
  host_name varchar2(32767),
  time_created timestamp with time zone,
  namespace varchar2(32767),
  bucket_name varchar2(32767),
  object_storage_upload_dir_path varchar2(32767),
  object_list dbms_cloud_oci_jms_varchar2_tbl,
  metadata varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_java_migration_analysis_result_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_java_migration_analysis_result_summary_t (
    id varchar2,
    work_request_id varchar2,
    fleet_id varchar2,
    application_key varchar2,
    application_name varchar2,
    application_path varchar2,
    application_execution_type varchar2,
    source_jdk_version varchar2,
    target_jdk_version varchar2,
    managed_instance_id varchar2,
    host_name varchar2,
    time_created timestamp with time zone,
    namespace varchar2,
    bucket_name varchar2,
    object_storage_upload_dir_path varchar2,
    object_list dbms_cloud_oci_jms_varchar2_tbl,
    metadata varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_java_migration_analysis_result_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_java_migration_analysis_result_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_java_migration_analysis_result_summary_t) NOT PERSISTABLE;

List of Java migration analysis results.

Syntax

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

Fields

The target describes the input data for Java migration analysis. A target contains a managed instance, application Installation Key, sourceJdkVersion, and targetJdkVersion.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_java_migration_analysis_target_t FORCE AUTHID CURRENT_USER IS OBJECT (
  managed_instance_id varchar2(32767),
  application_installation_key varchar2(32767),
  source_jdk_version varchar2(32767),
  target_jdk_version varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_java_migration_analysis_target_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_java_migration_analysis_target_t (
    managed_instance_id varchar2,
    application_installation_key varchar2,
    source_jdk_version varchar2,
    target_jdk_version varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

My Oracle Support(MoS) patch details for the Java release.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_jms_patch_detail_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_patch_detail_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_patch_detail_t) NOT PERSISTABLE;

Metadata associated with a specific release of Java. Includes the artifact details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_java_release_t FORCE AUTHID CURRENT_USER IS OBJECT (
  artifacts dbms_cloud_oci_jms_java_artifact_tbl,
  release_version varchar2(32767),
  family_version varchar2(32767),
  parent_release_version varchar2(32767),
  security_status varchar2(32767),
  release_type varchar2(32767),
  license_type varchar2(32767),
  family_details dbms_cloud_oci_jms_java_family_t,
  license_details dbms_cloud_oci_jms_java_license_t,
  release_date timestamp with time zone,
  release_notes_url varchar2(32767),
  artifact_content_types dbms_cloud_oci_jms_varchar2_tbl,
  mos_patches dbms_cloud_oci_jms_patch_detail_tbl,
  days_under_security_baseline number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_java_release_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_java_release_t (
    artifacts dbms_cloud_oci_jms_java_artifact_tbl,
    release_version varchar2,
    family_version varchar2,
    parent_release_version varchar2,
    security_status varchar2,
    release_type varchar2,
    license_type varchar2,
    family_details dbms_cloud_oci_jms_java_family_t,
    license_details dbms_cloud_oci_jms_java_license_t,
    release_date timestamp with time zone,
    release_notes_url varchar2,
    artifact_content_types dbms_cloud_oci_jms_varchar2_tbl,
    mos_patches dbms_cloud_oci_jms_patch_detail_tbl,
    days_under_security_baseline number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A summary of the Java release properties.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_java_release_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  release_version varchar2(32767),
  family_version varchar2(32767),
  parent_release_version varchar2(32767),
  security_status varchar2(32767),
  release_type varchar2(32767),
  license_type varchar2(32767),
  family_details dbms_cloud_oci_jms_java_family_t,
  license_details dbms_cloud_oci_jms_java_license_t,
  release_date timestamp with time zone,
  release_notes_url varchar2(32767),
  artifact_content_types dbms_cloud_oci_jms_varchar2_tbl,
  mos_patches dbms_cloud_oci_jms_patch_detail_tbl,
  days_under_security_baseline number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_java_release_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_java_release_summary_t (
    release_version varchar2,
    family_version varchar2,
    parent_release_version varchar2,
    security_status varchar2,
    release_type varchar2,
    license_type varchar2,
    family_details dbms_cloud_oci_jms_java_family_t,
    license_details dbms_cloud_oci_jms_java_license_t,
    release_date timestamp with time zone,
    release_notes_url varchar2,
    artifact_content_types dbms_cloud_oci_jms_varchar2_tbl,
    mos_patches dbms_cloud_oci_jms_patch_detail_tbl,
    days_under_security_baseline number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_java_release_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_java_release_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_java_release_summary_t) NOT PERSISTABLE;

Collection of Java releases information.

Syntax

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

Fields

Java Server instance usage during a specified time period.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_java_server_instance_usage_t FORCE AUTHID CURRENT_USER IS OBJECT (
  server_instance_key varchar2(32767),
  fleet_id varchar2(32767),
  server_instance_name varchar2(32767),
  server_key varchar2(32767),
  server_name varchar2(32767),
  server_version varchar2(32767),
  managed_instance_id varchar2(32767),
  host_name varchar2(32767),
  jvm_key varchar2(32767),
  jvm_vendor varchar2(32767),
  jvm_distribution varchar2(32767),
  jvm_version varchar2(32767),
  jvm_security_status varchar2(32767),
  approximate_deployed_application_count number,
  time_start timestamp with time zone,
  time_end timestamp with time zone,
  time_first_seen timestamp with time zone,
  time_last_seen timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_java_server_instance_usage_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_java_server_instance_usage_t (
    server_instance_key varchar2,
    fleet_id varchar2,
    server_instance_name varchar2,
    server_key varchar2,
    server_name varchar2,
    server_version varchar2,
    managed_instance_id varchar2,
    host_name varchar2,
    jvm_key varchar2,
    jvm_vendor varchar2,
    jvm_distribution varchar2,
    jvm_version varchar2,
    jvm_security_status varchar2,
    approximate_deployed_application_count number,
    time_start timestamp with time zone,
    time_end timestamp with time zone,
    time_first_seen timestamp with time zone,
    time_last_seen timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_java_server_instance_usage_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_java_server_instance_usage_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_java_server_instance_usage_t) NOT PERSISTABLE;

Results of a Java Server instance usage search. Contains Java Server usage items.

Syntax

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

Fields

Java Server usage during a specified time period.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_java_server_usage_t FORCE AUTHID CURRENT_USER IS OBJECT (
  server_key varchar2(32767),
  fleet_id varchar2(32767),
  server_name varchar2(32767),
  server_version varchar2(32767),
  server_instance_count number,
  approximate_deployed_application_count number,
  time_start timestamp with time zone,
  time_end timestamp with time zone,
  time_first_seen timestamp with time zone,
  time_last_seen timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_java_server_usage_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_java_server_usage_t (
    server_key varchar2,
    fleet_id varchar2,
    server_name varchar2,
    server_version varchar2,
    server_instance_count number,
    approximate_deployed_application_count number,
    time_start timestamp with time zone,
    time_end timestamp with time zone,
    time_first_seen timestamp with time zone,
    time_last_seen timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_java_server_usage_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_java_server_usage_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_java_server_usage_t) NOT PERSISTABLE;

Results of a Java Server usage search. Contains Java Server usage items.

Syntax

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

Fields

The target to collect JFR data. A target is a managed instance, with options to further limit to specific application and/or Java Runtime. When the applicationKey isn't specified, then all applications are selected. When the jreKey isn't specified, then all supported Java Runtime versions are selected. When the applicationInstallationKey isn't specified, then all application installations are selected. Keys applicationKey and applicationInstallationKey are mutually exclusive.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_jfr_attachment_target_t FORCE AUTHID CURRENT_USER IS OBJECT (
  managed_instance_id varchar2(32767),
  application_key varchar2(32767),
  application_installation_key varchar2(32767),
  jre_key varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_jfr_attachment_target_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_jfr_attachment_target_t (
    managed_instance_id varchar2,
    application_key varchar2,
    application_installation_key varchar2,
    jre_key varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Java Runtime usage during a specified time period. A Java Runtime is identified by its vendor and version.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_jre_usage_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  fleet_id varchar2(32767),
  managed_instance_id varchar2(32767),
  security_status varchar2(32767),
  release_date timestamp with time zone,
  end_of_support_life_date timestamp with time zone,
  vendor varchar2(32767),
  distribution varchar2(32767),
  version varchar2(32767),
  days_under_security_baseline number,
  operating_systems dbms_cloud_oci_jms_operating_system_tbl,
  approximate_installation_count number,
  approximate_application_count number,
  approximate_managed_instance_count number,
  approximate_pending_work_request_count number,
  time_start timestamp with time zone,
  time_end timestamp with time zone,
  time_first_seen timestamp with time zone,
  time_last_seen timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_jre_usage_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_jre_usage_t (
    id varchar2,
    fleet_id varchar2,
    managed_instance_id varchar2,
    security_status varchar2,
    release_date timestamp with time zone,
    end_of_support_life_date timestamp with time zone,
    vendor varchar2,
    distribution varchar2,
    version varchar2,
    days_under_security_baseline number,
    operating_systems dbms_cloud_oci_jms_operating_system_tbl,
    approximate_installation_count number,
    approximate_application_count number,
    approximate_managed_instance_count number,
    approximate_pending_work_request_count number,
    time_start timestamp with time zone,
    time_end timestamp with time zone,
    time_first_seen timestamp with time zone,
    time_last_seen timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_jre_usage_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_jre_usage_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_jre_usage_t) NOT PERSISTABLE;

Results of a Java Runtime search. Contains JreUsage items

Syntax

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

Fields

The work item details with LCM related information.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_lcm_work_item_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_jms_work_item_details_t (
  post_installation_actions dbms_cloud_oci_jms_post_installation_action_settings_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_lcm_work_item_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_lcm_work_item_details_t (
    kind varchar2,
    work_item_type varchar2,
    post_installation_actions dbms_cloud_oci_jms_post_installation_action_settings_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_jms_lcm_work_item_details_t is a subtype of the dbms_cloud_oci_jms_work_item_details_t type.

Fields

Library usage during a specified time period.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_library_usage_t FORCE AUTHID CURRENT_USER IS OBJECT (
  library_key varchar2(32767),
  fleet_id varchar2(32767),
  library_name varchar2(32767),
  library_version varchar2(32767),
  cvss_score number,
  approximate_application_count number,
  approximate_java_server_instance_count number,
  approximate_deployed_application_count number,
  approximate_managed_instance_count number,
  time_start timestamp with time zone,
  time_end timestamp with time zone,
  time_first_seen timestamp with time zone,
  time_last_seen timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_library_usage_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_library_usage_t (
    library_key varchar2,
    fleet_id varchar2,
    library_name varchar2,
    library_version varchar2,
    cvss_score number,
    approximate_application_count number,
    approximate_java_server_instance_count number,
    approximate_deployed_application_count number,
    approximate_managed_instance_count number,
    time_start timestamp with time zone,
    time_end timestamp with time zone,
    time_first_seen timestamp with time zone,
    time_last_seen timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_library_usage_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_library_usage_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_library_usage_t) NOT PERSISTABLE;

Results of a library usage search. Contains library usage items.

Syntax

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

Fields

Managed instance usage during a specified time period. An entity that emits usage events to Java Management Service (JMS) is represented as a managed instance. A managed instance has a unique identity which is used by JMS to distinguish it from other managed instances. Currently, JMS supports only one kind of managed instance, a Management Agent.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_managed_instance_usage_t FORCE AUTHID CURRENT_USER IS OBJECT (
  managed_instance_id varchar2(32767),
  managed_instance_type varchar2(32767),
  hostname varchar2(32767),
  host_id varchar2(32767),
  operating_system dbms_cloud_oci_jms_operating_system_t,
  agent dbms_cloud_oci_jms_agent_t,
  approximate_application_count number,
  approximate_installation_count number,
  approximate_jre_count number,
  drs_file_status varchar2(32767),
  time_start timestamp with time zone,
  time_end timestamp with time zone,
  time_first_seen timestamp with time zone,
  time_last_seen timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_managed_instance_usage_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_managed_instance_usage_t (
    managed_instance_id varchar2,
    managed_instance_type varchar2,
    hostname varchar2,
    host_id varchar2,
    operating_system dbms_cloud_oci_jms_operating_system_t,
    agent dbms_cloud_oci_jms_agent_t,
    approximate_application_count number,
    approximate_installation_count number,
    approximate_jre_count number,
    drs_file_status varchar2,
    time_start timestamp with time zone,
    time_end timestamp with time zone,
    time_first_seen timestamp with time zone,
    time_last_seen timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_managed_instance_usage_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_managed_instance_usage_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_managed_instance_usage_t) NOT PERSISTABLE;

Results of a managed instance search. Contains ManagedInstanceUsage items.

Syntax

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

Fields

Metadata of a Performance Tuning Analysis result. The analysis result is stored as the Object Storage object.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_performance_tuning_analysis_result_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  work_request_id varchar2(32767),
  fleet_id varchar2(32767),
  application_id varchar2(32767),
  application_installation_id varchar2(32767),
  application_installation_path varchar2(32767),
  warning_count number,
  result varchar2(32767),
  managed_instance_id varchar2(32767),
  host_name varchar2(32767),
  application_name varchar2(32767),
  namespace varchar2(32767),
  bucket_name varchar2(32767),
  object_name varchar2(32767),
  time_created timestamp with time zone,
  time_started timestamp with time zone,
  time_finished timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_performance_tuning_analysis_result_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_performance_tuning_analysis_result_t (
    id varchar2,
    work_request_id varchar2,
    fleet_id varchar2,
    application_id varchar2,
    application_installation_id varchar2,
    application_installation_path varchar2,
    warning_count number,
    result varchar2,
    managed_instance_id varchar2,
    host_name varchar2,
    application_name varchar2,
    namespace varchar2,
    bucket_name varchar2,
    object_name varchar2,
    time_created timestamp with time zone,
    time_started timestamp with time zone,
    time_finished timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of a performance tuning analysis result. The actual output of the analysis is stored in the Object Storage object.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_performance_tuning_analysis_result_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  work_request_id varchar2(32767),
  fleet_id varchar2(32767),
  application_id varchar2(32767),
  application_installation_id varchar2(32767),
  application_installation_path varchar2(32767),
  warning_count number,
  result varchar2(32767),
  managed_instance_id varchar2(32767),
  host_name varchar2(32767),
  application_name varchar2(32767),
  namespace varchar2(32767),
  bucket_name varchar2(32767),
  object_name varchar2(32767),
  time_created timestamp with time zone,
  time_started timestamp with time zone,
  time_finished timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_performance_tuning_analysis_result_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_performance_tuning_analysis_result_summary_t (
    id varchar2,
    work_request_id varchar2,
    fleet_id varchar2,
    application_id varchar2,
    application_installation_id varchar2,
    application_installation_path varchar2,
    warning_count number,
    result varchar2,
    managed_instance_id varchar2,
    host_name varchar2,
    application_name varchar2,
    namespace varchar2,
    bucket_name varchar2,
    object_name varchar2,
    time_created timestamp with time zone,
    time_started timestamp with time zone,
    time_finished timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_performance_tuning_analysis_result_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_performance_tuning_analysis_result_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_performance_tuning_analysis_result_summary_t) NOT PERSISTABLE;

List of Performance Tuning Analysis results.

Syntax

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

Fields

An authorized principal.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_jms_existing_installation_site_id_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_existing_installation_site_id_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_existing_installation_site_id_t) NOT PERSISTABLE;

The list of Java installation sites to remove.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_remove_fleet_installation_sites_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  installation_sites dbms_cloud_oci_jms_existing_installation_site_id_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_remove_fleet_installation_sites_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_remove_fleet_installation_sites_details_t (
    installation_sites dbms_cloud_oci_jms_existing_installation_site_id_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_jfr_attachment_target_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_jfr_attachment_target_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_jfr_attachment_target_t) NOT PERSISTABLE;

Details of the request to start a JFR crypto event analysis. When the targets aren't specified, then all managed instances currently in the fleet are selected.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_request_crypto_analyses_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  targets dbms_cloud_oci_jms_jfr_attachment_target_tbl,
  recording_duration_in_minutes number,
  waiting_period_in_minutes number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_request_crypto_analyses_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_request_crypto_analyses_details_t (
    targets dbms_cloud_oci_jms_jfr_attachment_target_tbl,
    recording_duration_in_minutes number,
    waiting_period_in_minutes number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_java_migration_analysis_target_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_java_migration_analysis_target_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_java_migration_analysis_target_t) NOT PERSISTABLE;

Details of the request to start a Java migration analysis. The analysis requires the managed instance OCID, application installation key, source JDK version, and target JDK version of each selected application.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_request_java_migration_analyses_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  targets dbms_cloud_oci_jms_java_migration_analysis_target_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_request_java_migration_analyses_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_request_java_migration_analyses_details_t (
    targets dbms_cloud_oci_jms_java_migration_analysis_target_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details of the request to start JFR recordings. When the targets aren't specified, then all managed instances currently in the Fleet are selected.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_request_jfr_recordings_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  targets dbms_cloud_oci_jms_jfr_attachment_target_tbl,
  jfc_profile_name varchar2(32767),
  jfc_v1 varchar2(32767),
  jfc_v2 varchar2(32767),
  recording_duration_in_minutes number,
  recording_size_in_mb number,
  waiting_period_in_minutes number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_request_jfr_recordings_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_request_jfr_recordings_details_t (
    targets dbms_cloud_oci_jms_jfr_attachment_target_tbl,
    jfc_profile_name varchar2,
    jfc_v1 varchar2,
    jfc_v2 varchar2,
    recording_duration_in_minutes number,
    recording_size_in_mb number,
    waiting_period_in_minutes number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details of the request to start a JFR performance tuning analysis.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_request_performance_tuning_analyses_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  targets dbms_cloud_oci_jms_jfr_attachment_target_tbl,
  recording_duration_in_minutes number,
  waiting_period_in_minutes number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_request_performance_tuning_analyses_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_request_performance_tuning_analyses_details_t (
    targets dbms_cloud_oci_jms_jfr_attachment_target_tbl,
    recording_duration_in_minutes number,
    waiting_period_in_minutes number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Inventory of JMS resources in a compartment during a specified time period.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_resource_inventory_t FORCE AUTHID CURRENT_USER IS OBJECT (
  active_fleet_count number,
  managed_instance_count number,
  jre_count number,
  installation_count number,
  application_count number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_resource_inventory_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_resource_inventory_t (
    active_fleet_count number,
    managed_instance_count number,
    jre_count number,
    installation_count number,
    application_count number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The list of managed instances to scan.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_scan_java_server_usage_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  managed_instance_ids dbms_cloud_oci_jms_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_scan_java_server_usage_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_scan_java_server_usage_details_t (
    managed_instance_ids dbms_cloud_oci_jms_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The list of managed instances to scan.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_scan_library_usage_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  managed_instance_ids dbms_cloud_oci_jms_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_scan_library_usage_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_scan_library_usage_details_t (
    managed_instance_ids dbms_cloud_oci_jms_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details of the request to update DRS file in a Fleet.

Syntax

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

Fields

Attributes to update a Export setting.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_update_export_setting_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  export_duration varchar2(32767),
  export_resources varchar2(32767),
  is_cross_region_acknowledged number,
  target_bucket_name varchar2(32767),
  target_bucket_namespace varchar2(32767),
  target_bucket_region varchar2(32767),
  export_frequency varchar2(32767),
  is_enabled number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_update_export_setting_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_update_export_setting_details_t (
    export_duration varchar2,
    export_resources varchar2,
    is_cross_region_acknowledged number,
    target_bucket_name varchar2,
    target_bucket_namespace varchar2,
    target_bucket_region varchar2,
    export_frequency varchar2,
    is_enabled number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details object containing advanced feature configurations to be updated. Ensure that the namespace and bucket storage are created prior to turning on the JfrRecording or CryptoEventAnalysis feature.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_update_fleet_advanced_feature_configuration_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  analytic_namespace varchar2(32767),
  analytic_bucket_name varchar2(32767),
  lcm dbms_cloud_oci_jms_lcm_t,
  crypto_event_analysis dbms_cloud_oci_jms_crypto_event_analysis_t,
  advanced_usage_tracking dbms_cloud_oci_jms_advanced_usage_tracking_t,
  jfr_recording dbms_cloud_oci_jms_jfr_recording_t,
  performance_tuning_analysis dbms_cloud_oci_jms_performance_tuning_analysis_t,
  java_migration_analysis dbms_cloud_oci_jms_java_migration_analysis_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_update_fleet_advanced_feature_configuration_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_update_fleet_advanced_feature_configuration_details_t (
    analytic_namespace varchar2,
    analytic_bucket_name varchar2,
    lcm dbms_cloud_oci_jms_lcm_t,
    crypto_event_analysis dbms_cloud_oci_jms_crypto_event_analysis_t,
    advanced_usage_tracking dbms_cloud_oci_jms_advanced_usage_tracking_t,
    jfr_recording dbms_cloud_oci_jms_jfr_recording_t,
    performance_tuning_analysis dbms_cloud_oci_jms_performance_tuning_analysis_t,
    java_migration_analysis dbms_cloud_oci_jms_java_migration_analysis_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Attributes to update a Fleet Agent Configuration.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_update_fleet_agent_configuration_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  jre_scan_frequency_in_minutes number,
  java_usage_tracker_processing_frequency_in_minutes number,
  work_request_validity_period_in_days number,
  agent_polling_interval_in_minutes number,
  linux_configuration dbms_cloud_oci_jms_fleet_agent_os_configuration_t,
  windows_configuration dbms_cloud_oci_jms_fleet_agent_os_configuration_t,
  mac_os_configuration dbms_cloud_oci_jms_fleet_agent_os_configuration_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_update_fleet_agent_configuration_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_update_fleet_agent_configuration_details_t (
    jre_scan_frequency_in_minutes number,
    java_usage_tracker_processing_frequency_in_minutes number,
    work_request_validity_period_in_days number,
    agent_polling_interval_in_minutes number,
    linux_configuration dbms_cloud_oci_jms_fleet_agent_os_configuration_t,
    windows_configuration dbms_cloud_oci_jms_fleet_agent_os_configuration_t,
    mac_os_configuration dbms_cloud_oci_jms_fleet_agent_os_configuration_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Attributes to update a Fleet.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_update_fleet_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  description varchar2(32767),
  inventory_log dbms_cloud_oci_jms_custom_log_t,
  operation_log dbms_cloud_oci_jms_custom_log_t,
  is_advanced_features_enabled number,
  defined_tags json_element_t,
  freeform_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_update_fleet_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_update_fleet_details_t (
    display_name varchar2,
    description varchar2,
    inventory_log dbms_cloud_oci_jms_custom_log_t,
    operation_log dbms_cloud_oci_jms_custom_log_t,
    is_advanced_features_enabled number,
    defined_tags json_element_t,
    freeform_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Work item to complete a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_work_item_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  work_request_id varchar2(32767),
  installation_site dbms_cloud_oci_jms_installation_site_t,
  details dbms_cloud_oci_jms_work_item_details_t,
  status varchar2(32767),
  retry_count number,
  time_last_updated timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_work_item_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_jms_work_item_summary_t (
    id varchar2,
    work_request_id varchar2,
    installation_site dbms_cloud_oci_jms_installation_site_t,
    details dbms_cloud_oci_jms_work_item_details_t,
    status varchar2,
    retry_count number,
    time_last_updated timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_jms_work_item_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_work_item_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_work_item_summary_t) NOT PERSISTABLE;

A list of WorkItem.

Syntax

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

Fields

A resource that is created or operated on by an asynchronous operation that is tracked by a work request.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_jms_work_request_resource_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_work_request_resource_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_work_request_resource_t) NOT PERSISTABLE;

An asynchronous work request. See Work Requests.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_jms_work_request_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_work_request_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_work_request_t) NOT PERSISTABLE;

Results of a work request search. Contains WorkRequest items

Syntax

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

Fields

An error encountered while executing an operation that is tracked by a work request.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_jms_work_request_error_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_work_request_error_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_work_request_error_t) NOT PERSISTABLE;

Results of a work request error search. Contains WorkRequestError items

Syntax

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

Fields

A log message from executing an operation that is tracked by a work request.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_jms_work_request_log_entry_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_jms_work_request_log_entry_tbl FORCE IS TABLE OF (dbms_cloud_oci_jms_work_request_log_entry_t) NOT PERSISTABLE;

Results of a work request log entry search. Contains WorkRequestLogEntry items

Syntax

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

Fields