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 JUNE 24, 2019

Applies to:

Autonomous Data Warehouse - Version N/A to N/A
Autonomous Transaction Processing - Version NA to NA [Release NA]
Information in this document applies to any platform.

Goal

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 :
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-service.html#GUID-ED34ED88-BC9F-4C1A-B05A-C8E876B1B248


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

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

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