My Oracle Support Banner

EM 13.4: 'sga_pool_wastage_10i' metric collection is failing with ORA-06502 error for 19C DB target (Doc ID 2763136.1)

Last updated on MARCH 20, 2024

Applies to:

Enterprise Manager for Oracle Database - Version 13.4.1.0.0 and later
Information in this document applies to any platform.

Symptoms

'sga_pool_wastage_10i' (SGA Pool Wastage) DB metric collection is failing for 19C (19.9) non-CDB 2-node RAC DB target in OEM 13.4 with 'ORA-06502: PL/SQL: numeric or value error' error :

$AGENT_HOME/bin/emctl control agent runCollection <Database_name>:oracle_database sga_pool_wastage_10i
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
EMD runCollection error:
sga_pool_wastage_10i:sga_pool_wastage:ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 14
ORA-06512: at line 14

Changes

 

Cause

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
Symptoms
Changes
Cause
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.