Database Administration (MOSC)

MOSC Banner

Questions about 12.1.0.2 sys.heatmap

edited Mar 14, 2015 10:01AM in Database Administration (MOSC) 8 commentsAnswered

Hi, DBAs

This is 12.1.0.2 on Oracle Linux 6.  The database is 3.5 TB, mostly read-only content loaded over a few days.  SYSAUX contains a 500 MB segment named SYS.HEATMAP, segment type system statistics.  I've not noticed this before; here, it's the largest segment in that tablespace.

Parameter heat_map=off in the database.  Other 12.1.0.2 databases also have a small segment named sys.heatmap, but these are less than 10 MB each.  A few questions:

How is sys.heatmap maintained?

Is sys.heatmap related to parameter heat_map?

How do I estimate how much should be in sys.heatmap?

The information I've seen on heatmap for the RDBMS is for the IM feature.  I'm wondering what else relies on sys.heatmap.

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