Oracle 11g通过提高IO吞吐量（修改_db_file_optimizer_read_count）来优化全表扫描

最新推荐文章于 2021-04-05 09:32:57 发布

blockheading

最新推荐文章于 2021-04-05 09:32:57 发布

阅读量914

点赞数

分类专栏： Oracle Performance 文章标签：优化 oracle 11g

本文链接：https://blog.csdn.net/u013169075/article/details/71908127

版权

--Oracle 11g通过提高IO吞吐量（修改_db_file_optimizer_read_count）来优化全表扫描

SYS@PROD1> select ksppinm, indx from x$ksppi where ksppinm like '%db_file_optimi%';

KSPPINM 			     INDX
------------------------------ ----------
_db_file_optimizer_read_count	     1074

SYS@PROD1> select ksppstdvl from x$ksppcv where indx=1074;

KSPPSTDVL
----------------------------------------------------------------------------------------------------
8

--实验表
SYS@PROD1> select count(*) from tt;

  COUNT(*)
----------
    480000
	
SYS@PROD1> select count(*) from tt;  --默认值为8时的开销

Execution Plan
----------------------------------------------------------
Plan hash value: 3133740314

-------------------------------------------------------------------
| Id  | Operation	   | Name | Rows  | Cost (%CPU)| Time	  |
-------------------------------------------------------------------
|   0 | SELECT STATEMENT   |	  |	1 |  1546   (1)| 00:00:01 |