Enterprise Manager Generic (MOSC)

MOSC Banner

Tablespace % used metric - limits?

edited Oct 21, 2015 7:18AM in Enterprise Manager Generic (MOSC) 7 commentsAnswered ✓

Using agent 12.1.0.4.10, emcc 12.1.0.4(?) on an instance with lots of tablespaces, not seeing that the %full metric is working for all tablespaces, posting a snippet from gcagent.log:

====

...

<timestamp> ...columns: [name:STRING, pctUsed:NUMERIC, bytesFree:NUMERIC] rows: {

,,,

#109=<SYSAUX,64.37,1781.5>,#110=<SYSTEM,36.7359375,2530.5625>...

====

And the emcc All Metrics page seems to confirm that, only 110 tablespaces show on the metric threshold "add" tablespace button. Total tablespace count is 180 including temp, undo. Have not installed agent db plugins, is that what we're missing?

Edit: add result snippets from one (plus and an outer join too) of the queries in note 1541511.1

====

SELECT TABLESPACE_NAME TBSP_NAME

, USED_SPACE

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center