ITPub博客

首页 > Linux操作系统 > Linux操作系统 > db_cache hitratio sql and v$db_cache_advice and create table with storage

db_cache hitratio sql and v$db_cache_advice and create table with storage

原创 Linux操作系统 作者:tolilong 时间:2012-06-02 08:35:58 0 删除 编辑
select
(select value from v$sysstat where name='physical reads') phy ,
(select value from v$sysstat where name='db block gets') get,
(select value from v$sysstat where name='consistent gets') con_get,
(1-((select value from v$sysstat where name='physical reads')/
((select value from v$sysstat where name='db block gets')+(select value from v$sysstat where name='consistent gets')))) hit
from dual


select * from v$db_cache_advice



create table with storage parameter(buffer pool)
create table test(id number(4),name varchar2(50)) storage(buffer_pool keep/recycle)


_db_percent_hot_default (50)      The percent of buffers in the hot region
_db_aging_touch_time (3)            Seconds that must pass to increment touch count again
_db_aging_hot_criteria (2)            Threshold to move a buffer to the MRU end of LRU chain
_db_aging_stay_count (0)             Touch count reset to this when moved to MRU end
_db_aging_cool_count (1)             Touch count reset to this when moved to LRU end


获取隐藏参数sql:
  SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc describ
   FROM SYS.x$ksppi x, SYS.x$ksppcv y
   WHERE x.inst_id = USERENV ('Instance')
   AND y.inst_id = USERENV ('Instance')
   AND x.indx = y.indx
   AND x.ksppinm LIKE '%&par%';

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24237320/viewspace-731706/,如需转载,请注明出处,否则将追究法律责任。

下一篇: shared pool
请登录后发表评论 登录
全部评论

注册时间:2010-07-13

  • 博文量
    406
  • 访问量
    1009859