Database - RAC/Scalability (MOSC)

MOSC Banner

how to check if rowid distributed table is fully loaded inmemory (IMDB)

edited Nov 3, 2015 10:17AM in Database - RAC/Scalability (MOSC) 3 commentsAnswered

Hi,

I have inmemory_size set in two of the three node rac. when load inmemory table, the v$im_segments shows

  INST_ID OWNER        SEGMENT_NAME      SEGSIZEMBINMEMMB  NOTPOPULATEDMB

---------- ----------------------------  -------------------- ---------- ---------- --------------

     3 scott          EMP         15042.4922 7073.5    8147.46094
     2 scott          EMP         15042.4922 8415.4375 6895.03125

How can we confirm that whole of EMP table is loaded inmemory? or if some part of EMP was not loaded into memory due to lack of memory or whatever reason ?

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