Home -> Mailing Lists -> Oracle-L -> RE: 4031 errors in 19.7

RE: 4031 errors in 19.7

From: Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org>
Date: Mon, 1 Mar 2021 16:03:11 +0000
Message-ID: <DM6PR09MB4677E399307A082D76906759DF9A9_at_DM6PR09MB4677.namprd09.prod.outlook.com> 






From the trace file. What could cause the KGH area to be so large?



TOP 10 MEMORY USES FOR SGA HEAP





"KGH: NO ACCESS 0001" 1195 MB 40%


"SQLA 0003" 507 MB 17%


"free memory " 356 MB 12%

"KGLH0 0003" 270 MB 9%


"KGLS 0003" 70 MB 2%


"KGLHD 0003" 47 MB 2%


"PLMCD 0003" 40 MB 1%


"KQR X PO 0003" 38 MB 1%


"KGLH0 0001" 34 MB 1%



"SO private sga 0001" 32 MB 1%



TOTALS ---------------------------------------


Total free memory 356 MB


Total memory alloc. 2668 MB


Grand total 3024 MB



-----Original Message-----


From: Petr Novak <Petr.Novak_at_trivadis.com> 
Sent: Monday, March 01, 2021 8:22 AM


To: oracle-l_at_freelists.org; Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org>
Subject: AW: 4031 errors in 19.7



Hallo Jeff,



I had similar experience . After upgrade from 12.2 single tenant to 19c multitenant the  SQLArea was much smaller for same shared pool size.
In  AWR  the difference between shared pool size in DBA_HIST_MEM_DYNAMIC_COMP  - sum( Shared Pool components) from DBA_HIST_SGASTAT increased  after upgrade for the DB with 400G sga_target from 6G to 35G.   May be some internal memory structures related to multitenant ? For 19c single tenant this difference was almost same as under 12c



Best Regards


Petr







Von: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> im Auftrag von Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org>
Gesendet: Montag, 1. März 2021 14:01


An: oracle-l_at_freelists.org


Betreff: 4031 errors in 19.7



Since upgrading our Oracle EBS 12.1.3 IT Test system to 19.7 mutltenant from 11.2.0.4. We have been experiencing shared pool errors. After the last one, we increased sga_target to 1 G larger than we had in 11g. However, we just experienced another 4031 error. The IT database only has the EBS concurrent managers running and very other light activity. The error occurred on Saturday when only thing else running was stats. Does 19c multitenant require a much larger sga_target?



Jeffrey Beckstrom


Greater Cleveland Regional Transit Authority
1240 W. 6th Street


Cleveland, Ohio 44113


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


Received on Mon Mar 01 2021 - 17:03:11 CET












Original text of this message