加大session的排序区
alter session set sort_area_size = 100000000;
alter session set sort_area_retained_size = 100000000;
alter session set sort_multiblock_read_count = 128;
alter session set db_file_multiblock_read_count = 128;
analyze table TABLE_NAME compute statistics;
alter session set sort_area_size = 100000000;
alter session set sort_area_retained_size = 100000000;
alter session set sort_multiblock_read_count = 128;
alter session set db_file_multiblock_read_count = 128;
analyze table TABLE_NAME compute statistics;
扫一扫
736
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
