rendanic / rendanic.ansible_oracle / 4.0.0 / module / oracle_stats_prefs Manage DBMS_STATS global preferences | "added in version" 2.4 of rendanic.ansible_oracle" Authors: Ilmar Kerm, ilmar.kerm@gmail.com, @ilmarkerm preview | supported by communityrendanic.ansible_oracle.oracle_stats_prefs (4.0.0) — module
Install with ansible-galaxy collection install rendanic.ansible_oracle:==4.0.0
collections: - name: rendanic.ansible_oracle version: 4.0.0
Manage DBMS_STATS global preferences
Can be run locally on the controlmachine or on a remote host
--- - hosts: localhost vars: oraclehost: 192.168.56.102 oracleport: 1521 oracleservice: orcl oracleuser: system oraclepassword: oracle oracle_env: ORACLE_HOME: /usr/lib/oracle/12.1/client64 LD_LIBRARY_PATH: /usr/lib/oracle/12.1/client64/lib tasks: - name: set dbms_stats settings oracle_stats_prefs: hostname: "{{ oraclehost }}" port: "{{ oracleport }}" service_name: "{{ oracleservice }}" user: "{{ oracleuser }}" password: "{{ oraclepassword }}" pname: TABLE_CACHED_BLOCKS pvalue: 16 environment: "{{ oracle_env }}"
mode: choices: - normal - sysdba default: normal description: The mode with which to connect to the database required: true port: default: 1521 description: The listener port number on the host required: false user: description: 'The Oracle user name to connect to the database, must have DBA privilege ' required: false state: choices: - present - absent default: present description: 'Either to set the preference (present) or reset it to default (absent) ' required: true hostname: default: localhost description: The Oracle database host required: false password: description: The Oracle user password for 'user' required: false service_name: description: The database service name to connect to required: true preference_name: aliases: - pname description: DBMS_STATS preference name preference_value: aliases: - pvalue description: Preference value