Database Tuning (MOSC)

MOSC Banner

**missing** owner in the segments by db block changes for temp tablespace

edited Nov 21, 2013 5:28AM in Database Tuning (MOSC) 6 commentsAnswered
I am getting an entry for the segment by db block changes with the following values in the AWR report:
Owner: **MISSING**
tablespace name: TEMP_TBLSPC
object_name: ** TRANSIENT: 25691776
subobject_name: ** MISSING **
object_type: UNDEFINED
db_block_changes : 3,408,304
%captured: 6.68.

I am not able to understand what does the object_name: ** TRANSIENT: 25691776 exactly means and why is the object_type undefined .

Any suggesting regarding the same is appreciated.

Regards,
Rohan

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