Oracle Performance Optimization-sorting area Adjustment

Oracle Performance Optimization-sort area adjustment: select name, value from v $ sysstat where name like '% sort %'; sorts (memory) indicates the memory sort volume, sorts (disk) indicates the disk order. Www.2cto.com Failure Rate = sort (disks)/sorts (memory) × 100% the failure rate of the sorting area cannot be less than 5%. Otherwise, you must increase the sort_area_size so that Oracle uses memory sorting as much as possible. Disk IO adjustment is to place data files on multiple different disks. Reduce the number of IO operations to reduce the CPU requirements. The following are some of my actual operations: alter system db_cache_size = 256000000 scope = spfile; alter system open_cursors = 800 scope = spfile; alter system pga_aggregate_target = 128000000 scope = spfile; alter system sort_area_size = 52428800 scope = spfile; alter system sga_max_size = 1024000000 scope = spfile; alter system shared_pool_size = 256000000 scope = spfile; restart Oracle. Note that the memory configured here is 4 GB.