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