oracle / oracle.oci / 4.2.0 / module / oci_database_management_tablespace_facts Fetches details about one or multiple Tablespace resources in Oracle Cloud Infrastructure | "added in version" 2.9.0 of oracle.oci" Authors: Oracle (@oracle) preview | supported by communityoracle.oci.oci_database_management_tablespace_facts (4.2.0) — module
Install with ansible-galaxy collection install oracle.oci:==4.2.0
collections: - name: oracle.oci version: 4.2.0
Fetches details about one or multiple Tablespace resources in Oracle Cloud Infrastructure
Gets the list of tablespaces for the specified managedDatabaseId.
If I(tablespace_name) is specified, the details of a single Tablespace will be returned.
- name: Get a specific tablespace oci_database_management_tablespace_facts: # required tablespace_name: tablespace_name_example managed_database_id: "ocid1.manageddatabase.oc1..xxxxxxEXAMPLExxxxxx"
- name: List tablespaces oci_database_management_tablespace_facts: # required managed_database_id: "ocid1.manageddatabase.oc1..xxxxxxEXAMPLExxxxxx" # optional name: name_example sort_by: TIMECREATED sort_order: ASC
name: description: - A filter to return only resources that match the entire name. 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 sort_by: choices: - TIMECREATED - NAME description: - The field to sort information by. Only one sortOrder can be used. The default sort order for 'TIMECREATED' is descending and the default sort order for 'NAME' is ascending. The 'NAME' sort order is case-sensitive. 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 auth_type: choices: - api_key - instance_principal - instance_obo_user - resource_principal 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 sort_order: choices: - ASC - DESC description: - The option to sort information in ascending ('ASC') or descending ('DESC') order. Ascending order is the default order. 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 tablespace_name: description: - The name of the tablespace. - Required to get a specific tablespace. 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
tablespaces: contains: allocated_size_kb: description: - The allocated tablespace size in KB. returned: on success sample: 10 type: float allocation_type: description: - The type of extent allocation in effect for the tablespace. returned: on success sample: SYSTEM type: str block_size_bytes: description: - The tablespace block size. returned: on success sample: 10 type: float compress_for: description: - The operation type for which default compression is enabled. returned: on success sample: BASIC type: str datafiles: contains: allocated_size_kb: description: - The allocated file size in KB. returned: on success sample: 10 type: float free_space_kb: description: - The free space available in the data file in KB. returned: on success sample: 10 type: float increment_by: description: - The number of blocks used as auto-extension increment. returned: on success sample: 10 type: float instance_id: description: - Instance ID of the instance to which the temp file belongs. This column has a NULL value for temp files that belong to shared tablespaces. returned: on success sample: 10 type: float is_auto_extensible: description: - Indicates whether the data file is auto-extensible. returned: on success sample: true type: bool lost_write_protect: description: - The lost write protection status of the file. returned: on success sample: ENABLED type: str max_size_kb: description: - The maximum file size in KB. returned: on success sample: 10 type: float name: description: - The filename (including the path) of the data file or temp file. returned: on success sample: name_example type: str online_status: description: - The online status of the file. returned: on success sample: SYSOFF type: str shared: description: - Type of tablespace this file belongs to. If it's for a shared tablespace, for a local temporary tablespace for RIM (read-only) instances, or for local temporary tablespace for all instance types. returned: on success sample: SHARED type: str status: description: - The status of the file. INVALID status is used when the file number is not in use, for example, a file in a tablespace that was removed. returned: on success sample: AVAILABLE type: str used_percent_allocated: description: - The percentage of used space out of the total allocated space in the file. returned: on success sample: 1.2 type: float used_percent_available: description: - The percentage of used space out of the maximum available space in the file. returned: on success sample: 1.2 type: float used_space_kb: description: - The total space used in the data file in KB. returned: on success sample: 10 type: float user_size_kb: description: - The size of the file available for user data in KB. The actual size of the file minus the USER_BYTES value is used to store file- related metadata. returned: on success sample: 10 type: float description: - A list of the data files associated with the tablespace. returned: on success type: complex default_cell_memory: description: - This specifies the default value for the CELLMEMORY attribute that tables created in the tablespace will inherit unless the behavior is overridden explicitly. This column is intended for use with Oracle Exadata. returned: on success sample: default_cell_memory_example type: str default_in_memory: description: - Indicates whether the In-Memory Column Store (IM column store) is by default enabled or disabled for tables in the tablespace. returned: on success sample: ENABLED type: str default_in_memory_compression: description: - Indicates the default compression level for the IM column store for the tablespace. returned: on success sample: NO_MEMCOMPRESS type: str default_in_memory_distribute: description: - Indicates how the IM column store is distributed by default for the tablespace in an Oracle Real Application Clusters (Oracle RAC) environment. returned: on success sample: AUTO type: str default_in_memory_duplicate: description: - Indicates the duplicate setting for the IM column store in an Oracle RAC environment. returned: on success sample: NO_DUPLICATE type: str default_in_memory_priority: description: - Indicates the default priority for In-Memory Column Store (IM column store) population for the tablespace. returned: on success sample: LOW type: str default_in_memory_service: description: - Indicates how the IM column store is populated on various instances by default for the tablespace. returned: on success sample: DEFAULT type: str default_in_memory_service_name: description: - Indicates the service name for the service on which the IM column store should be populated by default for the tablespace. This column has a value only when the corresponding DEF_INMEMORY_SERVICE is USER_DEFINED. In all other cases, this column is null. returned: on success sample: default_in_memory_service_name_example type: str default_index_compression: description: - Indicates whether default index compression is enabled or disabled. returned: on success sample: ENABLED type: str default_table_compression: description: - Indicates whether default table compression is enabled or disabled. returned: on success sample: ENABLED type: str extent_management: description: - Indicates whether the extents in the tablespace are Locally managed or Dictionary managed. returned: on success sample: LOCAL type: str free_space_kb: description: - The free space available in the tablespace in KB. returned: on success sample: 10 type: float index_compress_for: description: - The operation type for which default index compression is enabled. returned: on success sample: ADVANCED_LOW type: str is_bigfile: description: - Indicates whether the tablespace is a Bigfile tablespace or a Smallfile tablespace. returned: on success sample: true type: bool is_chunk_tablespace: description: - Indicates whether this is a chunk tablespace. returned: on success sample: true type: bool is_default: description: - Indicates whether this is the default tablespace. returned: on success sample: true type: bool is_encrypted: description: - Indicates whether the tablespace is encrypted. returned: on success sample: true type: bool is_force_logging: description: - Indicates whether the tablespace is under Force Logging mode. returned: on success sample: true type: bool is_plugged_in: description: - Indicates whether the tablespace is plugged in. returned: on success sample: true type: bool logging: description: - The default logging attribute. returned: on success sample: LOGGING type: str lost_write_protect: description: - The lost write protection setting for the tablespace. returned: on success sample: ENABLED type: str max_size_kb: description: - The maximum tablespace size in KB. If the tablespace contains any data files with Autoextend enabled, then this column displays the amount of underlying free storage space for the tablespace. For example, if the current tablespace size is 1 GB, the combined maximum size of all its data files is 32 GB, and its underlying storage (for example, ASM or file system storage) has 20 GB of free space, then this column will have a value of approximately 20 GB. If the tablespace contains only data files with autoextend disabled, then this column displays the allocated space for the entire tablespace, that is, the combined size of all data files in the tablespace. returned: on success sample: 10 type: float name: description: - The name of the tablespace. returned: on success sample: name_example type: str predicate_evaluation: description: - Indicates whether predicates are evaluated by Host or by Storage. returned: on success sample: HOST type: str retention: description: - Indicates whether undo retention guarantee is enabled for the tablespace. returned: on success sample: GUARANTEE type: str segment_space_management: description: - Indicates whether the free and used segment space in the tablespace is managed using free lists (MANUAL) or bitmaps (AUTO). returned: on success sample: MANUAL type: str shared: description: - Indicates whether the tablespace is for shared tablespace, or for local temporary tablespace for leaf (read-only) instances, or for local temporary tablespace for all instance types. returned: on success sample: SHARED type: str status: description: - The status of the tablespace. returned: on success sample: ONLINE type: str temp_group: description: - The temporary tablespace group. returned: on success sample: temp_group_example type: str type: description: - The type of tablespace. returned: on success sample: UNDO type: str used_percent_allocated: description: - The percentage of used space out of the total allocated space in the tablespace. returned: on success sample: 1.2 type: float used_percent_available: description: - The percentage of used space out of the maximum available space in the tablespace. returned: on success sample: 1.2 type: float used_space_kb: description: - The total space used by the tablespace in KB. returned: on success sample: 10 type: float user_size_kb: description: - The size of the tablespace available for user data in KB. The difference between tablespace size and user data size is used for storing metadata. returned: on success sample: 10 type: float description: - List of Tablespace resources returned: on success sample: - allocated_size_kb: 10 allocation_type: SYSTEM block_size_bytes: 10 compress_for: BASIC datafiles: - allocated_size_kb: 10 free_space_kb: 10 increment_by: 10 instance_id: 10 is_auto_extensible: true lost_write_protect: ENABLED max_size_kb: 10 name: name_example online_status: SYSOFF shared: SHARED status: AVAILABLE used_percent_allocated: 1.2 used_percent_available: 1.2 used_space_kb: 10 user_size_kb: 10 default_cell_memory: default_cell_memory_example default_in_memory: ENABLED default_in_memory_compression: NO_MEMCOMPRESS default_in_memory_distribute: AUTO default_in_memory_duplicate: NO_DUPLICATE default_in_memory_priority: LOW default_in_memory_service: DEFAULT default_in_memory_service_name: default_in_memory_service_name_example default_index_compression: ENABLED default_table_compression: ENABLED extent_management: LOCAL free_space_kb: 10 index_compress_for: ADVANCED_LOW is_bigfile: true is_chunk_tablespace: true is_default: true is_encrypted: true is_force_logging: true is_plugged_in: true logging: LOGGING lost_write_protect: ENABLED max_size_kb: 10 name: name_example predicate_evaluation: HOST retention: GUARANTEE segment_space_management: MANUAL shared: SHARED status: ONLINE temp_group: temp_group_example type: UNDO used_percent_allocated: 1.2 used_percent_available: 1.2 used_space_kb: 10 user_size_kb: 10 type: complex