oradb_manage_statspack

Manage Statspack in Oracle.

Not RAC aware at the moment.

Table of contents

Requirements

  • Minimum Ansible version: 2.16.0

Default Variables

purgedays

Global default variable for Statspack purgetime in days. Could be defined for each database with oracle_databases. An example is shown there.

Default value

purgedays: 35

purgeinterval

Global default variable for Statspack purge interval in scheduler job. Could be defined for each database with oracle_databases. An example is shown there.

Default value

purgeinterval: FREQ=daily;byhour=3;byminute=15;bysecond=0

snapinterval

Global default variable for Statspack snap interval in scheduler job. Could be defined for each database with oracle_databases. An example is shown there.

Default value

snapinterval: FREQ=hourly;byminute=0;bysecond=0

snaplevel

Global default variable for Statspack snaplevel. Could be defined for each database with oracle_databases. An example is shown there.

Default value

snaplevel: 7

Discovered Tags

spcreate
 Install Statspack in nonCDB, CDB or PDB

spdrop
 Remove Statspack from nonCDB, CDB or PDB

spjob
 Configure Statspack Scheduler Jobs

statspack
 Do all Tasks for Statspack

Dependencies

  • orasw_meta
  • oradb_facts

License

license (MIT)

Author

[Thorsten Bruhns]

Last modified October 30, 2026: ansible-core 2.16 is the new minimal version of ansible-oracle (requires_ansible in meta/runtime.yml, min_ansible_version of all roles) (2bffd9a3)