oracle數(shù)據(jù)緩沖區(qū)優(yōu)化(存儲版)
【正文】 ysical reads39。 and =39。 from v$sysstat physical,v$sysstat direct,v$sysstat lobs,v$sysstat logical and =39。Buffer Cache Hit RatioNAME SIZE_FOR_ESTIMATE ESTD_PHYSICAL_READS DEFAULT 9514DEFAULT 9514DEFAULT 1680 9514DEFAULT 16 0DEFAULT 80 0DEFAULT 128 0DEFAULT 256 and =39。Buffer Cache Hit Ratio819239。滿足峰值的時候最大值select name,size_for_estimate,v$ fromv$db_cache_advice and =39。physical reads39。 0查看命中率 224 0DEFAULT 96 0DEFAULT 32 9514DEFAULT 1456 9514DEFAULT 9514DEFAULT and advice_status=39。 and =39。 2physical reads direct (lob)39。 from v$sysstat physical,v$sysstat direct,v$sysstat lobs,v$sysstat logical ON39。數(shù)據(jù)庫已經(jīng)打開。SQL startupORACLE 例程已經(jīng)啟動。session logical reads39。 5 1528 1 158800 1120 1 99250 560 1528 1 19850 系統(tǒng)已更改。 1040 49569438 560 67131735 39700 SIZE_FOR_ESTIMATE BUFFERS_FOR_ESTIMATE ESTD_PHYSICAL_READ_FACTOR ESTD_PHYSICAL_READS SQL set linesize 1000SQL select size_for_estimate, buffers_for_estimate ,ESTD_PHYSICAL_READ_factor,ESTD_PHYSICAL_READS from v$db_cache_advice and =39。physical reads39。physical reads direct39。獲取推薦的值select name,size_for_estimate,v$ from v$db_cache_advice
職業(yè)教育相關(guān)推薦
鄂ICP備17016276號-1