文本内容:
内存调优源代码conn sys/ldm assysdba;select1-phy.value/cur.value+con.value nCachHitRadio nfrom v$sysstat cur,v$sysstat con,v$sysstat phywhere cur.name=db blockgets*and con.name=consistent gets*and phy.name=physical reads1;select pool,sumbytes from v$sgastat wherepool=shared poll;group bypool;select name,pool,bytes fromv$sgastat wherename=Treee memory1;select to_charround1-sumgetmisses/sumgets*100,1||‘%’”hit radiofromv$rowcache;select sumgets,sumwaits,sumwaits/sumgets fromvrollsatat;。