oracle數(shù)據(jù)緩沖區(qū)優(yōu)化(編輯修改稿)
2025-07-25 08:29 本頁面
【文章內(nèi)容簡介】 。 1 1528 720 89325 1 1528 800 99250 1 1528 880 109175 1 1528SIZE_FOR_ESTIMATE BUFFERS_FOR_ESTIMATE ESTD_PHYSICAL_READ_FACTOR ESTD_PHYSICAL_READS 960 119100 1 1528 1040 129025 1 1528 1120 138950 1 1528 1200 148875 1 1528 1280 158800 1 1528 1360 168725 1 1528 1440 178650 1 1528 1520 188575 1 1528 1600 198500 1 1528命中率降低了？ SQL select 1 (( ) / ) 2 Buffer Cache Hit Ratio 3 from v$sysstat physical,v$sysstat direct,v$sysstat lobs,v$sysstat logical 4 where = 39。physical reads39。 5 and =39。physical reads direct39。 6 and =39。physical reads direct (lob)39。 7 and =39。session logical reads39。Buffer Cache Hit Ratio .906673167繼續(xù)縮小SGA大小SQLalter system set SGA_MAX_SIZE=3000M scope=spfile。 SQL shutdown immediate數(shù)據(jù)庫已經(jīng)關(guān)閉。已經(jīng)卸載數(shù)據(jù)庫。ORACLE 例程已經(jīng)關(guān)閉。SQL startupORACLE 例程已經(jīng)啟動。Total System Global Area 3155661888 bytesFixed Size 734272 bytesVariable Size 2315255808 bytesDatabase Buffers 838860800 bytesRedo Buffers 811008 bytes數(shù)據(jù)庫裝載完畢。數(shù)據(jù)庫已經(jīng)打開。select size_for_estimate, buffers_for_estimate ,ESTD_PHYSICAL_READ_factor,ESTD_PHYSICAL_READS from v$db_cache_advice where block_size=39。819239。 and advice_status=39。ON39。繼續(xù)測試：等待30分鐘之后測試 SQL alter sy
職業(yè)教育相關(guān)推薦
鄂ICP備17016276號-1