Hi Jay,
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.
Jay Miller
Sr. Oracle DBA
201.369.8355
*From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Sayan Malakshinov
*Sent:* Thursday, March 14, 2019 6:06 PM
*To:* dmarc-noreply@xxxxxxxxxxxxx
*Cc:* ORACLE-L
*Subject:* Re: Keep buffer cache question
Hi Jay,
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?
--
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org
<https://urldefense.proofpoint.com/v2/url?u=http-3A__orasql.org&d=DwMFaQ&c=nulvIAQnC0yOOjC0e0NVa8TOcyq9jNhjZ156R-JJU10&r=aiKV3Uv2Wo7GqYQcis9TSvB1MZslPOnintrOY1rjG58&m=y-UF_JpJGTABLm5TmUHndm9ytZLICmx2FNZGBXJNiWY&s=rGHmLD6iEx3nrKyoWoywLbo35y00PQ7_jfalmKciyNE&e=>