My Oracle Support Banner

How to Interpret Output From Database_analysis.sh (Doc ID 1624811.1)

Last updated on OCTOBER 14, 2016

Applies to:

Enterprise Manager Ops Center - Version 12C to 12C [Release 12.0]
Information in this document applies to any platform.

Goal

We are running Ops Center against our ExaLogic servers. We did have an issue previously with out Ops Center database getting full. We ran database_analysis.sh after backing up our database at the instruction  from Oracle. Now I need to interpret which data we will loose based upon the following output:

No cache file found - reading from DB... (next run will be much faster)
Please wait, analyzing 'rm_resource_daily_trend' - TOP 20 attributes... (this can take hours on a large DB)


The following are the top monitored data DB consumers:

1) OS_NetworkUsage 317457
2) OS_InterfaceUsageIoErrorPercentage 289629
3) OS_InterfaceUsageOutputErrors 289629
4) OS_InterfaceUsageInputErrors 289629
5) OS_InterfaceUsageCollisions 289629
6) OS_InterfaceUsageIoAverage 289628
7) OS_InterfaceUsageInputAverage 289618
8) OS_NetworkUsagePercentage 109940
9) OS_SystemLoadAverage 83571
10) OS_SystemLoadAvr 83571
11) OS_InterfaceUsageIoAveragePercentage 82109
12) OS_FileSystemUsageFree 52475
13) OS_FileSystemUsagePercentage 52475
14) OS_FileSystemUsage 52475
15) OS_FileSystemUsageFreePercentage 52475
16) OS_FileSystemUsageTotalSpace 52475
17) OS_FileSystemReachable 43189
18) OS_DiskUsageBusyPercentage

 

 

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.