Contains the response body, headers and the status code of the clone_sql_tuning_task request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dm_sql_tuning_clone_sql_tuning_task_response_t FORCE AUTHID CURRENT_USER IS OBJECT (
  response_body dbms_cloud_oci_database_management_sql_tuning_task_return_t,
  headers json_object_t,
  status_code number 
) NOT PERSISTABLE;

Fields

Contains the response body, headers and the status code of the create_sql_tuning_set request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dm_sql_tuning_create_sql_tuning_set_response_t FORCE AUTHID CURRENT_USER IS OBJECT (
  response_body dbms_cloud_oci_database_management_sql_tuning_set_t,
  headers json_object_t,
  status_code number 
) NOT PERSISTABLE;

Fields

Contains the response body, headers and the status code of the drop_sql_tuning_set request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dm_sql_tuning_drop_sql_tuning_set_response_t FORCE AUTHID CURRENT_USER IS OBJECT (
  response_body dbms_cloud_oci_database_management_sql_tuning_set_admin_action_status_t,
  headers json_object_t,
  status_code number 
) NOT PERSISTABLE;

Fields

Contains the response body, headers and the status code of the drop_sql_tuning_task request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dm_sql_tuning_drop_sql_tuning_task_response_t FORCE AUTHID CURRENT_USER IS OBJECT (
  headers json_object_t,
  status_code number 
) NOT PERSISTABLE;

Fields

Contains the response body, headers and the status code of the drop_sqls_in_sql_tuning_set request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dm_sql_tuning_drop_sqls_in_sql_tuning_set_response_t FORCE AUTHID CURRENT_USER IS OBJECT (
  response_body dbms_cloud_oci_database_management_sql_tuning_set_admin_action_status_t,
  headers json_object_t,
  status_code number 
) NOT PERSISTABLE;

Fields

Contains the response body, headers and the status code of the fetch_sql_tuning_set request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dm_sql_tuning_fetch_sql_tuning_set_response_t FORCE AUTHID CURRENT_USER IS OBJECT (
  response_body dbms_cloud_oci_database_management_sql_tuning_set_t,
  headers json_object_t,
  status_code number 
) NOT PERSISTABLE;

Fields

Contains the response body, headers and the status code of the get_execution_plan_stats_comparision request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dm_sql_tuning_get_execution_plan_stats_comparision_response_t FORCE AUTHID CURRENT_USER IS OBJECT (
  response_body dbms_cloud_oci_database_management_execution_plan_stats_comparision_t,
  headers json_object_t,
  status_code number 
) NOT PERSISTABLE;

Fields

Contains the response body, headers and the status code of the get_sql_execution_plan request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dm_sql_tuning_get_sql_execution_plan_response_t FORCE AUTHID CURRENT_USER IS OBJECT (
  response_body dbms_cloud_oci_database_management_sql_tuning_advisor_task_sql_execution_plan_t,
  headers json_object_t,
  status_code number 
) NOT PERSISTABLE;

Fields

Contains the response body, headers and the status code of the get_sql_tuning_advisor_task_summary_report request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dm_sql_tuning_get_sql_tuning_advisor_task_summary_report_response_t FORCE AUTHID CURRENT_USER IS OBJECT (
  response_body dbms_cloud_oci_database_management_sql_tuning_advisor_task_summary_report_t,
  headers json_object_t,
  status_code number 
) NOT PERSISTABLE;

Fields

Contains the response body, headers and the status code of the list_sql_tuning_advisor_task_findings request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dm_sql_tuning_list_sql_tuning_advisor_task_findings_response_t FORCE AUTHID CURRENT_USER IS OBJECT (
  response_body dbms_cloud_oci_database_management_sql_tuning_advisor_task_finding_collection_t,
  headers json_object_t,
  status_code number 
) NOT PERSISTABLE;

Fields

Contains the response body, headers and the status code of the list_sql_tuning_advisor_task_recommendations request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dm_sql_tuning_list_sql_tuning_advisor_task_recommendations_response_t FORCE AUTHID CURRENT_USER IS OBJECT (
  response_body dbms_cloud_oci_database_management_sql_tuning_advisor_task_recommendation_collection_t,
  headers json_object_t,
  status_code number 
) NOT PERSISTABLE;

Fields

Contains the response body, headers and the status code of the list_sql_tuning_advisor_tasks request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dm_sql_tuning_list_sql_tuning_advisor_tasks_response_t FORCE AUTHID CURRENT_USER IS OBJECT (
  response_body dbms_cloud_oci_database_management_sql_tuning_advisor_task_collection_t,
  headers json_object_t,
  status_code number 
) NOT PERSISTABLE;

Fields

Contains the response body, headers and the status code of the list_sql_tuning_sets request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dm_sql_tuning_list_sql_tuning_sets_response_t FORCE AUTHID CURRENT_USER IS OBJECT (
  response_body dbms_cloud_oci_database_management_sql_tuning_set_collection_t,
  headers json_object_t,
  status_code number 
) NOT PERSISTABLE;

Fields

Contains the response body, headers and the status code of the load_sql_tuning_set request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dm_sql_tuning_load_sql_tuning_set_response_t FORCE AUTHID CURRENT_USER IS OBJECT (
  response_body dbms_cloud_oci_database_management_sql_tuning_set_admin_action_status_t,
  headers json_object_t,
  status_code number 
) NOT PERSISTABLE;

Fields

Contains the response body, headers and the status code of the save_sql_tuning_set_as request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dm_sql_tuning_save_sql_tuning_set_as_response_t FORCE AUTHID CURRENT_USER IS OBJECT (
  response_body dbms_cloud_oci_database_management_sql_tuning_set_admin_action_status_t,
  headers json_object_t,
  status_code number 
) NOT PERSISTABLE;

Fields

Contains the response body, headers and the status code of the start_sql_tuning_task request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dm_sql_tuning_start_sql_tuning_task_response_t FORCE AUTHID CURRENT_USER IS OBJECT (
  response_body dbms_cloud_oci_database_management_sql_tuning_task_return_t,
  headers json_object_t,
  status_code number 
) NOT PERSISTABLE;

Fields

Contains the response body, headers and the status code of the validate_basic_filter request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dm_sql_tuning_validate_basic_filter_response_t FORCE AUTHID CURRENT_USER IS OBJECT (
  response_body dbms_cloud_oci_database_management_sql_tuning_set_admin_action_status_t,
  headers json_object_t,
  status_code number 
) NOT PERSISTABLE;

Fields