My Oracle Support Banner

DB 19c: How To Store AWR Snapshots In User Defined Tablespace (Doc ID 2871566.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.0.0.0 and later
Information in this document applies to any platform.

Goal

The AWR warehouse is built in the SYS schema, using the SYSAUX tablespace by default. Oracle Database, by default captures snapshots once every hour; the snapshot size varies depending on the database load. These snapshots will be stored in SYSAUX tablespace.

Starting with Oracle Database 19.1c, the user can specify a user defined tablespace for AWR data/snapshots by using the 'dbms_workload_repository.modify_snapshot_settings' procedure, using 'tablespace_name' parameter.

This document shows how to change the AWR snapshot storage from SYSAUX to user defined tablespace.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.