oracle / oracle.oci / 5.0.0 / module / oci_database_management_awr_db_sql_report_facts Fetches details about a AwrDbSqlReport resource in Oracle Cloud Infrastructure | "added in version" 2.9.0 of oracle.oci" Authors: Oracle (@oracle) preview | supported by communityoracle.oci.oci_database_management_awr_db_sql_report_facts (5.0.0) — module
Install with ansible-galaxy collection install oracle.oci:==5.0.0
collections: - name: oracle.oci version: 5.0.0
Fetches details about a AwrDbSqlReport resource in Oracle Cloud Infrastructure
Gets the SQL health check report for one SQL of the specific database.
- name: Get a specific awr_db_sql_report oci_database_management_awr_db_sql_report_facts: # required managed_database_id: "ocid1.manageddatabase.oc1..xxxxxxEXAMPLExxxxxx" awr_db_id: "ocid1.awrdb.oc1..xxxxxxEXAMPLExxxxxx" sql_id: "ocid1.sql.oc1..xxxxxxEXAMPLExxxxxx" # optional inst_num: inst_num_example begin_sn_id_greater_than_or_equal_to: 56 end_sn_id_less_than_or_equal_to: 56 time_greater_than_or_equal_to: 2013-10-20T19:20:30+01:00 time_less_than_or_equal_to: 2013-10-20T19:20:30+01:00 report_format: HTML container_id: 56
name: description: Use I(name) along with the other options to return only resources that match the given name exactly. type: str region: description: - The Oracle Cloud Infrastructure region to use for all OCI API requests. If not set, then the value of the OCI_REGION variable, if any, is used. This option is required if the region is not specified through a configuration file (See C(config_file_location)). Please refer to U(https://docs.us-phoenix-1.oraclecloud.com/Content/General/Concepts/regions.htm) for more information on OCI regions. type: str sql_id: description: - The parameter to filter SQL by ID. Note that the SQL ID is generated internally by Oracle for each SQL statement and can be retrieved from AWR Report API (/managedDatabases/{managedDatabaseId}/awrDbs/{awrDbId}/awrDbReport) or Performance Hub API (/internal/managedDatabases/{managedDatabaseId}/actions/retrievePerformanceData) required: true type: str tenancy: description: - OCID of your tenancy. If not set, then the value of the OCI_TENANCY variable, if any, is used. This option is required if the tenancy OCID is not specified through a configuration file (See C(config_file_location)). To get the tenancy OCID, please refer U(https://docs.us-phoenix-1.oraclecloud.com/Content/API/Concepts/apisigningkey.htm) type: str api_user: description: - The OCID of the user, on whose behalf, OCI APIs are invoked. If not set, then the value of the OCI_USER_ID environment variable, if any, is used. This option is required if the user is not specified through a configuration file (See C(config_file_location)). To get the user's OCID, please refer U(https://docs.us-phoenix-1.oraclecloud.com/Content/API/Concepts/apisigningkey.htm). type: str inst_num: description: - The optional single value query parameter to filter the database instance number. type: str auth_type: choices: - api_key - instance_principal - instance_obo_user - resource_principal - security_token default: api_key description: - The type of authentication to use for making API requests. By default C(auth_type="api_key") based authentication is performed and the API key (see I(api_user_key_file)) in your config file will be used. If this 'auth_type' module option is not specified, the value of the OCI_ANSIBLE_AUTH_TYPE, if any, is used. Use C(auth_type="instance_principal") to use instance principal based authentication when running ansible playbooks within an OCI compute instance. type: str awr_db_id: aliases: - id description: - 'The parameter to filter the database by internal ID. Note that the internal ID of the database can be retrieved from the following endpoint: /managedDatabases/{managedDatabaseId}/awrDbs' required: true type: str cert_bundle: description: - The full path to a CA certificate bundle to be used for SSL verification. This will override the default CA certificate bundle. If not set, then the value of the OCI_ANSIBLE_CERT_BUNDLE variable, if any, is used. type: str auth_purpose: choices: - service_principal description: - The auth purpose which can be used in conjunction with 'auth_type=instance_principal'. The default auth_purpose for instance_principal is None. type: str container_id: description: - 'The optional query parameter to filter the database container by an exact ID value. Note that the database container ID can be retrieved from the following endpoint: /managedDatabases/{managedDatabaseId}/awrDbSnapshotRanges' type: int report_format: choices: - HTML - TEXT description: - The format of the AWR report. type: str api_user_key_file: description: - Full path and filename of the private key (in PEM format). If not set, then the value of the OCI_USER_KEY_FILE variable, if any, is used. This option is required if the private key is not specified through a configuration file (See C(config_file_location)). If the key is encrypted with a pass-phrase, the C(api_user_key_pass_phrase) option must also be provided. type: str config_profile_name: description: - The profile to load from the config file referenced by C(config_file_location). If not set, then the value of the OCI_CONFIG_PROFILE environment variable, if any, is used. Otherwise, defaults to the "DEFAULT" profile in C(config_file_location). type: str managed_database_id: description: - The L(OCID,https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm) of the Managed Database. required: true type: str api_user_fingerprint: description: - Fingerprint for the key pair being used. If not set, then the value of the OCI_USER_FINGERPRINT environment variable, if any, is used. This option is required if the key fingerprint is not specified through a configuration file (See C(config_file_location)). To get the key pair's fingerprint value please refer U(https://docs.us-phoenix-1.oraclecloud.com/Content/API/Concepts/apisigningkey.htm). type: str config_file_location: description: - Path to configuration file. If not set then the value of the OCI_CONFIG_FILE environment variable, if any, is used. Otherwise, defaults to ~/.oci/config. type: str api_user_key_pass_phrase: description: - Passphrase used by the key referenced in C(api_user_key_file), if it is encrypted. If not set, then the value of the OCI_USER_KEY_PASS_PHRASE variable, if any, is used. This option is required if the key passphrase is not specified through a configuration file (See C(config_file_location)). type: str time_less_than_or_equal_to: description: - The optional less than or equal to query parameter to filter the timestamp. type: str time_greater_than_or_equal_to: description: - The optional greater than or equal to query parameter to filter the timestamp. type: str end_sn_id_less_than_or_equal_to: description: - The optional less than or equal to query parameter to filter the snapshot ID. type: int begin_sn_id_greater_than_or_equal_to: description: - The optional greater than or equal to filter on the snapshot ID. type: int realm_specific_endpoint_template_enabled: description: - Enable/Disable realm specific endpoint template for service client. By Default, realm specific endpoint template is disabled. If not set, then the value of the OCI_REALM_SPECIFIC_SERVICE_ENDPOINT_TEMPLATE_ENABLED variable, if any, is used. type: bool
awr_db_sql_report: contains: awr_result_type: description: - The result type of AWR query. returned: on success sample: AWRDB_SET type: str content: description: - The content of the report. returned: on success sample: content_example type: str db_query_time_in_secs: description: - The time taken to query the database tier (in seconds). returned: on success sample: 1.2 type: float format: description: - The format of the report. returned: on success sample: HTML type: str name: description: - The name of the query result. returned: on success sample: name_example type: str query_key: description: - The ID assigned to the query instance. returned: on success sample: query_key_example type: str version: description: - The version of the query result. returned: on success sample: version_example type: str description: - AwrDbSqlReport resource returned: on success sample: awr_result_type: AWRDB_SET content: content_example db_query_time_in_secs: 1.2 format: HTML name: name_example query_key: query_key_example version: version_example type: complex