Database Memory & 4030/4031 (MOSC)

MOSC Banner

pool and cache usage

I'm debugging some memory issue and I ran across some check to debug that issue, but my question is how useful these checks are, and if the values as shown learn something.

Note this is a situation when the issue does NOT occur, but on the database that is having the issue.

So, is this a relevant check ? What am I looking for ? Are these value good ?

SYS> select con_id,component,min_size,max_size,current_size,last_oper_type,oper_count from v$memory_dynamic_components where last_oper_type in ('GROW','SHRINK')
order by 1,2;

CON_ID COMPONENT                  MIN_SIZE   MAX_SIZE CURRENT_SIZE LAST_OPER_TYP OPER_COUNT

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