SGA heap latches
Date: Fri, 15 Apr 2022 13:25:06 +0200
Message-ID: <!&!AAAAAAAAAAAYAAAAAAAAAJxRhRLvfEhBnlOLJd92a2XCgAAAEAAAAGToXplfDMlCgu0OkfdpEqkBAAAAAA==_at_kbi-gmbh.de>
Hi,
env.: Solaris and RedHat8, Databases on Oracle 19.14
When starting databases, we get messages in alert.log:
Warning: due to streams pool size of 512MB and granule size of 512MB,
only using 1 of 7 SGA heap latches.
Other database:
Warning: due to streams pool size of 2560MB and granule size of 256MB,
only using 5 of 7 SGA heap latches.
Streams_pool_size is definied with 256M, sga_target and sga_limit is
definied with different sizes on different database, typically around 80 to
200 G.
Question: what does this warning mean, any negative impact ? How to prevent
this message ?
I have an SR open at Oracle, however they are not very helpful ("this is
only a warning, you simply can ignore it"). However, my guess is that this
warning is not simply made just for fun, so I like to know something about
the background.
Any information or documentation available?
Thanks and best regards
Willy
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 15 2022 - 13:25:06 CEST