本地SQL使用UNION时速度特别慢,另一台服务器特别快,查到原因是sort_area_size太小了
太小还时不时会报ORA-17410: No more data to read from socket
Select name, value
FROM v$sysstat
where name like '%sort%'
select * from v$parameter
where name like '%sort%'
alter system set sort_area_size=65536 scope=spfile;
重启后生效
alter system set pga_aggregate_target=300m;
太小还时不时会报ORA-17410: No more data to read from socket
Select name, value
FROM v$sysstat
where name like '%sort%'
select * from v$parameter
where name like '%sort%'
alter system set sort_area_size=65536 scope=spfile;
重启后生效
alter system set pga_aggregate_target=300m;