4031 errors in 19.7
From: Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org>
Date: Mon, 1 Mar 2021 13:01:42 +0000
Message-ID: <DM6PR09MB4677FF2BE460638A316A50B1DF9A9_at_DM6PR09MB4677.namprd09.prod.outlook.com>
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?
Date: Mon, 1 Mar 2021 13:01:42 +0000
Message-ID: <DM6PR09MB4677FF2BE460638A316A50B1DF9A9_at_DM6PR09MB4677.namprd09.prod.outlook.com>
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-lReceived on Mon Mar 01 2021 - 14:01:42 CET