系统负载并不大。先把topSQL中%Total超过10%的SQL优化下吧

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
270,826,343	10,245	26,434.98	12.97	1,340.13	99.4	0	b5xwjc778pgnj	oracle@zbgdb1	select caseggyyws0_.id as id31...


Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
16,034,160	6	2,672,360.00	61.93	177.97	59.42	39.08	07a7pxb58hu3k	oracle@zbgdb1	select nvl( max( GXSJC) , to_d...


UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Opt	%Total	SQL Id	SQL Module	SQL Text
1,241,452	1,241,452	159	7,807.87	0.00	86.85	6yfum32nb80kr	godror : v0.20.1	SELECT JSON_ARRAYAGG( JSON_OB...

根据提供的 AWR 报告来看，系统整体的负载不大，主要问题集中在 SQL 上，所以才出现 行锁，回表，全表扫等问题，和开发沟通优化 top SQL.其他问题等待大佬解答。