Re: Keep buffer cache question

Hi Jay,

You can analyze v$bh to check top consumers of buffer cache.

пт, 15 мар. 2019 г., 18:01 <Jay.Miller_at_tdameritrade.com>:

> 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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Sayan Malakshinov
> *Sent:* Thursday, March 14, 2019 6:06 PM
> *To:* dmarc-noreply_at_freelists.org
> *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=>
>

--
http://www.freelists.org/webpage/oracle-l