oracle-database-collection collection of Oracle Database tools, documentation and notes AWR By default, Oracle Database automatically generates snapshots of the performance data once every hour and retains the statistics in AWR for 8 days. STS A SQL tuning set (STS) is a database object that you can use as input to tuning tools.