My Oracle Support Banner

ADW / ATP How to change the retention period for Service console (CPU Utilization,Database Activity,etc) to retain more data (Doc ID 2521386.1)

Last updated on FEBRUARY 27, 2022

Applies to:

Autonomous Database on Shared Infrastructure - Version N/A to N/A
Autonomous Transaction Processing - Version NA to NA [Release NA]
Information in this document applies to any platform.


This note was created to demonstrate how to increase the retention period for performance historical information from 8 days (default) to 30 days in Service Console >Activity page
Activity page shows real-time and historical information about the utilization of the service.
This apply for both ADW and ATP services

How to access Service Console refer to :

From Service Console > Activity > Time period  you can monitor the following for a given period of time .

-Database Activity
-CPU Utilization
-Running Statements
-Queued Statements

The default retention period for performance data is 8 days



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

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