You can analyze v$bh to check top consumers of buffer cache.
пт, 15 мар. 2019 г., 18:01 <Jay.Miller@xxxxxxxxxxxxxxxx>:
Yes, index and table blocks. No DDL for quite a while and no large DML
that I’ve been able to uncover.
No memory pool resizing since January 9, 2019.
Sr. Oracle DBA
*From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Sayan Malakshinov
*Sent:* Thursday, March 14, 2019 6:06 PM
*Subject:* Re: Keep buffer cache question
Have you checked what is it reading? Index blocks, table blocks or undo?
Were there any DDL or huge DML operations? Have you checked v$bh? What
about memory settings? AMM/ASMM/manual? Have you checked v$sga_resize_ops?
Oracle performance tuning engineer
Oracle ACE Associate